Linked Server from SQL Server 2016 to Oracle 8i, Linked Server from SQL Server 2016 to Oracle 8i

• Lankesh

  SSC Enthusiast

  Points: 184

  More actions

  June 5, 2017 at 11:05 pm

  #337456

  Hi ,

  I am trying to establish Linked server from SQL Server to Oracle8i , i have installed oracle 12 c Oracle Data Access Components and tried, but i got this error. 
  Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "ABCD".
  OLE DB provider "OraOLEDB.Oracle" for linked server "ABCD" returned message "ORA-03134: Connections to this server version are no longer supported.". (Microsoft SQL Server, Error: 7303).

  Could any one help me on this.

• frederico_fonseca

  SSCoach

  Points: 16045

  More actions

  June 6, 2017 at 6:29 am

  #1945573

  in order to link to 8i max oracle client version is 10g
  see http://www.dba-oracle.com/t_oracle_client_versions_higher_lower_database_release.htm for full compatibility list - may be outdated but for your purpose it is enough