oledb connection

[ssriramin19]

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

[shiveshsingh]

Hi Sri

Please check below link, you'll get your answers

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

[shiveshsingh]

[ssriramin19]

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

[shiveshsingh]

Hi

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.

[ssriramin19]

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

[shiveshsingh]

May be this can help

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

[ssriramin19]

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