odbc connection problems

  • hi folks!

    my setup is as follows:

    i have front-end setup using ms access 2007 and back-end setup is ms sql 2005. the problem is that every time users must go through troubles of accessing the sql databse with "ODBC Connection failed..." error message before being successful. on sucsess, users stay connected for sometimes before the connection drops with the familiar "ODBC Connection failed...." error message. this is not supposed to be happening and it is becoming a constant pain. please, someone help!

  • Windows or SQL Autentication in the ODBC setup?

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Sir,

    ODBC is configured in Windows Aunthetication and I selected SQL Server Driver.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply