Why do I get the error "Connection failed- 01000 SQL 3 - Driver connection failed" when attempting to open the Admin Console?

0 Likes

Problem:

Why do I get the error "Connection failed- 01000 SQL 3 - Driver connection failed" when attempting to open the Admin Console?

Resolution:

ANSWER
----------------------------------
This error will occur if you do not have valid DSN setup on the machine that your Admin Console is installed on. Although the SilkCentral Issue Manager web console uses JDBC for database connectivity, the admin console still requires an ODBC data source for it"s connectivity. Please ensure an ODBC data source has been setup and can connect to your database. To check if one is installed and working:

  • Click START | RUN
  • Type ODBCAD32 and click OK
  • Click the User DSN and search for an entry called SILKRADAR_SQLSERVER (if connecting to a SQL Server database) or SILKRADAR_OPENLINK (if connecting to an Oracle database).
  • If no entries appear in the User DSN then click on the System DSN and check for entries there.
  • Once found click Configure, go through each step by clicking Next then finally click the Test Data Source button.


If you are having problems with getting the DSN to work contact your IS department. If you DSN works but you continue to have problems with the Admin Console connection or if no DSN entries exists for SILKRADAR_SQLSERVER or SILKRADAR_OPENLINK then contact Support.

Old KB# 23768
Comment List
Anonymous
Related Discussions
Recommended