topic Re: Use an oraOLEDB Connection omitting tnsnames.ora in QlikView

Use an oraOLEDB Connection omitting tnsnames.ora

alexandra_dh — Thu, 06 Sep 2018 14:03:35 GMT

Hello,

I'm using Qlikview 12 SR6 and I use different kind of OLEDB Connections :

- Connections for SQL Server DB. In this case, no need to configure the server with modifying a file or creating an ODBC connection. I can use my connection string on all servers or local computers.

- Connections for Oracle DB. In this case I use the tnsnames.ora file. It's running but I can't deploy my application on a server on wich I don't have configured the tnsnames.

I tried to use a tnsnames-less connection but it doesn't run ... Qlik asks me a Datasource Name.

I want to transform this :

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Data Source=DS_TEST;User ID=MyUser;Password=MyPwd]

tnsnames :

DS_TEST=

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name)(PORT=port_number))

(CONNECT_DATA=(SERVICE_NAME=DS_TEST)))

To something like that:

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;SERVER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=host_name)(PORT=port_number)))(CONNECT_DATA=(SERVICE_NAME=DS_TEST)));User ID=MyUser;Password=PyPwd]

Is it possible ?

Thanks,

Re: Use an oraOLEDB Connection omitting tnsnames.ora

MarcoWedel — Thu, 06 Sep 2018 20:59:35 GMT

maybe something like

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;User ID=YourUserID;Data Source="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=YourHostName)(PORT=YourPort)))(CONNECT_DATA=(SID=YourSID)))";Extended Properties=""] (XPassword is YourXPassword);

hope this helps

regards

Marco

Re: Use an oraOLEDB Connection omitting tnsnames.ora

alexandra_dh — Fri, 07 Sep 2018 08:50:30 GMT

Thanks Marco,

have added the double quotes on the DataSource Name and it solves my problem !