16 bit SQL Driver VS 32 bit SQL Driver

16 bit SQL Driver VS 32 bit SQL Driver

Post by Duane Edd » Tue, 15 Sep 1998 04:00:00

We are currently in the process of upgrading the database system of a 16
bit app written in VB3 from Win NT 3.51/SQL Server 4.2 to Win NT 4.0/SQL
Server 6.5 with a 32 bit ODBC connection, and we are getting errors when
after a query is run and trying to return the results.  All fields come
back fine execept TEXT fields.  Are there any known issues with SQL
Server text fields between the 16 bit ODBC driver and the 32 bit ODBC

1. ODBC driver installation conflicts (between 16 bit and 32 bit drivers) on NT

: Hi there,
: we've installed the Oracle ODBC driver two weeks ago (the one which
: came with the Oracle Workgroupserver 90 day trial edition). After we
: deinstalled this we have trouble installing Microsofts new ODBC
: drivers. I guess the trouble lies in the conflict that there are two

NT supports both the 16bit ODBC subsystem, which uses the usual config
files (ODBC.INI and ODBCINST.INI), and the 32bit subsystem, which
uses the registry.

To get rid of 16bit files, examine the .INI files and delete all
.DLLs specified by the various settings for the appropriate drivers,
then remove the driver entries from both ODBC.INI and ODBCINST.INI.

To get rid of 32bit files you'll need to use REGEDT32 and find the
appropriate ODBC entries. Remove the .DLL files specified by
the ODBC entries, then remove the registry entries. The usual
caveats re: mucking with the registry apply.

Oracle's workgroup drivers are 16bit, if I remember correctly, so
they should be installed using the appropriate version of ORAINST. Any
32bit drivers are best installed either using the 32bit version of
ODBCADM or through the control panel ODBC applet - if the driver
diskettes include an ODBC.INF file. If they don't, you'll just have
to trust that the installation program uses the 32bit routines...


Fax: +358 0 33 88 22                                    " Why me? "

2. about sp

3. "Record/Key Deleted" BDE Error

4. 16-bit/32-bit ODBC drivers - NT Environment

5. Web-based software application Eng.

6. Using 16 bit application with 32 Bit drivers

7. DSA 7.13: VP question

8. 16 bit ODBC drivers in the 32 bit environment

9. 32 bit BDE with 16 bit ODBC Drivers

10. 16 Bit app trying to access 32 bit ODBC driver

11. ODBC - Driver for 16-Bit and 32-Bit Windows NT Applikations

12. ODBC driver 16 vs 32 bit