Timeout Expired Errors - Need Expert Consultant - Have done a ton of research already

From: Eric Margheim (eric_at_prism-grp.com)
Date: 02/24/04 

Date: Tue, 24 Feb 2004 09:48:19 -0600

I have a ATL DLL running in COM+ Applications that communicates with SQL
Server via ADO Command Object. We occasionally get Timeout Expired errors
with one method that is used to call stored procedures that return output
parameters. The error can come back quickly or take a while.

I have done a ton or research. Have looked into Connection Pooling issues,
ODBC settings, ADO, etc.

I need a consultant who is an expert in COM+, ADO and SQL Server to help me
debug this. Please contact me privately if you can help. I'm willing to
pay an hourly rate if you can help me solve this issue.

Thanks

Relevant Pages

  • dumb previous question - repost
    ... Here is what I do right now with com ado from ... transfer data if you are going from server to server<< ... from sql server to Access in a few seconds. ... my vb.net app with 2 tables, tblsql and tblAccess is this ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: ADO Data Control CacheSize causing Locks in SQL Server?
    ... >We have a VB6 program that uses the ADO Datacontrol to pull records from SQL ... >Server 2000 for browsing prior to selecting a record for editing. ...
    (microsoft.public.sqlserver.programming)
  • Re: Oracle und MS-SQL
    ... > Wenn ich über SQL QueryAnalyzer oder EnterpriseManager mir den View ... Könnte es sein dass Du einen Keyset Recordset (ADO oder ODBC) ... Der ist zwar für reinen SQL Server Zugriff längst ... sp_prepare ausgeführt und das mag den Oracle Provider verwirren. ...
    (microsoft.public.de.sqlserver)
  • Re: ADO Connection to Backend SQL server
    ... I am trying to use an ADO connection to return a Select ... I have been able to establish the connection to the SQL Server ...
    (microsoft.public.vb.database.ado)
  • Timeout Expired Errors - Need Expert Consultant - Have done a ton of research already
    ... I have a ATL DLL running in COM+ Applications that communicates with SQL ... Server via ADO Command Object. ... We occasionally get Timeout Expired errors ...
    (microsoft.public.sqlserver.odbc)