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

From: Alexis Robles (AlexisRobles_at_discussions.microsoft.com)
Date: 11/20/04 

Date: Sat, 20 Nov 2004 11:13:07 -0800

It didn't connect when I remove 'OPEN=ODBC'

"Dan Guzman" wrote:

> 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: Problem when redeined macro for floats with usepackage{color}
    ... tables) so that single spacing is used. ... % - User can specify draft copies, ... The \beforepreface command creates the title page, ...
    (comp.text.tex)
  • Re: Problem when redeined macro for floats with usepackage{color}
    ... % - User can specify draft copies, ... The \beforepreface command creates the title page, ... % so that single spacing is used. ...
    (comp.text.tex)
  • Re: not in domain
    ... You can use the netdom command as long as you have admin credentials on the ... NETDOM JOIN Joins a workstation or member server to the domain. ... If you specify a domain controller, ... VBScript & Windows PowerShell Training - ...
    (microsoft.public.scripting.vbscript)
  • Re: A Solution
    ... The syntax of the command is incorrect. ... /G user:perm Grant specified user access rights. ... Wildcards can be used to specify more that one file in a command. ... CI - Container Inherit. ...
    (microsoft.public.windowsmedia.player)
  • RE: DTS and stored procedure
    ... There is a command prompt utility "dtsrun". ... The DTS package can be stored in the Microsoft® SQL Server™ ... Specify server_name to ... Displays the encrypted command used to execute the DTS package without ...
    (microsoft.public.sqlserver.dts)
Loading