November 17, 2014 at 5:14 am
I have to connect to an instance of oracle 9 on an old server.
I am running windows 7, vs2012.
I have had no luck with this despite fighting it for over a day now. Id appreciate any help that you guys have to offer:
Some issues:
-I cant find just the oracle client install files online. All i can find is the full blown versions of oracle.
-oledb connection not appearing despite oledb connector being installed ( using udl file to test).
Appreciate any help.
Thanks!
November 17, 2014 at 7:13 am
The Oracle 9 client is not available since 2010 if I recall correctly.
You can use newer versions of the client to connect to older server versions.
You can download the Oracle 11g client from here: http://download.oracle.com/otn/nt/oracle11g/112010/win64_11gR2_client.zip
You will be prompted for username and password: if you're not registered you can do so for free.
-- Gianluca Sartori
November 17, 2014 at 7:37 am
Ok, that got me a bit further, when i try to create a connection to the oracle server now i get the error:
"Connection failed because of an error initializing provider. ORA-03134: Connections to this server version are no longer supported."
November 17, 2014 at 7:52 am
I think it might have to do with the bitness of the client.
VS runs the x86 version of the client (which you don't have, since I posted the link for the x64 version).
If the server is x64 (which is very likely), even if told otherwise, uses the x64 version.
For the development computer, uninstall the x64 version and install the x86 version.
For the server, use the x64 version.
-- Gianluca Sartori
November 17, 2014 at 8:33 am
same error unfortunately.
Tried on the server with the x64 version ( tested with a UDL connection file).
Tried on my dev machine with the 32 bit version within VS 2012. Same "connections ot this server version are no longer supported" error in both cases.
November 18, 2014 at 2:04 am
Oracle 9 is really old by now. Maybe you can connect to it if you have the oracle 11g client en the oracle database is at least 9.2.0.4. The 12c client doesn't support this anymore.
You could try the obsolete System.Data.OracleClient Namespace
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply