How to access Sql Server 7.0 using 16-bit ODBC drivers 
Author Message
 How to access Sql Server 7.0 using 16-bit ODBC drivers
Are there any known problems accessing Sql Server 7.0
using 16-bit ODBC?  We are upgrading from Sql Server 6.5,
and I seem to be having problems (especially executing
stored procedures).  I have a large VB3 program that must
be moved on short notice, and the current database resides
on sql server 6.5, and the target database is on sql
server 7.0

If sql server 7.0 cannot be accessed with the 16-bit ODBC,



Mon, 17 Jan 2005 01:39:59 GMT
 How to access Sql Server 7.0 using 16-bit ODBC drivers

Mike,

Did a little digging and found the following link:
http://www.mssqlserver.com/faq/connect-dblib.asp

Apparently it is possible, however I would not recommend this solution. Port
your application and ODBC to a 32 bit platform. Consider replacing ODBC with
OLEDB for a more scalable solution.

Steve

Quote:
> Are there any known problems accessing Sql Server 7.0
> using 16-bit ODBC?  We are upgrading from Sql Server 6.5,
> and I seem to be having problems (especially executing
> stored procedures).  I have a large VB3 program that must
> be moved on short notice, and the current database resides
> on sql server 6.5, and the target database is on sql
> server 7.0

> If sql server 7.0 cannot be accessed with the 16-bit ODBC,




Mon, 17 Jan 2005 01:54:35 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. 16-Bit ODBC Driver for SQL server 7.0 and 2000

2. 16-Bit ODBC Driver for SQL server 7.0 and 2000

3. 16-Bit ODBC Driver for SQL server 7.0 and 2000

4. 16-bit ODBC Driver for MS-SQL Server 7.0

5. Accessing SQL Server 7.0 with 16-Bit ODBC (?)

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

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

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

9. 16 bit SQL Driver VS 32 bit SQL Driver

10. 16-bit ODBC driver for Sybase SQL Server

11. sql server 16-bit ODBC drivers

12. Fast 16-Bit ODBC Driver to SQL Server 6.0


 
Powered by phpBB® Forum Software