DataGate has long been a part of the ASNA product set from my
understanding. I believe they have their own proprietary DB access
layer.
Nothing against ASNA or RPG, but why don't you just skip ASNA/RPG and
learn VB.Net directly.
The IBM OLEDB driver supports SQL, record level access, CL commands and
remote program calls.
ASNA compiles into .Net from my understanding anyway so go with a
mainstream .Net language.
I love RPG, but if you're going to .Net for the iSeries, GO to .Net :-)
My two cents.........
Regards,
Richard Schoen
RJS Software Systems Inc.
"Get the information you need. Now!"
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 898-3038
Fax: (952) 898-1781
Toll Free: (888) RJSSOFT
-----Original Message-----
message: 2
date: Wed, 28 May 2008 05:59:02 +0000
from: Larry Ducie <larry_ducie@xxxxxxxxxxx>
subject: How does ANSA DataGate communicate with the System i DB?
Hey guys,
Not sure if this is the right forum, but we are thinking of looking at
the ANSA DataGate product. I understand that it has its own subsystem
and acts as a form of middleware between the .NET framework and the DB
on the System i, but I was wondering how it does that. Does it use SQL
CLI, or a native jdbc driver, or odbc..?
We have been told it is really quick and supports record level access
and I'm wondering how it does this, other than using jdbc and the native
jt400 driver. Unless it is a proprietary implementation which uses
native code (written in C maybe).
There are rumors circulating the office that it uses calls directly
below the MI. :-)
Any and all information would be most useful.
Cheers
Larry Ducie
midrange.com
