topic Re: oledb connection in Water Cooler

oledb connection

ssriramin19 — Tue, 20 Nov 2018 05:08:32 GMT

Hello Everyone,

I am trying to understand OLEDB connection created in one of the application. Below is the connection string

OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=mme_read;Data Source=MMEODSPRD;Extended Properties=""] (XPassword is bafCeZFGCDcADaZMBLaEWRVOUbdCWUJMELMaGSZMTTYOP);

How to get above connection string. ? I am unable to understand how the above connection string has been formulated.

Can anyone please help me on the OLEDB connection string.

The QV 12 version 64 bit has been installed in my machine.

Thanks - Sriram

Re: oledb connection

shiveshsingh — Tue, 20 Nov 2018 05:18:43 GMT

Hi Sri

Please check below link, you'll get your answers

https://community.qlik.com/t5/QlikView-Scripting/connection-string/td-p/541425

Re: oledb connection

shiveshsingh — Tue, 20 Nov 2018 05:20:30 GMT

Re: oledb connection

ssriramin19 — Tue, 20 Nov 2018 05:30:28 GMT

I am selecting Microsoft OLEDB provider for ODBC drivers . I have provided the Datasource name and username and password.
When I tried to test the connection , Test connection has failed because of error in initializing provider. Unspecified error.
The database is Oracle db.
Can you please help me what needs to be done further . I am stuck here .

Thanks

Re: oledb connection

shiveshsingh — Tue, 20 Nov 2018 05:41:56 GMT

Do you have oracle installed in your system?

Then you'll get Oracle Provider for OLE DB while selecting drivers. Then you need to check the details through TNS in oracle.

Re: oledb connection

ssriramin19 — Tue, 20 Nov 2018 05:47:05 GMT

I haven't installed Oracle 11g or 12c in my system. Oracle SQL developer only installed in my system.

Which version of Oracle needs to be installed for getting Oracle provider for OLEDB while selecting drivers?

Guide me please

Re: oledb connection

shiveshsingh — Tue, 20 Nov 2018 05:49:15 GMT

May be this can help

https://docs.oracle.com/cd/B28359_01/win.111/b28431/intro.htm

Re: oledb connection

ssriramin19 — Tue, 20 Nov 2018 06:02:09 GMT

I will check on it . and will let you know , Thanks for the details..