Geek Answers Handbook

Connect to Oracle 8.0 database using 10g client

I recently upgraded my oracle client to 10g (10.2.0.1.0).

Now, when I try to connect to the old 8.0 database, I get

ORA-03134: Connections to this server version are no longer supported.

Is there any workaround for this problem or do I need to install two clients on my local computer?

+5
source share
3 answers

Yes , you can connect to the Oracle 8i database with the 10g client, but for the 8i database you need the patch set 8.1.7.3, which you can get from the Oracle Metalink Support Site (login required).

Here 's the Oracle forum post with details.

Oracle , 2 ( "Oracle Homes" ( ) selecthome.bat .

, 8i :

C:\Oracle\Client1_8i\bin\selecthome.bat

, Oracle 10g:

C:\Oracle\Client2_10g\bin\selecthome.bat

+7

# Oracle 7 ( , 8...)... , , - - Oracle Server " Configuration Component" Oracle73 Ver2.5.

, - Oracle 8 Server , ODBC.

+1

The best way to connect Oracle 8.1.7 and higher is through Instant Client. Download Instant client 10.2 from oracle, copy all the files to the same folder where the .NET assemblies are located, and use the classes located in System.Data.OracleClient. This work for me in the .NET 4 project and oracle DB 8.1.7 server.

0
source

More articles:


All Articles