Re: [Microsoft][ODBC SQL Server Driver]Timeout expired"

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 11/20/04 

Date: Sat, 20 Nov 2004 12:17:09 -0600

The 'invalid connection string attribute' informational error is due to the
extraneous 'OPEN=ODBC' specification. Try removing it:

DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO

I don't know what API you are using but the default command timeout is 30
seconds. In the case of ADO, you can specify a longer interval with the
CommandTimeout command object property. Specify 0 for unlimitted. You
might also consider query/index tuning to speed up the query and also check
for blocking. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Alexis Robles" <AlexisRobles@discussions.microsoft.com> wrote in message 
news:4A6C5752-A705-40CC-81B7-8FAAF54F2AE8@microsoft.com...
> Here is the connection string:
>
> OPEN=ODBC;DATABASE=AFM_CALLISTO;DSN=AFM_CALLISTO;
>
> "Dan Guzman" wrote:
>
>> Please post your connection string.
>>
>> -- 
>> Hope this helps.
>>
>> Dan Guzman
>> SQL Server MVP
>>
>> "Alexis Robles" <AlexisRobles@discussions.microsoft.com> wrote in message
>> news:9F8B08B1-26CF-4601-8457-C7E810149812@microsoft.com...
>> > Could anyone help?
>> >
>> > "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"
>> >
>> > Thanks in advance
>>
>>
>>

Relevant Pages

  • Re: using VBA to insert records from access database to sql server
    ... I don't think you can specify a connection string *within* a query like ... My preferred solution to this kind of problem would be to use ODBC to link ... the Access MDB and the SQL Server table. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Linked Server - Force Translate
    ... I had the same issue when using a connection string with same ... > see sp_addlinkedserver in Books Online for details. ... > You can also use OPENROWSET and specify a connection string with it. ... > Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se ...
    (microsoft.public.data.oledb)
  • Hitting Sql Server Stored Procedure Breakpoint from ASP.NET app
    ... I am not able to stop at a stored procedure breakpoint in SQL Server from an ... ASP.NET application unless I specify a username and password in my connection ... different user in DB connection string. ... debugging rights in SQL Server? ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: arghh.. cant get .NET to connect to sql server
    ... When accessing the SQL Server, there are two authentication modes. ... specify the userid and the password in your connection string, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 7.0 Security Patch MS03-031
    ... > I've been using a connection string within an ASP page to ... > Everything worked fine until SQL Server 7.0 Security ... > Microsoft OLE DB Provider for SQL Server error '80004005' ...
    (microsoft.public.sqlserver.security)