Setting an ADODB connection timeout when querying SQL Database

Hi, I have a VBA-driven report that is maxing out at 30 seconds (Error Number -2147217871 Query timeout expired) and I was hoping someone could help me increase that timeout time to 60 seconds. I have added this line which from Google searches, I thought would do the job but still maxes out at 30 seconds..

'cnnConnect.ConnectionTimeout = 60'

My Code.. Thanks

Please Login or Register  to view this content.