Forum Stats

  • 3,769,358 Users
  • 2,252,956 Discussions
  • 7,874,999 Comments

Discussions

Which odbc drivers should I use between essbase11 and oracle12g db?

User_3F4BA
User_3F4BA Member Posts: 1 Red Ribbon
edited Jan 17, 2020 3:41AM in Essbase On-Premise

Hello,

  

     I have a essbase 11.1.2 server build on windows server 2012 r2, and oracle extadata db 12c on linux.

     I have two odbc drivers on essbase server, one is "DataDirect 7.1 Oracle Wire Protocal", I got ora-28040 when I use it to connect db. There is one solution is to add a setting in sqlnet.ora, but I have no authority to do that.

And another driver is "Oracle in OraClient11g64_xxx". Testing connection is successfully in odbc, but when I create a rule files and choose it to be my data source, I got an odbc layer error(IM003) "Specified driver could not be loaded due to system error 127: the specified procedure could not be found(Oracle in OraClient11g64_xxx, D:\Oracle\Middleware\dbclient64\BIN\SQORA32.dll)".

     how could I do?

Tagged: