Re: 32-bit ODBC

[Vern Hamberg <hambergv@xxxxxxxxxxxxxx>]

Thou fellow Frostbite Fallsian,

At 05:14 PM 11/2/97 -0600, Joe Teff wrote:
>We will be upgrading all PC's that still run Windows 3x to Windows 95 in
the near future. At that time, we will want to upgrade all of the ODBC
drivers from 16-bit to 32-bit and change our quote program to VB 5.0. The
PCs and AS/400 are connected by Ethernet and Netsoft. The AS/400 is at V3R1
but will be upgraded to V3R2 in the near future. I'm looking for
recommendations for 32-bit ODBC drivers as far as speed, reliability,
efficiency and ease of use. Thanks.

We're using CA95/NT for this. The ODBC driver, IMO, is very good. It's ODBC
level2 compliant, it can handle 16-bit ODBC, it takes advantage of SQL
packages on the 400, to improve performance. The main drawback is that it
can't be installed independently—you have to install at least the Base
component of CA.

In addition, it is basically free with OS/400 v3r7 and later. With v3r2or
less, once you've paid for one license per 400, you can install
non-licensed parts of CA all you want.

BTW, I can't recommend strongly enough that you move to TCP/IP
connectivity. It's native on both Win95 and the 400. OTOH, CA supports
native IPX connectivity, too, as does the 400 now.

HTH

Vernon Hamberg
Systems Software Programmer
Old Republic National Title Insurance Company
400 Second Avenue South
Minneapolis, MN  55401-2499
(612) 371-1111 x480


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to "MIDRANGE-L@midrange.com".
| To unsubscribe from this list send email to MAJORDOMO@midrange.com
|    and specify 'unsubscribe MIDRANGE-L' in the body of your message.
| Questions should be directed to the list owner/operator: david@midrange.com
+---