Easysoft ODBC-ODBC Bridge
Why can't I connect to the data source?
There can be many reasons for getting SQL_ERROR back from SQLDriverConnect or SQLConnect. See question "How do I find out why an ODBC call is failing" first. The most likely reasons are:
-
IM002 - DSN or TargetDSN not found. The DSN specified in the connection string could not be found by the Easysoft ODBC-ODBC Bridge client in the odbc.ini file (or equivalent). The Driver Manager could not find the DSN. The TargetDSN attribute was missing from the DSN or connection string. See also HY000 below.
The MOST common cause for this when going to a Windows server is setting TargetDSN to a USER DSN instead of a SYSTEM DSN. Check the DSN on your Windows machine is a SYSTEM DSN.
- 28000 - Invalid authorization specification. Either the LogonUser/LogonAuth attribute pair or TargetUser/TargetAuth attribute pair were incorrect. The LogonUser/LogonAuth must be a valid username/password pair used by the ODBC-ODBC Bridge server to log on to the target machine. The TargetUser/TargetAuth are converted to UID=value, PWD=value and passed into the remote SQLDriverConnect where the ODBC driver uses them for database logon (if they are required).
- 08001 - Client unable to establish connection. The machine specified in the Server attribute could not be found, it is not running the ODBC-ODBC Bridge server or one of many other possible networking issues. Check the Server attribute in the specified DSN is a valid machine name (or IP address), check the name can be looked up via DNS (if you are using DNS or examine the hosts file), check you are on the same network by pinging the target server, check the Port attribute in the specified DSN is correct, try telnetting to the Server machine on port Port.
- HY000 - A general error. A common mistake might be not specifying all the connection attributes required to connect to the server. E.g. omitting the SERVER attribute from the DSN in the odbc.ini file on UNIX/VMS. In this case, you will get IM002 and a secondary error of HY000 explaining why.
Applies To
-
Products
- Easysoft ODBC-ODBC Bridge
Knowledge Base Feedback
