Kbase P17118: ODBC Dataserver does not work with MS SQL server 7 running i
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/05/2003 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
MS SQL 7
FACT(s) (Environment):
ODBC DataServer
SYMPTOM(s):
Can not pull schema
Error "The dataserver for ODBC is designed to work with MS SQL server 6 and below. You have tried to connect to a later version. Use the dataserver for MS SQL server to perform this function."
Using Progress SQL Server6 Driver
MS SQL Server 7 running in 6.5 mode
Progress SQL Server Driver can connect
Merant 4.1 ODBC Driver can connect
CAUSE:
An ODBC call is made by Dataserver to MS SQL server to find out the version and
MS SQL Server returns 7 as the version even it is running in 6.5 mode. There is no way to turn off the version check, as this is the first thing the data dictionary does when attempting to create a schema holder.
FIX:
Install and use SQL Server Dataserver license