Solved

msado15 Conn TimeOut (increase timeout value)

Posted on 2004-07-30
1
515 Views
Last Modified: 2009-07-29
I open a data connection using this:

CoInitialize(NULL);
conn.CreateInstance(__uuidof(ADODB::Connection));
rs.CreateInstance(__uuidof(ADODB::Recordset));
rsLoop.CreateInstance(__uuidof(ADODB::Recordset));
conn->Open("Driver={SQL Server};SERVER=X.X.X.X;UID=**;PWD=**;DATABASE=**", "**", "**",-1);

When i have a recordset who return over 2,000 row, i got a time out.
How can i increase the dataconn timeout value?
0
Comment
Question by:mammouth
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 16

Accepted Solution

by:
nonubik earned 125 total points
ID: 11678849
Call
>conn->ConnectionTimeout = lVal;
before
>conn->Open(...)

'lVal' is a Long value that indicates, in seconds, how long to wait for the connection to open. Default is 15.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will show you some of the more useful Standard Template Library (STL) algorithms through the use of working examples.  You will learn about how these algorithms fit into the STL architecture, how they work with STL containers, and why t…
Introduction This article is a continuation of the C/C++ Visual Studio Express debugger series. Part 1 provided a quick start guide in using the debugger. Part 2 focused on additional topics in breakpoints. As your assignments become a little more …
The goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…

761 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question