Very Computer

by **Mike Roc** » Fri, 02 Aug 2002 02:39:59

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,

by **Steve Thompso** » Fri, 02 Aug 2002 02:54:35

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

> 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,

Very Computer

How to access Sql Server 7.0 using 16-bit ODBC drivers

How to access Sql Server 7.0 using 16-bit ODBC drivers

How to access Sql Server 7.0 using 16-bit ODBC drivers