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/13 23:55] – [Database, User & Password] Justin Willey | sa26-00 [2018/07/17 08:23] (current) – [Database connection error] sean | ||
---|---|---|---|
Line 11: | Line 11: | ||
=====IQX.INI===== | =====IQX.INI===== | ||
- | The iqx.ini file contains many settings controlling the behaviour of iqx. It is found in the same folder as the copy of the iqx.exe program that is being run. Depending on how IQX has been installed, this may be on a local computer, a file server or on a remote desktop server. If there is any doubt about the location of the IQX program being run or iqx.ini, check the Properties of the short cut icon used to launch IQX and inspect the Target setting. Full details of the settings in iqx.ini can be found on [[technical: | + | The iqx.ini file contains many settings controlling the behaviour of iqx. It is found in the same folder as the copy of the iqx.exe program that is being run. Depending on how IQX has been installed, this may be on a local computer, |
===== The IQX Login Screen ===== | ===== The IQX Login Screen ===== | ||
The login screen | The login screen | ||
Line 22: | Line 22: | ||
**Password** is the case sensitive password associated with the User in IQX. | **Password** is the case sensitive password associated with the User in IQX. | ||
- | ===== Identifying | + | ===== Narrowing Down the Likely Causes of Connection Failure |
- | <panel type=" | + | <html> |
- | <panel-body>The reasons that a login fails will be one of the following</panel-body> | + | <head> |
- | |1|The user name is incorrect or not authorised to connect to the requested database| | + | <style> |
- | |2|The wrong password has been supplied| | + | .col0 {font-size: 14px; } |
- | |3|The requested database is incorrect or not defined| | + | .col1 {color: #4CAF50; |
- | |4|The database server is not running| | + | font-size: 14px; } |
- | |5|There are network connectivity issues| | + | .button {} |
- | |6|The necessary SQL Anywhere driver files are not installed or registered on the client computer| | + | .button1 { |
- | |7|The requested database is incorrectly defined| | + | font-size: 14px; |
- | </panel> | + | background-color: |
- | This guide is designed to help identify which of these possibilities is the likely culprit. | + | border-radius: 12px; |
- | ===== Narrowing the likely causes ===== | + | |
- | + | | |
- | * Are other users currently connected to the same database? If so, 4 cannot be the issue. | + | } |
- | | + | .button1: |
- | | + | .button1: |
- | | + | |
- | ===== Invalid User Name or Password | + | |
+ | transform: translateY(4px); | ||
+ | } | ||
+ | </style> | ||
+ | </ | ||
+ | <div class=" | ||
+ | <ul class=" fix-media-list-overlap"> | ||
+ | <li class=" | ||
+ | </ | ||
+ | <li class=" | ||
+ | </ | ||
+ | <li class=" | ||
+ | </ | ||
+ | <li class=" | ||
+ | </ | ||
+ | <li class=" | ||
+ | </ | ||
+ | <li class=" | ||
+ | </ | ||
+ | </ | ||
+ | <div class=" | ||
+ | <div class=" | ||
+ | <tr class=" | ||
+ | <td class=" | ||
+ | </ | ||
+ | <tr class=" | ||
+ | <td class=" | ||
+ | </ | ||
+ | <tr class=" | ||
+ | <td class=" | ||
+ | </ | ||
+ | <tr class=" | ||
+ | <td class=" | ||
+ | </ | ||
+ | <tr class=" | ||
+ | <td class=" | ||
+ | </ | ||
+ | <tr class=" | ||
+ | <td class=" | ||
+ | </ | ||
+ | <tr class=" | ||
+ | <td class=" | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | </ | ||
+ | ===== Error Messages ===== | ||
+ | ==== Invalid User Name or Password | ||
{{ :: | {{ :: | ||
This error indicates that the user has provided an incorrect or expired username or an incorrect password for their user account. To establish which, as user with Maintenance rights can connect to IQX and view Connections in Maintenance | Database Diagnostics | Connection. | This error indicates that the user has provided an incorrect or expired username or an incorrect password for their user account. To establish which, as user with Maintenance rights can connect to IQX and view Connections in Maintenance | Database Diagnostics | Connection. | ||
Line 49: | Line 96: | ||
* the user was defined but was marked as Not in Use in Maintenance | Users - **User 'Not In Use'** | * the user was defined but was marked as Not in Use in Maintenance | Users - **User 'Not In Use'** | ||
- | 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.\\ \\ |
- | ===== Error Messages ===== | + | |
+ | This is an example of Reasons 1 or 2 in the [[# | ||
====Database name incorrect or not set up==== | ====Database name incorrect or not set up==== | ||
{{ : | {{ : | ||
Line 57: | 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 67: | 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 80: | 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 87: | 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, |