Mega Code Archive

Mssql 7 sql links [v5 01 23] feature support, ms dblib [ntwdblib dll]

Question: Why aren't all of the new features and types supported in the new version of the MSSQL SQL Links driver? Answer: Please see the BDEREADME.TXT for additional information regarding BDE and SQL Links v5.01. New MS-SQL Server 7 Driver -------------------------- The SQL Links (not available with all editions of Inprise programming tools) driver for Microsoft SQL Server now supports version 7, in addition to support in the same driver for version 6.5. SQL Links uses DBLIB (native API for MS-SQL Server). DBLIB only implements the MS-SQL Server 6.5 feature set. This means that new types in MS-SQL Server 7 like GUID, Unicode, and CHAR columns longer than 255 characters are not supported. Microsoft will not be adding support for these new types to DBLIB, so the SQL Links driver does not support these new MS-SQL Server 7 types. Both Microsoft and Inprise strongly recommend that you use the client software appropriate for the version of MS-SQL Server used. That is, use version 6.x client software only with 6.x server software and version 7 client software only with version 7 server software.