after installing odac and oracle client 12.2 ,i test the oracle connection via visual studio 2015 using system.data.oracleClient,my oracle db version is 9i, the connection working fine at visual studio 2015 , but when i deploy it as Webpart to sharepoint 2016 its make an error while its work fine as webpart in sharepoint2010. the problem just in sharepoint2016, i use .net framework 4.5
i dont understand how its working at visualstudio while not working in sharepoint 2016 the error is Error=ORA-03134: Connections to this server version are no longer supported
Application error when access mypage here, Error=ORA-03134: Connections to this server version are no longer supported. at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)
Client 12.2 can not connect to Oracle 9i, only 11.2 client can connect to 9.2.0. Client/Server Interoperability Support [ID 207303.1]