Progress
DataServer for
Microsoft SQL Server
Guide
Connection Troubleshooting
Here are some reasons why a connection attempt to a SQL Server™ database might fail:
- The schema holder is not connected.
- The Progress or MSS (Microsoft® SQL Server™) required environment variables are not set correctly when using the Enterprise DataServer and a broker. For environment-variable information, see Configuring the DataServer."
- The data source is not registered properly for ODBC client connectivity.
- You have an outdated version of an ODBC DLL; for example,
ODBC16.DLL
, which runs on 16-bit machines only. This prevents Progress from accessing the data source, though you might still be able to access the data source through your ODBC driver using another product, such as Query Analyzer.- The data source has not been started or is not running correctly. Use the data source utilities to check the status of the data source and the ability to connect to it.
- The login name and password combination that you provided during connection is invalid for the data source.
- You specified an incorrect ODBC data source name when you created the schema holder.
For more information, see Troubleshooting."
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |