arno (aschobspam (AT) gmail (DOT) com) writes:
And that error message is?

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

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/prodinf...ons/books.mspx

Hello,

we reverted to a previous snapshot and updated to XP sp2 (sp3 won't
work here properly) and ODBC works again. because of holidays I
probably won't be able to install the enterprise manager etc. to work
on the sql server

I am just worried if SQL-Server 2000 Setup will crash everything
again...

arno

PS: For other reasons I have to go back to another snapshot. So I
could test the installation of SQL-Server again, and odbc crashed
again. So, I cannot install SQL-Server without problems. The error
message is (translated from german):

runtime error '-2147467259 (80004005)': [Microsoft][ODBC Driver
Manager] The name of the datasource could not be found, there was no
standard driver mentioned.

So, I will have to try SQL Server express 2005 to see if I can set
linked servers with GUI.

arno (aschobspam (AT) gmail (DOT) com) writes:
The error message indicates an incorrect connection string.

But I realise that I am at complete loss of trying to understand
what you are doing. Do you get this error when you try to connect
to SQL Server from an application? Or do you get it when you try to
access a linked server?

Maybe you should start over and tell from the beginning what you are
doing and what is failing.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

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/prodinf...ons/books.mspx

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.

arno

arno (aschobspam (AT) gmail (DOT) com) writes:
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 (AT) sommarskog (DOT) se

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/prodinf...ons/books.mspx

Hello,

I solved the problem.

I went through MS-KB 232060 which told to check dll usage with
ListDLLs.exe, no thread should use some dlls during mdac installation,
however, winlogon and explorer always use as far as I remember
odbc32.dll. (somebody should tell them...) BTW mdac 2.6 is aware of
newer versions and does not replace newer files.

I used MS cc_x86.msi (MS mdac component checker) and did not get a
"simple" info from it as it found many, many different versions of
MDAC-files on the PC. And replacing dlls is not possible because of
windows xp security features.

I found another tool calles mdac-repair.exe, links for both downloads:
http://www.macropool.com/en/download/repair_mdac.html

This tool found missing entries in the registry of quite a number of
files and added everthing to the registry.

Then the setup of SQL Server 2000 Client tools, esp. MDAC procedure
worked. I'd guess that the installation of mdac 2.6 failed because
there where many errors in the registry and it could not determine
which mdac version was installed (2.8 was installed, one normal
version, one from Windows 2003 server an some older versions).

So, I can administer my linked servers now I could use Acqua Data
Studio 4.5 additionally and do not have to install SQL Server Express
for that.

Thanx for your help

arno

PS:

On Win XP SP1 (!) you can install MDAC 2.80. For XP SP2 you can use
2.81 and later service packs.

arno (aschobspam (AT) gmail (DOT) com) writes:
Glad to hear that it finally worked out. There were a bunch of
things you mentioned, I have little clue of. I'm glad that I have
not encountered those problems myself!


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

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/prodinf...ons/books.mspx