Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I connect to MSSQL Server from FPD26
Message
From
02/08/2002 11:49:11
 
 
To
02/08/2002 11:36:53
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00685488
Message ID:
00685504
Views:
14
from http://www.sqlmag.com/Articles/Index.cfm?ArticleID=4889

Which version of Open Database Connectivity (ODBC) drivers do I need to talk to SQL Server 7.0?

All SQL Server 7.0 tools use either ODBC or Object Linking and Embedding Database (OLE DB) to access SQL Server except isql.exe, which still uses DBLib. Therefore, you must have up-to-date ODBC drivers to use SQL Server 7.0 tools, which use ODBC 3.70 drivers. These new drivers understand how to communicate with SQL Server 7.0, and fully support features such as Unicode. The drivers are fully backward compatible, so you can talk to earlier releases of SQL Server and SQL Server 7.0 with the ODBC 3.70 drivers. You cannot use the ODBC 2.x drivers successfully on the SQL Server 7.0 computer. On client computers, you can still use the older ODBC drivers, but you will lose some functionality such as sending and receiving Unicode datatypes. Also, Microsoft is not shipping any 16-bit ODBC drivers for SQL Server 7.0, but the SQL Server 6.5 drivers will still work.
Previous
Reply
Map
View

Click here to load this message in the networking platform