Linked to Oracle

In my SQL Server I had a link to Oracle server and everything was working fi
ne. Recently I moved all the SQL Server databases to a different SQL Server
box and also installed Oracle client on this new server and restarted the se
rver after installing Oracl
e client but still getting the following error message.
Error 7399: OLE DB provider 'MSDAORA' reported an error'
Any suggestion?Can you create a UDL file and connect to the Oracle database using that.
To create a UDL file:
Create a text file on the desktop.
Rename the text file with a .udl extension
The icon should change to a printout with a computer in front of it.
Double click on the icon and fill in the necessary information.
On the Connection tab click the Test connection button.
If this fails then there is a general connectivity problem. If it succeeds
login as the SQL server startup account and test the connection with that
account.
Rand
This posting is provided "as is" with no warranties and confers no rights.