Error 3669

[Cindy]

Using ODBCDirect to execute a stored procedure on SQL
server 2000, I receive the runtime error of
3669 'Execution Canceled'. Can any one tell me what this
error means?

[Alick [MSFT]]

This error message usually indicates that the query against the database
has timed out.

Suggestions:

(1) Recommend setting the QueryTimeout Property of the Connection, as well
as
the Database = 0. For more information on this topic see the "QueryTimeout
Property" in the MSDN Help.

(2) If you are using the Data Control, then you can override the default
value
for the ODBC Connection timing out by creating a new "ODBC" key in the
Registry with the path
\HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\3.5\Engines\ODBC. Then you can
create a QueryTimeout parameter in this Key, setting it = 0.

(3) If you prefer not to make changes to registry, then you could set the
Recordset of the Data Control in code, thereby obtaining access to the
Properties of the Database and Connection Objects. For more information on
this topic see the following article:

147882 HOWTO: DAO: Assign a Recordset to a Data Control in VB
http://support.microsoft.com/default.aspx?scid=KB;EN-US;147882

Sincerely,

Alick Ye, MCSD
Product Support Services
Microsoft Corporation
Get Secure! - <www.microsoft.com/security>

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Content-Class: urn:content-classes:message
| From: "Cindy" <wayts-...@msha.gov>
| Sender: "Cindy" <wayts-...@msha.gov>
| X-Tomcat-NG: microsoft.public.vb.database.odbc