Discussion:
Microsoft SQL Server Login
(too old to reply)
Alexis Robles
2004-11-19 21:49:10 UTC
Permalink
I'm getting the following message trying to connect through ODBC:

"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"

I've been troubleshooting for about a month and haven't solve the problem.

Could anyone told me what to do in order to fix the problem?

Thanks in advance.
Adam David Moss
2004-11-20 18:51:20 UTC
Permalink
Can you post the connection string you are using?
Post by Alexis Robles
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
SQLState: 'S1T00'
SQL server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired"
I've been troubleshooting for about a month and haven't solve the problem.
Could anyone told me what to do in order to fix the problem?
Thanks in advance.
Alexis Robles
2004-11-20 19:37:02 UTC
Permalink
Here is the connection string:

OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO;

Someone already suggest me to remove:
OPEN=ODBC

and it didn't connect.

Hope you can help me.

Thanks in advance
Post by Adam David Moss
Can you post the connection string you are using?
Post by Alexis Robles
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
SQLState: 'S1T00'
SQL server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired"
I've been troubleshooting for about a month and haven't solve the problem.
Could anyone told me what to do in order to fix the problem?
Thanks in advance.
Adam David Moss
2004-11-20 20:14:50 UTC
Permalink
Try removing the database=... Your DSN already specifies this does it not?
Post by Alexis Robles
OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO;
OPEN=ODBC
and it didn't connect.
Hope you can help me.
Thanks in advance
Post by Adam David Moss
Can you post the connection string you are using?
Post by Alexis Robles
SQLState: '01S00'
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
SQLState: 'S1T00'
SQL server Error: 0
[Microsoft][ODBC SQL Server Driver]Timeout expired"
I've been troubleshooting for about a month and haven't solve the problem.
Could anyone told me what to do in order to fix the problem?
Thanks in advance.
Rand Boyd [MSFT]
2004-11-22 16:18:50 UTC
Permalink
Just out of curiosity:

If you test the connection using the ODBC admin applet does it successfully
connect?

Rand
This posting is provided "as is" with no warranties and confers no rights.
Alexis Robles
2004-11-22 20:11:05 UTC
Permalink
No, connection fail.
Post by Rand Boyd [MSFT]
If you test the connection using the ODBC admin applet does it successfully
connect?
Rand
This posting is provided "as is" with no warranties and confers no rights.
Loading...