Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #1726
| From | Erland Sommarskog <esquel@sommarskog.se> |
|---|---|
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: Unable to connect Client to SQL Server |
| Date | 2014-03-12 23:20 +0100 |
| Organization | Erland Sommarskog |
| Message-ID | <XnsA2EEED6A8C514Yazorman@127.0.0.1> (permalink) |
| References | (9 earlier) <XnsA2EEA7FCDF520Yazorman@127.0.0.1> <lfq0to$k69$1@speranza.aioe.org> <lfq31r$q9l$1@speranza.aioe.org> <XnsA2EED87FC9ED2Yazorman@127.0.0.1> <lfqh0r$20d$1@speranza.aioe.org> |
Bruno Campanini (brunocam@libero.it) writes:
> I don't have any connection string yet, I was operating Access
> manually.
Well, how you would specify the connection timeout in that case is
an Access question. And I dont't know Access.
> Do you have a connection string I can work around on VBAccess?
"Driver={SQL Server Native Client 11.0};Server=SERVER;UID=User;Database=yourdb;Connect timeout=50"
Although, when I look closer, I realise that Connect timeout is
only listed for OLE DB, not for ODBC. But there must be a connect
timeout somewhere, so try the above.
--
Erland Sommarskog, Stockholm, esquel@sommarskog.se
Back to comp.databases.ms-sqlserver | Previous | Next — Previous 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