I have two databases and a Linked Servers which connects between SQL Server 2000 and Oracle 8i.
When i try to access the tables and views under the Linked Server named EOP1 i can see all the tables and views from Oracle.
I have yet another Linked Server which connects the two SQL Databases residing on same server.One of these databases uses EOPI linked server to execute the queries against Oracle db.
When i fire a sproc from one SQL database to execute a sproc in other SQL database which in turn queries against Oracle Database i get the following error.
Server: Msg 7202, Level 11, State 2, Procedure spGetNewExhibitJSubContractorsDetails, Line 16
Could not find server 'EOP1' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.
Can anyone please help me on this one.I have created the EOP1 linked server and supplied all the required details but i still get this error as if it not created and not present at all.