loading data from oracle

[#1]

Can anybody pls tell me how can i connect to oracle database from qlikview.

i also installed ODAC101040.exe bt still mt getting oracle as option while connecting..thnx in advance

[#2]

go to control panel--> administrative tools--> data sources(ODBC)-->  from the window that appears select system DSN--> add new source --> select microsoft ODBC for Oracle and check (test) connection

now in the qlikview script connect to the newly created ODBC connection

hope this would work

[#3]

thnx rishbh bt the problem is am not getting ODBC for oracle option in DSN..i have installed oracle expressedition 10 32 bit on 64bit machine..i downlaoded the OLEDB cnnector for oracle and hav installed it..bt still not getting oracle as option in DSN(add new sorce).i am nt understanding what went wrong..

[#4]

thnx can i use oracle express edition connect it to qlikview

[#5]

ohh ya..after doin forced 32 i got the option of of OLEDB for oracle..thnxbt one more help what shd i put in datasource..ORCL??

[#6]

Can u pls tell me what shd i write in datasource ..

[prodanov]

You must install Oracle Client. You must set up connection in config file manual. Config file is tnsnames.ora. You will find it in oracle folder.

[#8]

thnx dimitar..useful answer

[prodanov]

Welcome