OLEDB error with Oracle

[h_demarco]

Folks,

While in 32bits computer this connector works fine. Script was always sucessfully finished.

OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=gestao;Data Source=plast] (XPassword is xxxx)

Now I moved QVW file to a 64bits server with QlikServer and I am getting following error:

ErrorSource: Microsoft OLE DB Provider for Oracle, ErrorMsg: Error while trying to retrieve text for error ORA-01019

I already installed Oracle OLEBD instead of keep using Microsoft's (as far as I know MSDAORA is deprecated). So I had a new connector string:

OLEDB CONNECT32 TO [Provider=ORAOLEDB.ORACLE;User ID=gestao;Data Source=plast] (XPassword is xxxx)

Using this new provider I got following error:

ErrorSource: OraOLEDB, ErrorMsg: ORA-12154: TNS:could not resolve the connect identifier specified

How to solve it?

Oracle DB is in Server1 and QlikServer+QVW is in Server2. Can be a connection problem between both?

[#2]

Oracle Database 11g Release 2 Client (11.2.0.1.0) for Microsoft Windows (32-bit)‌

use correct oracle client oledb drivers, Re configure Oracle listener files ORA , First test Oracle listeners ORA and  DB credentials on ODBC driver section on windows server where qlik installed

[h_demarco]

Srinivas,

I installed Oracle Database client 64-bit on Qlikview Server following attached document instructions.

During connection test "host was not found".

Using previous connection method the data source was filled out with "plast", but now it is not working.

Any idea?

[#4]

on windows server odbc configure for oracle, use right Oracle listener file like ORA [all info about DB],  setup first sys dsn, file dsn, user dns

[#5]

Place ORA listenr files at oracle client Libraries

[#6]

above document shows only install of oracle client,but  after that you need to configure ODBC on windows server, get DB ORA listener files , Setup SYSDSN, FILEDSN, USERDSN, Place ORA listener files at oracle client Libaries at this point you need test connection at ODBC driver configure section,If its successful here then its work on QLIK

[h_demarco · Accepted solution]

Problem solved.

I just installed ERP and then all Oracle setup was done automatically.

By the way, my second connection string (ORAOLEDB.ORACLE provider) was wrong.

Thanks for your help Mr. Jonnakuti.

[Anonymous]

Hi Henrique,

We're glad to hear you were able to solve your issue. Please take a moment to mark a reply as Correct Answer so that the thread will be marked as Answered. For more info, please see Qlik Community Tip: Marking Replies as Correct or Helpful.

Best regards,

Qlik Community Team