====== Debugging IQX Connection Failures ======
1 | The user name is incorrect or not authorised to connect to the requested database |
2 | The wrong password has been supplied |
3 | The requested database is incorrect or not defined |
4 | The database server is not running |
5 | There are network connectivity issues |
6 | The necessary SQL Anywhere driver files are not installed or registered on the client computer |
7 | The requested database is incorrectly defined |
[Databases]
v16test=asa19;eng=Chill16;dbn=v16Test;links=tcpip;
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.
\\ \\ This is an example of Reason 6 in the [[##narrowing_down_the_likely_causes_of_connection_failure|list]] above. "asa" stands for "Adaptive Server Anywhere" the former name of "SQL Anywhere".
[Databases]
v16test=qasa16;eng=Chill;dbn=v16Test;links=tcpip(host=192.168.1.138:2638);prows=1000;pbuf=81920;comp=YES;
The action to be taken is that the iqx.ini file needs to be corrected.\\ \\
This is an example of Reason 7 in the [[##narrowing_down_the_likely_causes_of_connection_failure|list]] above.