Oracle 9i and ASP on same machine
-
Does anybody have experience with this? Here's the scenario: I have a Classic ASP web application that ran just fine on the same machine with an instance of an Oracle 8i database. So, in more specific terms ... one machine running both an Oracle DB and IIS to display information in web pages. This worked. Then I upgraded the DB to 9i and it does not work. IIS still works, but when the ASP pages get to the point of trying to create the ADODB.Connection to Oracle ... error. Two different errors occur because I have tried to connect to the DB two different ways. Using OLE DB: Oracle error occurred, but error message could not be retrieved from Oracle. Using a DSN from ODBC: Specified driver could not be loaded due to system error 5 (Oracle in OraHome92). Both instances point to driver related errors and the second hints to permission problems. I have tried allowing full permissions to everyone for just about everything possible on a test machine and can see no reason for drivers to be fouled up. Installing the most recent version of the MDAC has been attempted to no avail ... reinstalling the Oracle Client tools ... no go. Even a full reinstallation of Windows 2000 Server, the Oracle DB and the web app still results in the same errors. If you can help shed any light on this or give suggestions of things to try I am more than willing to try them. TIA.
Wally Atkins
Newport News, VA, USA -
Does anybody have experience with this? Here's the scenario: I have a Classic ASP web application that ran just fine on the same machine with an instance of an Oracle 8i database. So, in more specific terms ... one machine running both an Oracle DB and IIS to display information in web pages. This worked. Then I upgraded the DB to 9i and it does not work. IIS still works, but when the ASP pages get to the point of trying to create the ADODB.Connection to Oracle ... error. Two different errors occur because I have tried to connect to the DB two different ways. Using OLE DB: Oracle error occurred, but error message could not be retrieved from Oracle. Using a DSN from ODBC: Specified driver could not be loaded due to system error 5 (Oracle in OraHome92). Both instances point to driver related errors and the second hints to permission problems. I have tried allowing full permissions to everyone for just about everything possible on a test machine and can see no reason for drivers to be fouled up. Installing the most recent version of the MDAC has been attempted to no avail ... reinstalling the Oracle Client tools ... no go. Even a full reinstallation of Windows 2000 Server, the Oracle DB and the web app still results in the same errors. If you can help shed any light on this or give suggestions of things to try I am more than willing to try them. TIA.
Wally Atkins
Newport News, VA, USA -
If this spiked anybody's curiosity I'd just like to let folks know that OO4O turned out to be a diamond in the rough. Still haven't figured out what the deal was with ADO but, hey, it works now. :-D
Wally Atkins
Newport News, VA, USAD2F3U wrote: OO4O turned out to be a diamond in the r can u just explain and tell me... how u got things working! I was born intelligent
Education ruined me!. -
D2F3U wrote: OO4O turned out to be a diamond in the r can u just explain and tell me... how u got things working! I was born intelligent
Education ruined me!.In one case we had a server that had both an 8i instance and a 9i instance and when we switched the ASP code to use OO4O everything magically worked again. The other case was the same machine scenario (8i and 9i both installed) but the OO4O still gave us some funky permissions error. We wiped the machine of Oracle (both instances removed) and even cleared the registry of all the Oracle info. Then 9i was put back on and we had to give the IUSR and the IWAM users read and execute on permissions on the Bin directory. After all that things were running smoothly again. Crazy huh? If you are using ASP with OO4O this link should help things get rolling: http://www.15seconds.com/issue/000131.htm To my knowledge, OO4O now comes with a normal installation of 9i but did not come with 8i. I hope this is helpful information.
Wally Atkins
Newport News, VA, USA