none
Connection failed.

    Question

  •  

    Hi!

    We have an application conneting to our Sql server.

    Sometimes we get an error message saying:

     

    Connection failed:
    SqlState: '01S00'
    Sql Server Error: 0
    [Microsoft][Odbc Sql Server Driver]Invalid connection string attribute.
    Connection failed:
    SqlState: 'S1T00'
    Sql Server Error: 0
    [Microsoft][Odbc Sql Server Driver]Timeout expired

     

    When we click OK on this dialog, we get a new dialog where the usernname and password is filled in.

    Clicking OK on this dialog makes the dialog go away,and the app works as normal.

     

    Friday, April 04, 2008 8:33 AM

Answers

All replies

  • Hi,

     

    This error occurs when an invalid connection string attribute is present in the connection string. Check your connection string.

     

     

    HTH,
    Suprotim Agarwal

    -----
    http://www.dotnetcurry.com
    -----

     

    Friday, April 04, 2008 8:55 AM
  •  Roar Holden wrote:

     

    Hi!

    We have an application conneting to our Sql server.

    Sometimes we get an error message saying:

     

    Connection failed:
    SqlState: '01S00'
    Sql Server Error: 0
    [Microsoft][Odbc Sql Server Driver]Invalid connection string attribute.
    Connection failed:
    SqlState: 'S1T00'
    Sql Server Error: 0
    [Microsoft][Odbc Sql Server Driver]Timeout expired

     

    When we click OK on this dialog, we get a new dialog where the usernname and password is filled in.

    Clicking OK on this dialog makes the dialog go away,and the app works as normal.

     

     

    Also you may want to check your network for any connection drops. You gets this while the application was online, you may want to check network. 

     

    Madhu

    Friday, April 04, 2008 9:27 AM
  • Hi,

    previous post:

    Connection failed:
    SqlState: '01S00'
    Sql Server Error: 0
    [Microsoft][Odbc Sql Server Driver]Invalid connection string attribute.
    Connection failed:
    SqlState: 'S1T00'
    Sql Server Error: 0
    [Microsoft][Odbc Sql Server Driver]Timeout expired

    *****************************

    Were you able to resolve your issue?
    I ran into to problem after I perform windows update. I know this for sure becuase I have 2 PCs running side by side and the same application more or less.  The one that was updated is acting up, the one w.out the update works fine.

    below is the other errror that pops up something as well

    (Microsoft SQL Server login Connection failed:
    SQLState: '01000' SQL
    Server Error: 53
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]cONNECTIONoPEN (cONNECT())
    Connection failed:
    SQL STATE: '08001'
    SQL Server Error: 17
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
    access denied.

    Thank you in advance for any suggestions on solve this issue.

    Thursday, January 15, 2009 6:21 PM
  • Hi All,
    I ran into to problem after I perform windows update. I know this for sure becuase I have 2 PCs running side by side and the same application more or less.  The one that was updated is acting up, the one w.out the update works fine.  

    When I click OK on this dialog, we get a new dialog where the usernname and password is filled in.

    Clicking OK on this dialog makes the dialog go away,and the app works as normal but it comes back later.

    Below is the other errror message


    Connection failed:
    SqlState: '01S00'
    Sql Server Error: 0
    [Microsoft][Odbc Sql Server Driver]Invalid connection string attribute.
    Connection failed:
    SqlState: 'S1T00'
    Sql Server Error: 0
    [Microsoft][Odbc Sql Server Driver]Timeout expired

    ******AND*********


    (Microsoft SQL Server login Connection failed:
    SQLState: '01000' SQL
    Server Error: 53
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]cONNECTIONoPEN (cONNECT())
    Connection failed:
    SQL STATE: '08001'
    SQL Server Error: 17
    [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
    access denied.

    Thank you in advance for any suggestions on solve this issue.
     
    Thursday, January 15, 2009 6:26 PM
  • Please send us the connection string you are using or check the www.connectionstrings.com site for the valid options in your ODBC connection string.

    The other error indicated that the server you are trying to reach is not accessible, this can have several issues depending on the configuration of the serer SererName / instance name information, port configuration, protocol configuration.

    -Jens K. Suessmeyer

    Thursday, January 15, 2009 9:34 PM
  • I had a windows update once that changed the locale of my machine from en-GB to en-US. Might be totally unrelated, but might be worth checking... 

    Do any of the properties of the SQL connection (the servername, username or password) contain  non-standard characters? Are the computers set up to use the same characterset?
    Saturday, January 17, 2009 9:12 AM