June 15, 2016 at 11:42 am
I have been working on this for 2 days and cant get passed
OLE DB provider "ORAOLEDB.Oracle" for linked server "CSA_ORA" returned message "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor".
Msg 7303, Level 16, State 1, Line 9
Cannot initialize the data source object of OLE DB provider "ORAOLEDB.Oracle" for linked server "CSA_ORA".
I have installed the client, added the path, tried both the easy connect method and tns names, some of the foroums indicate I need to check and make sure the listener is running but I dont have a listener service and not sure I am supposed to
June 15, 2016 at 12:07 pm
The listener service they're referring to would be on the Oracle server (presuming that's not the same as the server you're attempting to connect from.)
I'd check with the Oracle DBA as to whether it's listening or not, I would also suggest checking that the firewall on the Oracle server is allowing connections through.
June 15, 2016 at 12:16 pm
Not the same box, and thats what I thought.
June 15, 2016 at 12:28 pm
Have you set up the tnsnames.ora file on the SQL server and have you verified the information in the tnsnames is correct?
Are you sure the tnsnames is in the correct location? You can add a environmental variable to the SQL box called TNS_ADMIN and point it to where the file is to make double sure.
June 15, 2016 at 1:32 pm
I got it fixed, its wasnt me, it was bad connection information
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply