connect oracle database using OLE DB connection

[stephenedberkg]

i want to connect the oracle database but i am getting error.

i don't know what is my data source and where can i get this?

[Chanty4u]

you have to select in provider tab microsoft jet4.0  like that you vill hve select that and do test connection.

hope this helps you

[avinashelite]

Hi Stephen,

Does your TNS Names.org file has the db details which your connecting ? please check that in the oracle>product>network>admin>tns names.org file . Have you installed oracle your system