Kbase P21732: ODBC DataServer can not connect over to SQL Server 2000 Database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/04/2004 |
|
Status: Verified
FACT(s) (Environment):
ODBC DataServer
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
MS SQL 2000
SYMPTOM(s):
Can not connect over to SQL Server 2000 Database
Only ODBC dataserver license is installed
During creation of schema holder, session hangs after pressing okay in the "Create DataServer Schema" menu
Using SQL Server authentication using a login ID and password entered by the user
ODBC DSN configured to use the SQL Server Driver 3.80.0194
SYSTEM DSN configured
User and Password are valid
CAUSE:
Progress 9.1D ODBC DataServer only supports and has certified the following datasources:
Sybase Adaptive Server 11
DB2 Universal DB 7.2 (MVS, RS/6000,NT)
Informix On-Line V7
MSAccess (95,97)
MS SQL Server 6.5 & 7
FIX:
Install and use MS SQL Server DataServer product. This product supports MS SQL Server 7 and SQL Server 2000. The licenses for this product are:
SQL Server7 Enterprise
SQL Server Personal