RE: ODBC Connection to AS/400

There are a number of options besides ODBC and OLEDB you could use including
data queues, sockets programs, JDBC, etc. However, JDBC is the only other
one I can think of (I'm sure there are others) that doesn't require[1]
server-side programming.

We use OLEDB with great success. However, I will say we use Hit Software's
OLEDB driver, not IBMs. We've found it to be smaller and faster[2].

Part of the decision should also be what are you going to use to access ODBC
or OLEDB? In both cases you could program directly to the API, but I
wouldn't. If you're using ADO then OLEDB will be faster, all things being
equal since ADO is a wrapper over OLEDB and RDO will be faster for ODBC.
Now, you can use ADO for ODBC, but you need to go through MS's OLEDB driver
for ODBC which adds a layer.

-Walden

[1] I said "require" not "should use." I believe all apps should use
server-side code for business logic, but that's another story.

[2] We're nothing more than a happy customer.

------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@TechSoftInc.com
http://www.TechSoftInc.com

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)



-----Original Message-----
From: Eric Graeb [mailto:eric_graeb@kingoptical.com]
Sent: Friday, August 16, 2002 10:01
To: MIDRANGE-L@midrange.com
Subject: ODBC Connection to AS/400


I was wondering what the world is using to access 400 data from a PC in Real
Time.  I know of 2 options: 1.ODBC, 2.OLE DB From what I've seen ODBC is
really slow so I was wondering what those who use OLE DB think of it.  Is it
faster? Are there any other options besides these?

Eric Graeb
AS/400 Administrator
King Optical Group Inc.

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.