problem creating link to Oracle db

Hi,

I have installed the Oracle 10g client 10.2 on the sql server; placed tnsnames.ora file in oracle directory and created
TNS_ADMIN enviroment variable with value (D:\oracle\product\10.2.0\client_1\tnsnames.ora) but when I try to create
system dsn the drop down box shows no entries forTNS Service Name so a connection cannot be setup.
My understanding is if I can't do this then I cannot create a link to the Oracle box.

The only tool in the oracle program files is the microsoft odbc Administrator and some ole help files
entering sqlplus at commandline prompt returns "sqlplus is not recognized as an internal or external command"

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

try installing the client again checking the options... you should first do the connection through SQLPLUS once that's done and it's working fine... you need to change certain registry keys (I will look them up for you) to get OLEDB to work (aka linked servers)

0

deNZityAuthor Commented: 2006-07-11

I installed sqlplus and tried to connect to the oracle db and got...

could not resolve the connect identifier specified

so the tnsnames.ora file in the client directory cannot be getting read.

Thanks Eugene I will read the articles. Einstein there is no tnsping.exe in the bin folder.

Have done a custom reinstall of both client and the oracle windows interfaces.
I now have network\ADMIN\ folder so have put both tnsnames.ora and sqlnet.ora
files in this folder and removed the TNS_ADMIN enviroment variable.

Was able to create an odbc connection "YAY" TNS Service Name drop down had the relevant servers.
created the link but get an error message 7399 OLE DB Provider 'Microsoft.jet.oledb.4.0' IDBInitialize::Initialize returned ox80004005

0

deNZityAuthor Commented: 2006-07-11

copied tnsping.exe from other oracle directory on differnet pc to oracle bin directory on sql server.