Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Which error you get? Have you added your database connections into the tnsnames.ora file?
- Ralf
I think you would need both downloads:
- Ralf
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.
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."