General discussion

  • Creator
    Topic
  • #2082024

    ODBC Connection Error

    Locked

    by rlenaghan ·

    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

All Comments

  • Author
    Replies
    • #3900307

      ODBC Connection Error

      by eichinger ·

      In reply to ODBC Connection Error

      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

    • #3874666

      ODBC Connection Error

      by mbarker734 ·

      In reply to ODBC Connection Error

      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.

    • #3874497

      ODBC Connection Error

      by rlenaghan ·

      In reply to ODBC Connection Error

      This question was auto closed due to inactivity

Viewing 2 reply threads