linked server , Oledb error....Urgent.

HI,
I am getting below error when creating linked server,infact in provider
options list box none of the provider is getting displayed.
in case if i select sql server then linked server is created but clicking on
tables below error message is displayed.
SQL Server Enterprise Manager
--
Error 7302: Could not create an instance of OLE DB provider 'SQLOLEDB'.
OLE DB error trace [Non-interface error: CoCreate of DSO for SQLOLEDB
returned 0x8007007f].
--
appreciating everyone help.
SanjayYou'd probably want to check your MDAC installation on that server.
You can use the component checker to do this. You can download the
component checker as well as MDAC versions from:
http://msdn.microsoft.com/data/mdac/default.aspx
-Sue
On Tue, 26 Oct 2004 03:15:03 -0700, Sanjay
<Sanjay@.discussions.microsoft.com> wrote:
>HI,
> I am getting below error when creating linked server,infact in provider
>options list box none of the provider is getting displayed.
>in case if i select sql server then linked server is created but clicking on
>tables below error message is displayed.
>
>SQL Server Enterprise Manager
>--
>Error 7302: Could not create an instance of OLE DB provider 'SQLOLEDB'.
>OLE DB error trace [Non-interface error: CoCreate of DSO for SQLOLEDB
>returned 0x8007007f].