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 OOB client in the odbc.ini file (or equivalent) (or the Driver Manager could not find the DSN) or 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 OOB server to logon to the target machine. The TargetUser/TargetAuth are converted to UID=name,PWD=name and passed in to 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 OOB 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 in UNIX/VMS. In this case you will get IM002 and a secondary error of HY000 explaining why.
- Easysoft ODBC-ODBC Bridge
Knowledge Base Feedback