Hi,
Can anyone tell me how to set the command timeout to 0, or any other number for that matter using the following recordset connection and open string?
objConn.Open "Driver={SQL Server}" & _
"Server=x.x.x.x;" & _
"Address=x.x.x.x,1433;" & _
"Network=DBMSSOCN;" & _
"Database=yyy;" & _
"Uid=user" & _
"Pwd=pass"
sSQL = "SELECT InvoiceYear, InvoiceMonth, InvoiceDay, InvoiceDate, InstituteName, CourseName, ItemNet , ItemTax FROM dbo.Table_Sales ORDER BY InvoiceDate"
rsData.Open sSQL, objConn, adLockReadOnly, adCmdText
Many thanks in advance
Martin