jez.lisle (2/4/2010)
dweil (2/4/2010)
I think you are getting closer now that you can connect via sqlplus.Search the entire computer to see if there is more then one copy of tnsnames on it.
In SMSS, right click on the linked server
Click script linked server as
Click create to
Click new query editor window
You might get a hint from the sql to create the linked server
You might also want to post the sql without any confidential information hidden
Cool, Ill have a go at that now 😀
I forgot to change it, can you edit the HOST and put MyServer on your previous post please, it wont let me edit it 🙂
Jez
Ok, I did a search for all the tnsnames and found them in the folders below
E:\Oracle\product\10.2.0\client_1\NETWORK\ADMIN
E:\Oracle\product\10.2.0\db_1\NETWORK\ADMIN
Should I delete or rename the one in db_1?
I also follow your instructions to create a LinkServer through SMSS I ended up with the same error,
OLE DB provider "OraOLEDB.Oracle" for linked server "SINGLEPLATFORM" returned message "ORA-12541: TNS:no listener".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "SINGLEPLATFORM".
so I added the port onto the IP Address and tried again. I still got an error
OLE DB provider "OraOLEDB.Oracle" for linked server "HSP" returned message "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor".
Msg 7303, Level 16, State 1, Line 1
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "HSP".
When I create my LinkServer name in SMSS can I use any name? and using OraOLEDB.Oracle is this correct?
dweil - can you edit the post you last wrote and over type the Server name. Thanks