ODBC Error (1 Viewer)

[adz2013]

I have been getting this error on a machine when I try to link through an openlink ODBC driver. It works on ther machines but this machine it does not work. Has anyone seen this before?

[OpenLink][ODBC][Driver]Connection rejected by data source (#0) [Microsoft][ODBC Driver Manger] Driver's SQLSetConnectAttr Failed (#0)

Thank you in advance.

 

[dkirk02]

reset ODBC connection

You may have to set the System DSN using a different Oracle Driver. To do this:
1. Go to Start/Settings/Control Panel/Administrative Tools/Data Sources (ODBC)
2. Click on the System DSN tab
3. Make note of the System Data Source name
4. Remove the data source
5. Add Datasource
6. Select Driver

here are a few tips for driver selection
If you are using Oracle v8 or older, use Microsoft ODBC for Oracle or Oracle ODBC Driver
If you are using Oracle v9 or newer, select Oracle in OraHome92

Sometimes resetting this is just a matter of trial and error. Try one first and if it doesn't work, remove the connection and go on to the next.
Unfortunately, I don't know of a way to go in and check what driver was used to set up your other computers.

Good luck!