OLEDB, ODBC & .NET framework v1.1 [message #101416] |
Mon, 20 September 2004 13:33 |
RobertS
Messages: 4 Registered: May 2004
|
Junior Member |
|
|
We are experiencing some issues & was wondering if there are any known problems.
We have:
- 1st server running IIS (Win2k srv & ASP)
- 2nd server running COM packages (Win2k srv)
- 3rd server hosting Oracle 9 (Solaris)
Everything is running fine. ASP on the 1st server calling a com object on the 2nd server which in turn connects to Oracle 9 box.
Our developers use different providers; some use OLEDB & some ODBC from Oracle. For the latter v9.00.11.00.
Again everything was working fine for over a year.
Now, the developers need to use ASP.NET for the newer portions of the web app they are building - I.E. not a complete revamp but ASP & ASP.NET co-existing peacefully.
First order was to install the .NET framework v1.1 on both Windows servers. Even before putting any new ASP.NET code on them we tested the current code base. Miserable - the 2nd server with the com objects can not get connected to Oracle database server anymore.
We've checked the ODBC setting & the interesting thing is that it might have corrupted the Oracle driver v9.00.11.00 on the 2nd server.
So we try to reinstall it from the Oracle CD & when it is around 99% complete it errors out saying that OLEDB(?) driver or something to that effect did not install. We can not seem to get over that hurdle & we're dead in the waters.
Is it possible that some newer version of MDAC or something that Oracle driver v9.00.11.00 requires is not compatible in the .NET environment?
Thanks for any insight!
Robert
|
|
|
|