Link Between SQL Server 2000 and MSDE Not working! Please HELP !

Hello. I have a SQL Server 2000 Database set up on our network.
We want to run a process on another machine. This machine has MSDE Installed
on it. I have created a new entry in the Linked Server options of the MSDE
Machine to our SQL Server.
However, on trying to query the SQL Server 2000 tables from the MSDE
Database, I get this error:
Error 7302: Could not create an instance of OLE DB Provider 'SQLOLEDB'
I have checked the MDAC_TYP using the MDAC_TYP Checker, and both the SQL
Server and MSDE Machines have the same version running.
I have pinged the SQL Server from the MSDE Server and they can both see each
other.
Any suggestions you might have would be greatly appreciated!!
Thanking you in advance,
m00nm0nkey!!
In message <29E143E6-25FB-4EFF-88B9-D9EE8E23122C@.microsoft.com>,
m00nm0nkey <m00nm0nkey@.discussions.microsoft.com> writes
>Hello. I have a SQL Server 2000 Database set up on our network.
>We want to run a process on another machine. This machine has MSDE Installed
>on it. I have created a new entry in the Linked Server options of the MSDE
>Machine to our SQL Server.
>However, on trying to query the SQL Server 2000 tables from the MSDE
>Database, I get this error:
>Error 7302: Could not create an instance of OLE DB Provider 'SQLOLEDB'
>I have checked the MDAC_TYP using the MDAC_TYP Checker, and both the SQL
>Server and MSDE Machines have the same version running.
>I have pinged the SQL Server from the MSDE Server and they can both see each
>other.
>Any suggestions you might have would be greatly appreciated!!
>Thanking you in advance,
>
Pinging the servers does not prove anything other than each PC is on the
network. Can you connect to the MSDE Server through Enterprise Manager
(adding it to the default Server Group) on the SQL Server machine.
If yes, it is most likely something wrong in how you have defined the
link or referencing the SQL Server in your queries.
If no, then it would suggest the MSDE Server does not have the Network
Protocols enabled (turned off by default in a normal installation).
Alternatively, you may have a firewall or packet filtering enabled on
the MSDE machine blocking ports 1433 (TCP) and 1434 (UDP).
Andrew D. Newbould E-Mail: newsgroups@.NOSPAMzadsoft.com
ZAD Software Systems Web : www.zadsoft.com