topic Re: OLEDB error with Oracle in QlikView

OLEDB error with Oracle

h_demarco — Wed, 13 Jul 2016 14:58:59 GMT

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?

Re: OLEDB error with Oracle

Wed, 13 Jul 2016 15:51:42 GMT

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

Re: OLEDB error with Oracle

h_demarco — Wed, 13 Jul 2016 21:09:28 GMT

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?

Re: OLEDB error with Oracle

Wed, 13 Jul 2016 22:09:22 GMT

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

Re: OLEDB error with Oracle

Wed, 13 Jul 2016 22:16:05 GMT

Place ORA listenr files at oracle client Libraries

Re: OLEDB error with Oracle

Wed, 13 Jul 2016 22:38:09 GMT

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

Re: OLEDB error with Oracle

h_demarco — Thu, 14 Jul 2016 21:01:09 GMT

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.

Re: OLEDB error with Oracle

Anonymous — Thu, 14 Jul 2016 21:28:43 GMT

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