Thread: VB6 Connection COM Object

I use a .dll COM Object for my connection/recordset for SQL Server in an ASP Web application. We currently have an app that the query takes a bit to run, so we're getting a lot of TimeOut errors. Is there a way to increase the timeout without having to edit the COM Object, recompile and re-register the DLL on the webserver?

This com object contains a recordset function as well as the connection string. So in our ASP page we just use

Code:

set obj = server.CreateObject("DataAccess.clsDataAccess")
strSQL = "SELECT * FROM tbl_TableName"
set rs = obj.fnSQL_RS(strSQL)
set obj = nothing

I wasn't sure whether to post this in VB or ASP, so here it is.

After reviewing the code, I don't see any properties that are made available for you to do this. Having said that, I would edit the COM object and provide such properties so you can may pass the connection timeout as a parameter to your methods for queries you need more time for.