Re: Remote Client for SQL Server 2000 - create linked servers

arno (aschobspam@xxxxxxxxx) writes:
I run queries using ADO from Excel vs. a SQL-Server from my PC (XP
SP1, and updated to SP2, MDAC 2.8 installed). Everything works fine. I
install SQL-Server 2000 (only client stuff) on the PC, during setup I
get an error that the installation of MDAC failed and from that moment
ADO-queries fail with the above mentioned error and I get the same
message when trying to connect to the SQL Server with Enterprise
manager from the PC. So, the installation of SQL-Server destroys
something on the PC. Reinstalling MDAC 2.8 does not help.

The SQL 2000 setup tries to install MDAC 2.6. I don't know how smart it
is to understand versions that did not exist at the time of its release.

The MDAC is part of the OS. Before you flatten the disk, I would attempt
a repair of the OS.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

.

Relevant Pages

  • Re: Any help here???
    ... Well, for starters, I believe MDAC is unnecessary for .NET applications - as ... ADO.NET has its own SQL Server provider for data access. ... > trust me - all that's been done here was to install SP2 or upgrade of XP ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Problems upgrading SQL MSDE for Sharepoint
    ... I used Registry Editor to delete PendingFileRenameOperations in the ... I restarted the Server and tried to install SQL ... Press Retry to continue installation or Cancel to exit setup. ...
    (microsoft.public.windows.server.sbs)
  • Re: SQL Server 2005 Cluster Setup Quiz
    ... Setup is supposed to install client tools on all nodes. ... Microsoft SQL Server MVP ... the first instance on the cluster. ...
    (microsoft.public.sqlserver.clustering)
  • Re: SCCM Fatal Error during install
    ... Configuration Manager Setup Cannot Continue Because of the following ... Setup cannot create the required database tables. ... Contact your SQL ... Everything is a fresh install i loaded 2k3 R2 then SQL 2005 then the ...
    (microsoft.public.sms.admin)
  • Re: failed because MDAC is not present
    ... What version of SQL Express are you trying to install and which OS version ... SQL Express so this error doesn't make much sense. ... >I have tried to install SQL 2005 Express but It seems that MDAC is not ... > Server 2005 in Microsoft SQL Server Books Online. ...
    (microsoft.public.sqlserver.msde)
Quantcast