This is the message I got (asp.net)
Exception Details: System.Data.OleDb.OleDbException: ORA-12535: TNS:operation timed out
It happens when trying to open the connection.
The connection is as this: Provider=MSDAORA;User ID=xxx; Password=xxx;Data Source=xxx;
cn.Open() 'error at this line
As it sounds I should increase the timeout time, so I changed the timeout to 200 as follows:
Provider=MSDAORA;User ID=xxx; Password=xxx;Data Source=xxx;connect timeout=200;
And this is the new message I got in the same line cn.open()
Exception Details: System.Data.OleDb.OleDbException: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
The app has been working fine before my office moved to a new floor in the same building. The app still
works for some of the database (use the simular method), but not some of the database. For the ones that do not work, I can still open it from server explore from within the IDE.
Can somebody help?