× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.