topic Connecting to Oracle 11.X in QlikView

Connecting to Oracle 11.X

Daniel_Moore — Wed, 12 Nov 2014 16:12:43 GMT

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

Re: Connecting to Oracle 11.X

ashfaq_haseeb — Wed, 12 Nov 2014 16:26:36 GMT

Hi,

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

Regards

ASHFAQ

Re: Connecting to Oracle 11.X

Daniel_Moore — Wed, 12 Nov 2014 16:55:17 GMT

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

ashfaq_haseeb — Wed, 12 Nov 2014 16:58:09 GMT

Hi,

You may follow this

Connectivity to Oracle Database

Regards

ASHFAQ