ODBC ERROR Using MS ODBC for Oracle
Posted on 2006-06-15
In a web application using ASP and Oracle, after moving to a new Win 2003 server and re-installing the software, we had the application working fine, and then the next day we started getting this error:
"ERROR 2001 Microsoft OLE DB Provider for ODBC Drivers [Microsoft][ODBC driver for Oracle][Oracle] (-2147467259)".
We can ping the database with no problem. I set up an Access database and linked to the one of the Oracle tables readily. However, if I close Access and reopen it, I get the "ODBC Connection to [DSN name] failed." error. I created a new system ODBC connection using the Oracle ODBC driver and then used that to link to one of the Oracle tables in Access. Worked fine again, until I closed Access and reopened it, then I get the same error as with the Microsoft ODBC DSN.
I have added the IUSER to all the many places (registry, all the relevant directories) to no avail. I have searched everywhere on this problem and done everything that seems relevant to no avail. Downloaded new MDAC file from Microsoft and installed it, no difference.
Does anyone have any ideas? About to pull all my hair out!!