Connect to Oracle 11g from Qlikview 10

[Anonymous]

Hi,

I am trying to connect to oracle 11g from  Qlikview 10.

Below steps i followed to connect.

Downloading base and odbc instanct clients 11_2 for 32 bit windows machine.

Both are unzipped into same folder say(C:\Instantclient).

I set the Path environment variable C:\Software\instantclient\instantclient_11_2.

And Created tnsnames.ora file under the C:\Software\instantclient\instantclient_11_2.

Then i try to create datasources for Oracle using OLEDB or ODBC i am getting the error.

Can someone help me ?

Thanks

Ramesh

[rbecher]

Which error you get? Have you added your database connections into the tnsnames.ora file?

- Ralf

[rbecher]

I think you would need both downloads:

• Instant Client Package - Basic: All  files required to run OCI, OCCI, and JDBC-OCI applications
• Instant Client Package - ODBC: Additional libraries for enabling ODBC applications

- Ralf

[Anonymous]

i Downloaded Basic and ODBC instant client packages and both are unzipped into samefolder.

Also added database connections to  tnsnames.ora file.

I am getting the below error while creating data sournces

settings-> control panel -administrative tools-Data Sources ->System Dsn -> Add ->

here i am selecting Oracle in Instantclient_11_2,  then i am getting below error.

the setup routines for oracle in instantclient_11_2 ODBC driver could not be loaded due to system error Code 126.

[rbecher]

The only thing I can found for now is this on an Oracle forum post:

"Please check that you are doing this with administrator privileges on the windows machine."