Re: Client timeout expired, settings on 10hrs on server, how change cl
- From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
- Date: Wed, 5 Oct 2005 19:10:52 -0400
See if this helps:
http://www.aspfaq.com/show.asp?id=2066
--
Andrew J. Kelly SQL MVP
"Urban" <urban@nospamplease> wrote in message
news:AA015201-3F8A-465D-9A45-317870105454@xxxxxxxxxxxxxxxx
>A client has to insert many files with bulk insert. I start it using
>windows
> scripting host with VB Script and ole db provider for SQL Server. works
> good
> and fast. Only really big files will take several minutes to terminate.
>
> How can I set the client timeout?
>
> I'm using windows server2003 SP1, SQL Server2000 SP4, MDAC 2.8 (SP1 cannot
> be installed on windows 2003 server) all on same server. Because scripts
> are
> interacting with sql-server (I'm looking foreward to sql server 2005!!!)
>
> I have seen, some have the same problem, but I have not seen solutions.
> Do I have to use ODBC instead of OLE DE?
>
> Thanks for any help!
.
- Prev by Date: Re: Connection no longer works
- Next by Date: Re: Connection no longer works
- Previous by thread: TOP 10 - EACH MODALITY
- Next by thread: Re: Client Connection Problem.
- Index(es):
Relevant Pages
|
