Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Moore
Former Employee
Former 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

3 Replies
ashfaq_haseeb
Champion III
Champion III

Hi,

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

Regards

ASHFAQ

Daniel_Moore
Former Employee
Former Employee
Author

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

ashfaq_haseeb
Champion III
Champion III

Hi,

You may follow this

Connectivity to Oracle Database

Regards

ASHFAQ