Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Employee
Employee

Connecting to Oracle 11.X

Trying to connect QVS 11.2 SR7 to Oracle client driver 11.2.0.4. We're using Oracle 11G R2 on Win Server 2012. 


The connection string that we're using is:

Data Source=UATDB;User Id=user1;Password=pwd1


QVS setup is attached.


ERROR MSG:


Error is Value Cannot be Null. Parameter Name: NonDelimitedObjectName”



Is there some way to better understand what we're missing? How do I trace the error code from the Oracle driver? Has anyone successfully connected Win Server 2012 with Oracle 11.X?
My company will allow me to connect Windows Server 2012 with a different version of Oracle 11.X and QVS up to SR 7 or prior.

On the same machine Oracle 12.1 odbc client worked using the following connection string:

Driver=Oracle in OraClient12Home1;Dbq=UATDB;Uid=user1;Pwd=pwd1

Tags (3)
3 Replies

Re: Connecting to Oracle 11.X

Hi,

You need to have same version of client as that of oracle DataBase.

Regards

ASHFAQ

Employee
Employee

Re: Connecting to Oracle 11.X

Thanks for the quick response - unfortunately that is not working - We tried using Oracle 11.2.0.4  with the same client version.

Re: Connecting to Oracle 11.X

Hi,

You may follow this

Connectivity to Oracle Database

Regards

ASHFAQ

Community Browser