Home Forums SQL Server 7,2000 Working with Oracle create Linked Server to Oracle DB - Is this TSQL Script correct? - Novice RE: create Linked Server to Oracle DB - Is this TSQL Script correct? - Novice

  • Thank you! I changed it to FinderFile20 at each location.

    This is the error received. Was the non standard port number needed?

    OLE DB provider "ORAOLEDB.Oracle" for linked server "FinderFile20" returned message "ORA-12154: TNS:could not resolve the connect identifier specified".

    Msg 7303, Level 16, State 1, Procedure sp_tables_ex, Line 41

    Cannot initialize the data source object of OLE DB provider "ORAOLEDB.Oracle" for linked server "FinderFile20".

    Of interest, I have installed the Oracle Directory Manager on the SQL Server 2010 server.

    The Select Directory Server with the servername and port - shows the Available to be YES

    The Oracle Directory Manager Connect uses the server/port information and ask for user password

    Apply the UN / PW. The error is Bind Failed. Host = ' server info' Details: host;port socket closed

    The oracle admin claims he can log in as me (using different software to log in).