How to set the query timeout in ADO_RecordsetPtr (without _ConnectionPtr)

lyz1984321

When using ADO for database programming, you need to use multiple threads to load the data of several recordset objects at the same time to improve the use of the network. Therefore, only the _RecordsetPtr record set object is used, and no corresponding _ConnectionPtr object is established. _RecordsetPtr query timeout?

lyz1984321

Why didn't anyone reply ...

深蓝旅者

Some attributes can be placed in the connection string
ConnectionString = "provider = SQLOLEDB; CommandTimeout = 60; ... more properties ..."

lyz1984321

Is there any more detailed introduction, the connection string I used is like this:
"Driver = {SQL Server}; Server = 127.0.0.1,8000; Database = dataname; Uid = username; Pwd = password;"

I added CommandTimeout = 60; inside, there is nothing wrong, but it seems that sometimes it is not enough for 60 seconds to prompt a timeout

深蓝旅者

provider = SQLOLEDB; and Driver = {SQL Server}; are connection strings in different formats!

lyz1984321

Thank you深蓝旅者, I have found a more detailed description on MSDN, Connect Timeout, but I did not find CommandTimeout~, that’s all,