Odbcad Error

Results 1 to 7 of 7
  1. #1
    Novice Akshai Jaguar is offline
    MemberRank
    May 2013 Join Date
    3Posts

    Odbcad Error

    Please help me guys, as soon as possible . Facing this error. Roystyle i followed your tutorial only.





  2. #2
    The Sky's the Limit ^_^ GzFKoron is offline
    MemberRank
    Jul 2010 Join Date
    1,118Posts

    Re: Odbcad Error

    It is saying that it failed to connect to MSSQL.. are you sure you are using the correct username/password and that the MSSQL server engine is actually switched on?

  3. #3
    Apprentice dizzydaz is offline
    MemberRank
    Jun 2009 Join Date
    15Posts

    Re: Odbcad Error

    Delete your database and reinstall it

  4. #4
    Proficient Member CoreAI is offline
    MemberRank
    Apr 2013 Join Date
    177Posts

    Re: Odbcad Error

    Quote Originally Posted by dizzydaz View Post
    Delete your database and reinstall it
    No.. AuroraUK is correct, its because of an incorrect username and/or password.

  5. #5
    Currently Stoned ! Ronny786 is offline
    MemberRank
    Dec 2011 Join Date
    Lost WorldLocation
    984Posts

    Re: Odbcad Error

    Quote Originally Posted by dizzydaz View Post
    Delete your database and reinstall it
    you got nice sense !


    OT : issue with ID/Pass , reinstall with sql authentication using password.

  6. #6

    Re: Odbcad Error

    Did some snooping around, results narrow down to your network communication protocol.

    "The Server and the Client must both be using the same network communication protocol. For example if the client is talking Named Pipes, the server must be listening on named pipes. To verify this use the Server Network Utility on the SQL Server machine and the Client network utility on the client computer.

    Typicaly the server will list Named Pipes and then TCP/IP and the client will list TCP/IP and named pipes. However their are other protocols that the client and server can use as well.

    Another possibility is that the Security context of the MS SQL Server process does not have Administration privilideges on the server or it does not have permission to open a tcp/ip socket."

  7. #7
    Currently Stoned ! Ronny786 is offline
    MemberRank
    Dec 2011 Join Date
    Lost WorldLocation
    984Posts

    Re: Odbcad Error

    Quote Originally Posted by NOTORIOUS GZD View Post
    Did some snooping around, results narrow down to your network communication protocol.

    "The Server and the Client must both be using the same network communication protocol. For example if the client is talking Named Pipes, the server must be listening on named pipes. To verify this use the Server Network Utility on the SQL Server machine and the Client network utility on the client computer.

    Typicaly the server will list Named Pipes and then TCP/IP and the client will list TCP/IP and named pipes. However their are other protocols that the client and server can use as well.

    Another possibility is that the Security context of the MS SQL Server process does not have Administration privilideges on the server or it does not have permission to open a tcp/ip socket."

    great knowledge, but i know this guy personally.. he just uninstalled sql and installed 08 r2 version ...



Advertisement