sa26-00

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
sa26-00 [2018/07/17 08:22] – [Database connection error] seansa26-00 [2018/07/17 08:23] (current) – [Database connection error] sean
Line 110: Line 110:
 {{ ::databaseconnectionerror.jpg |}} {{ ::databaseconnectionerror.jpg |}}
 This message indicates that while connection settings have been identified for the requested database, a successful connection could not be established. To get more information, press the <key>Details</key> button. This results in a detailed and somewhat technical error log, which can be copied to the Windows clipboard. The following sections give guidance for the possible different error messages: This message indicates that while connection settings have been identified for the requested database, a successful connection could not be established. To get more information, press the <key>Details</key> button. This results in a detailed and somewhat technical error log, which can be copied to the Windows clipboard. The following sections give guidance for the possible different error messages:
-<accordion>+\\
 <panel title="Data source name not found and no default driver specified"> <panel title="Data source name not found and no default driver specified">
 {{ :nodefaultdriverspecified.jpg? |}}This is a rather misleading error message from the Microsoft ODBC driver manager that indicates that the ODBC driver requested is not installed. The driver version required is specified in the connection string in iqx.ini. In the example above the setting in the ini file was:<code>[Databases] {{ :nodefaultdriverspecified.jpg? |}}This is a rather misleading error message from the Microsoft ODBC driver manager that indicates that the ODBC driver requested is not installed. The driver version required is specified in the connection string in iqx.ini. In the example above the setting in the ini file was:<code>[Databases]
Line 149: Line 149:
 This error indicates that IQX has been able to connect to the database server specified in the iqx.ini file, but it has not found a database of the name specified in the dbn= setting. The most likely cause is that the database name in iqx.ini is wrong, there is a possibility that an administrator has temporary stopped the individual database while leaving the database engine running on the server. In the case of a live database this latter reason is highly unlikely, but is possible for a training or test database.\\ \\ The required action in most cases is to correct the dbn= setting in iqx.ini. \\ \\ This is an example of Reason 7 in the [[##narrowing_down_the_likely_causes_of_connection_failure|list]] above. This error indicates that IQX has been able to connect to the database server specified in the iqx.ini file, but it has not found a database of the name specified in the dbn= setting. The most likely cause is that the database name in iqx.ini is wrong, there is a possibility that an administrator has temporary stopped the individual database while leaving the database engine running on the server. In the case of a live database this latter reason is highly unlikely, but is possible for a training or test database.\\ \\ The required action in most cases is to correct the dbn= setting in iqx.ini. \\ \\ This is an example of Reason 7 in the [[##narrowing_down_the_likely_causes_of_connection_failure|list]] above.
 </panel> </panel>
-</accordion>+
 The guidance above assumes that iqx.ini rather than the ODBC administrator is being used to manage database connection details. For help with the ODBC administrator, refer to [[DeguggingBDEConnectionFailures#issues_with_the_odbc_dsn_or_the_network|Issues With the ODBC DSN]] in the BDE troubleshoot guide.  The guidance above assumes that iqx.ini rather than the ODBC administrator is being used to manage database connection details. For help with the ODBC administrator, refer to [[DeguggingBDEConnectionFailures#issues_with_the_odbc_dsn_or_the_network|Issues With the ODBC DSN]] in the BDE troubleshoot guide. 
  • sa26-00.1531815723.txt.gz
  • Last modified: 2018/07/17 08:22
  • by sean