Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
sa26-00 [2018/07/14 01:35] – [Invalid User Name or Password] Justin Willey | sa26-00 [2018/07/17 08:23] (current) – [Database connection error] sean | ||
---|---|---|---|
Line 55: | Line 55: | ||
<li class=" | <li class=" | ||
</li> | </li> | ||
- | <button type=" | + | <li class=" |
+ | </ | ||
+ | <li class=" | ||
+ | </li></ | ||
</ul> | </ul> | ||
<div class=" | <div class=" | ||
Line 95: | Line 98: | ||
The relevant record in Connections can be found using IP address of the computer that is attempting to connect and the time of the attempted connection. If there is no corresponding record, then then IQX has not been able to connect to the database.\\ \\ | The relevant record in Connections can be found using IP address of the computer that is attempting to connect and the time of the attempted connection. If there is no corresponding record, then then IQX has not been able to connect to the database.\\ \\ | ||
- | This is an example of Reasons 1 or 2 in the [[#Identifying the reasons for login failure|list]] above. | + | This is an example of Reasons 1 or 2 in the [[#narrowing_down_the_likely_causes_of_connection_failure|list]] above. |
====Database name incorrect or not set up==== | ====Database name incorrect or not set up==== | ||
Line 103: | Line 106: | ||
- Setup the database details in the [Databases] section of iqx.ini | - Setup the database details in the [Databases] section of iqx.ini | ||
- | This is an example of Reason 3 in the [[#Identifying the reasons for login failure|list]] above. | + | This is an example of Reason 3 in the [[## |
====Database connection error==== | ====Database connection error==== | ||
{{ :: | {{ :: | ||
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, | 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, | ||
- | < | + | \\ |
<panel title=" | <panel title=" | ||
{{ : | {{ : | ||
Line 113: | Line 116: | ||
The =asa19 part tells the system to connect using a SQL Anywhere v19 driver. \\ \\ | The =asa19 part tells the system to connect using a SQL Anywhere v19 driver. \\ \\ | ||
The action to be taken is: either that ODBC driver needs to be installed on the client computer (using the IQX Client Installer) or the iqx.ini file needs to be corrected to use the installed ODBC driver. | The action to be taken is: either that ODBC driver needs to be installed on the client computer (using the IQX Client Installer) or the iqx.ini file needs to be corrected to use the installed ODBC driver. | ||
- | \\ \\ This is an example of Reason 6 in the [[#Identifying the reasons for login failure|list]] above. " | + | \\ \\ This is an example of Reason 6 in the [[## |
</ | </ | ||
<panel title=" | <panel title=" | ||
v16test=qasa16; | v16test=qasa16; | ||
- | This is an example of Reason 7 in the [[#Identifying the reasons for login failure|list]] above. | + | This is an example of Reason 7 in the [[## |
</ | </ | ||
<panel title=" | <panel title=" | ||
Line 126: | Line 129: | ||
{{ : | {{ : | ||
In this case there is no error with the drivers, but IQX has been unable to connect to the requested database server. The database server ChillXX has been specified, and a network address and port given (host=). A database server has been found at that network address, but the name is wrong, so the connection fails. This indicates that either the requested name is wrong or an incorrect network address has been specified. The required action is to correct whichever of these settings in the iqx.ini file is wrong.\\ \\ | In this case there is no error with the drivers, but IQX has been unable to connect to the requested database server. The database server ChillXX has been specified, and a network address and port given (host=). A database server has been found at that network address, but the name is wrong, so the connection fails. This indicates that either the requested name is wrong or an incorrect network address has been specified. The required action is to correct whichever of these settings in the iqx.ini file is wrong.\\ \\ | ||
- | This is an example of Reason 7 in the [[#Identifying the reasons for login failure|list]] above. | + | This is an example of Reason 7 in the [[## |
</ | </ | ||
<callout type=" | <callout type=" | ||
Line 133: | Line 136: | ||
Again the reported error is " | Again the reported error is " | ||
The required action is to correct the settings in the iqx.ini file.\\ \\ | The required action is to correct the settings in the iqx.ini file.\\ \\ | ||
- | This is an example of Reason 7 in the [[#Identifying the reasons for login failure|list]] above. </ | + | This is an example of Reason 7 in the [[## |
<callout type=" | <callout type=" | ||
===Database server not found, but no other indication=== | ===Database server not found, but no other indication=== | ||
{{ : | {{ : | ||
- | This indicates that IQX can get no response from the given network address nor by trying to find the database engine by name. Either the address is wrong, or the database server is not running, or there is a network problem (which could include a firewall blocking traffic). If other users **can** connect, | + | This indicates that IQX can get no response from the given network address nor by trying to find the database engine by name. Either the address is wrong, or the database server is not running, or there is a network problem (which could include a firewall blocking traffic). If it is a firewall issue on a central/ |
- | This is an example of either Reason 4, 5 or 7 in the [[#Identifying the reasons for login failure|list]] above. </ | + | This is an example of either Reason 4, 5 or 7 in the [[## |
+ | <callout type=" | ||
+ | </ | ||
</ | </ | ||
<panel title=" | <panel title=" | ||
{{ :: | {{ :: | ||
- | 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 cas 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 [[#Identifying the reasons for login 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 [[## |
</ | </ | ||
- | </ | + | |
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, | 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, |