Discussion Locked

ODBC Connection Error

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Good morning. We have developed in house Data Management software written in VB5, so our external clients can access our remote database. With some installations of the software at the Client sites - only about 1 in 6 installs - we receive this error message on connection attempts:

MicrosoftRDO,Rdoconnetions: IM006:[Microsoft][ODBC DriverManager] Driver's SQLSetconnectATTR.Failed

Now, all of our external connections to Client sites are Fibred PVC's via our ISP. We can access the databases on the desktop's receiving the above error via SQL Plus, but we can't through the desktop Data Management software.

Keeping in mind that, this error in intermittent - only once in a while, but we can't seem to pin-point it.

If any can help me out with this, that would be great.

Thank you....

Rod

Rodney Lenaghan, MCP
Kestrel Data (1999) Ltd.
Phone: 403.258.7413
rlenaghan@kestreldata.net

5 replies

by eichinger

i am doing tech support for a co that uses odbc for db access. we had a similar problem and solved it by using odbc v2.01 and copying the latest r\vb run time dlls to the windows\system dir

by mbarker734

Due to the age of your question you may not get futher responces. If you still require help I suggest you close out this question and repost another.

This discussion is closed to new replies.