Post reply

while creating an ODBC !!

  • February 3, 2007 at 5:42 am

    #116105

    Hi every one

     

     

    I'm trying to connect an ERP software to its DataBase throw (Terminal Server)

    while creating an ODBC I got this Error

    Notes: 1) the login user and password are correct.

              2) the connection btw the servers is OK.

              3) the server name wich i put in the ODBC window is correct.

     

    and the error is:

    connection failed:

    SQLStat: '01000'

    SQL Server Error : 1231

    [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen(Connect()).

    Connection Failed;

    SQLState: '08001'

    SQL Server Error :17

    [Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server Dose not exist or access denied.

     

     

     

    Thank you.

  • February 3, 2007 at 7:32 am

    #687625

    I think named pipes id disabled in ur sql server. enable named pipes or use TCP/IP to create the ODBC.To enable named pipes follow the belwo pipes.

    1. connect to the sql server configuration manager

    2. navigate to SQL SERVER 2005 Network Configuration

    3. Protocols for MSSQLSERVER

    in the right hand side pane u will see the list of protoccols and thier status

    4. enable named pipes in that list and create ur ODBC.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • February 5, 2007 at 1:34 am

    #687687

    I agree with Sugesh, its something to do with your SQL Server configuration settings. Please follow the instructions from the below link and I hope you will be able to resolve the issue.

    http://support.microsoft.com/kb/839269

    Thanks

     

    Prasad Bhogadi
    www.inforaise.com

  • February 6, 2007 at 2:43 am

    #687948

    Thank You ...

     

     

    It is working after trying the link above

     

     

    Thank you all again

Viewing 4 posts - 1 through 4 (of 4 total)

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