Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

h_demarco
New Contributor III

OLEDB error with Oracle

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?

1 Solution

Accepted Solutions
h_demarco
New Contributor III

Re: OLEDB error with Oracle

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.

7 Replies
Not applicable

Re: OLEDB error with Oracle

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
New Contributor III

Re: OLEDB error with Oracle

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?

Not applicable

Re: OLEDB error with Oracle

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

Not applicable

Re: OLEDB error with Oracle

Place ORA listenr files at oracle client Libraries

Not applicable

Re: OLEDB error with Oracle

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
New Contributor III

Re: OLEDB error with Oracle

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.

Community Manager
Community Manager

Re: OLEDB error with Oracle

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

Community Browser