Setting ODBC Timeout Value

[Dad0AEW]

I have an Access97 app (they're not in a position to upgrade) that has links to data in a SQL Server database. There are some pretty intense queries that are in it that ran fine when the interface and data was all Access, but now the the data is in SQL Server I'm getting error messages that imply that the SQL Statement itself is too long. Investigating further it appears as though the actual problem is the ODBC connection is timing out. Does anyone know of a way to increase the time?

Thank you.

 

[lameid]

Wow... Access 97... I think the general settings are Under Tools, Options and on the general tab (least certain about the tab).

Also, you may be able to set it in the connection string. I think setting it to 0 makes it no timeout at least for SQL Server but I'm not 100% sure.

Hopefully this goes without saying but you should be using as many SQL Pass Through queries as much as possible to improve performance.