I am not sure if this is the correct place to ask this question but here goes. Also, I am somewhat of an amateur when it comes to most of this. Anyway, here goes. I am running ORACLE Client32bit 11.2.0.2. I have a query that takes about 40 seconds to run in SQL Analyzer. I have the query embedded in VBa in an Excel spreadsheet. When I try to execute the macro which runs said query, I get an ORA-01013 error being caused by a timeout. Is there some parameter which needs to be set in order to prevent this from happening? I tried adding an 'sqlnet.expire_time' parameter to my sqlnet.ora file to no avail. I also tried to set a ConnectionTimeout in my VB code but it wasn't supported. Any help is most appreciated.
Thanks.