Groups > comp.databases.ms-sqlserver > #1725

Re: Unable to connect Client to SQL Server

From	Bruno Campanini <brunocam@libero.it>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Unable to connect Client to SQL Server
Date	2014-03-12 21:45 +0100
Organization	Aioe.org NNTP Server
Message-ID	<lfqh0r$20d$1@speranza.aioe.org> (permalink)
References	(8 earlier) <lfppd5$vev$1@speranza.aioe.org> <XnsA2EEA7FCDF520Yazorman@127.0.0.1> <lfq0to$k69$1@speranza.aioe.org> <lfq31r$q9l$1@speranza.aioe.org> <XnsA2EED87FC9ED2Yazorman@127.0.0.1>

Show all headers | View raw

Erland Sommarskog pretended :
> Bruno Campanini (brunocam@libero.it) writes:
>> New things, with:
>> 
>> sqlcmd -S P900 -U sa -P brunocam -l 50
>> 
>> I get
>> 1>   and after Enter
>> 2>   and so on
>> 
>> I thing I get connected... and then?
>> How can I pass the parameter -l 50 from inside Access?
>  
> Add "Connect Timeout=50" to the connection string.
I don't have any connection string yet, I was operating Access 
manually.
Do you have a connection string I can work around on VBAccess?
>
> It appears that your network configuration is having, well, problems. 
> I have experienced similar at home as well. I had some awful ping
> times between my laptop and my desktop. The easy way out was to disable
> IPv6, but I flatly refused, and spent some time fighting with my
> router about it. It works now, I think.
>
> The default connect timeout is 15 seconds, and that should be enough
> in normal environments.


> Great to hear that you were able to resolve the issue!
You have been very useful and patient with me.
I thank you very much!

Bruno

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-10 00:24 +0100
  Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-10 08:00 +0000
    Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-10 19:47 +0100
      Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-10 21:04 +0100
        Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-11 01:21 +0100
          Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-11 08:51 +0000
            Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-11 13:37 +0100
              Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-11 21:01 +0100
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 15:02 +0100
                Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-12 15:30 +0000
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 17:10 +0100
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 17:46 +0100
                Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-12 21:16 +0100
                Re: Unable to connect Client to SQL Server Bruno Campanini <brunocam@libero.it> - 2014-03-12 21:45 +0100
                Re: Unable to connect Client to SQL Server Erland Sommarskog <esquel@sommarskog.se> - 2014-03-12 23:20 +0100

csiph-web