Pass-Through Queries Time-Out - Help?

Kenln

Registered User.
Local time
Today, 15:53
Joined
Oct 11, 2006
Messages
551
I create Pass-Through queries dynamically. The string I use when I create them is "ODBC;Driver={Sql Server};Server=Apollo;Database=TimeCard;Trusted_Connection=Yes"

I tried "ODBC;Driver={Sql Server};Server=Apollo;Database=TimeCard;Trusted_Connection=Yes;Timeout=300" but when I looked at the query it didn't change the Time Out.

Ideas, help?

Thank you
 
I found the answer and oddly enough it isn't in the connection string. After I create the query and before I close the Query Definition I can set a time out 'qdfdef.ODBCTimeout = xxx'

If anyone needs it.
 

Users who are viewing this thread

Back
Top Bottom