Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1724
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Erland Sommarskog <esquel@sommarskog.se> |
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: Unable to connect Client to SQL Server |
| Date | Wed, 12 Mar 2014 21:16:57 +0100 |
| Organization | Erland Sommarskog |
| Lines | 29 |
| Message-ID | <XnsA2EED87FC9ED2Yazorman@127.0.0.1> (permalink) |
| References | <lfit86$thr$1@speranza.aioe.org> <XnsA2EC5B95F23F9Yazorman@127.0.0.1> <lfl1cr$e5b$1@speranza.aioe.org> <XnsA2ECD650A5C8DYazorman@127.0.0.1> <lflktn$1ek$1@speranza.aioe.org> <XnsA2ED645E08739Yazorman@127.0.0.1> <lfn01j$r2$1@speranza.aioe.org> <XnsA2EDD5DCC29C5Yazorman@127.0.0.1> <lfppd5$vev$1@speranza.aioe.org> <XnsA2EEA7FCDF520Yazorman@127.0.0.1> <lfq0to$k69$1@speranza.aioe.org> <lfq31r$q9l$1@speranza.aioe.org> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=windows-1252 |
| Content-Transfer-Encoding | 8bit |
| Injection-Info | mx05.eternal-september.org; posting-host="fd3d6d0229f14a752f017d8f9903addd"; logging-data="30785"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18q/kSwavEDKeLEU3qE4KnP" |
| User-Agent | Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) |
| Cancel-Lock | sha1:3GpVqADChcWVewBGRkXEV/XUG94= |
| Xref | csiph.com comp.databases.ms-sqlserver:1724 |
Show key headers only | View raw
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. 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! -- Erland Sommarskog, Stockholm, esquel@sommarskog.se
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar
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