Monday, February 20, 2012

Microsoft SQL Server Login

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 attribu
te
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.Can you post the connection string you are using?
"Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
> 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 attri
bute
> 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.|||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
"Adam David Moss" wrote:

> Can you post the connection string you are using?
>
> "Alexis Robles" <Alexis Robles@.discussions.microsoft.com> wrote in message
> news:42D09044-6BD9-43E9-9199-411FF3E49898@.microsoft.com...
>
>|||Try removing the database=... Your DSN already specifies this does it not?
"Alexis Robles" <AlexisRobles@.discussions.microsoft.com> wrote in message
news:175EC6DB-10AF-41B0-9DB2-A9AC10D1DCF3@.microsoft.com...[vbcol=seagreen]
> 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
>
> "Adam David Moss" wrote:
>
message[vbcol=seagreen]
problem.[vbcol=seagreen]|||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.|||No, connection fail.
"Rand Boyd [MSFT]" wrote:

> Just out of curiosity:
> If you test the connection using the ODBC admin applet does it successfull
y
> connect?
> Rand
> This posting is provided "as is" with no warranties and confers no rights.
>

No comments:

Post a Comment