How To Increase The Timeout Limit on ODBC Long Queries - Currently Times Out at 40 minutes

Question

Hello:
I am using an ODBC link from Microsoft Access to my client whose system is based on Azure. When I do a long query that lasts over 40 minutes, I get a message that the connection was terminated by SQL Server.
How Can I increase the time limit for a long ODBC connection to more than 40 minutes?
Thanks,
Rich Locus

Answer 1

Try setting the timeout to zero as follows:

lblMessage.Text = sql         
cmd = New OdbcCommand(sql, conn)    
  
cmd.CommandTimeout= 0     
  
ra = cmd.ExecuteNonQuery()        
lblMessage.Text = "ssssst"   

Answer 2

Thank you!