Hi,
I want to load the data from excel to Oracle DB in Linux RedHot Server.
I am unable to connect to MIcrosoft excel odbc drivers in linux server
If i use linux server to load the data from excel to oracle db, is need to install excel drivers in linux?
How to place the drivers in linux and how to do dns configurations for excel.
Please help me.
Actaully, i am using odi studio 11g client is in windows system.
I have connected to master repository & work repository successfully, these are configured to linux server Oracle DB.
Linux server Orcale DB connections successfully.
I have cretaed dsn for excel is in windows system . odi studio client also in windows system.
when i amtrying to connect to excel dsn in topology.
I am getting following error
odi 26039 connection failed
[unixODBC][Driver Manager]Data source name not found, and no default driver specified
Pleas help me,
Thanks& Regards,
A.kavya.