asked on

Linking a DB in SQL 2000

I am migrating our SQL 2000 databases over to new hardware bceause the old server is dying. I just used the backup/restore feature and moved the "non built in" databases without a hitch.

We have a custom app used on handhelds in our warehouse that uses a SQL backend, which also accesses information from our inventory management software, which runs on an Oracle database.

The old server's master db had a second line in the sysserver table that, from what I can tell, is a link to the oracle database. We're getting errors when we try to connect on some things (run sp_addlinkedserver to add server to sysservers) so I'm wondering what I need to do?

Did I make any sense at all? All I can find from google seaching sp_addlinkedserver is that it appears to be t-sql. Is the only way to accomplish this by using the tsql commands, or is there a way to do it in enterprise manager?

Thanks
Neal

jrb1

You need to install the Oracle Client on the new hardware.
Make sure you can connect to Oracle through SQL*Plus.

Then you can create a link through sp_addlinkedserver (or through Enterprise Manager)

ASKER CERTIFIED SOLUTION

jrb1

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Jim P.

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jim P.

No objections.