ODBC SQL drivers

[Jim Smith]

I edited all of the occurances of 'SQL' out of my XP
registry. I expected a fresh installation of SQL Server
2000, to supply any necessary files. The final steps of
installation produced the following error(s):


Starting Service ...

SQL_Latin1_General_CP1_CI_AS

-m -Q -T4022 -T3659

Connecting to Server ...

driver={sql
server};server=SYSADMIN;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified

driver={sql
server};server=SYSADMIN;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified

driver={sql
server};server=SYSADMIN;UID=sa;PWD=;database=master

[Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified

SQL Server configuration failed.

Now there is no driver to install with Data Sources
(ODBC) odbcad32.exe. Anybody know the best way to fix
this?

 

[Carey Frisch [MVP]]

You can only run either SQL Server 2000 Personal or Developer Edition on
Windows XP Pro. SQL Server 2000 Standard or Enterprise will only run
on a Server version of Windows.

Ref: http://www.microsoft.com/sql/evaluation/overview/default.asp

--
Carey Frisch
Microsoft MVP
Windows XP - Shell/User

Be Smart! Protect your PC!
http://www.microsoft.com/security/protect/

----------------------------------------------------------------------------------------


| I edited all of the occurances of 'SQL' out of my XP
| registry. I expected a fresh installation of SQL Server
| 2000, to supply any necessary files. The final steps of
| installation produced the following error(s):
|
|
| Starting Service ...
|
| SQL_Latin1_General_CP1_CI_AS
|
| -m -Q -T4022 -T3659
|
| Connecting to Server ...
|
| driver={sql
| server};server=SYSADMIN;UID=sa;PWD=;database=master
|
| [Microsoft][ODBC Driver Manager] Data source name not
| found and no default driver specified
|
| driver={sql
| server};server=SYSADMIN;UID=sa;PWD=;database=master
|
| [Microsoft][ODBC Driver Manager] Data source name not
| found and no default driver specified
|
| driver={sql
| server};server=SYSADMIN;UID=sa;PWD=;database=master
|
| [Microsoft][ODBC Driver Manager] Data source name not
| found and no default driver specified
|
| SQL Server configuration failed.
|
| Now there is no driver to install with Data Sources
| (ODBC) odbcad32.exe. Anybody know the best way to fix
| this?

 

[Guest]

Carey/Jim

I experienced this same error while installing SQL Server 2000 Developer Edition (SP3) on Windows XP Professional (SP1). Upgrading to MDAC 2.8 doesn't resolve this since all the drivers are already there. The problem is they're not listed in the registry. Best advice I've seen so far is to export the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC tree from another PC then import it into one's registry using REGEDIT. If the SQL Server ODBC driver is the main priority (and the proper version exists on the machine), then one can also run odbcconf /F sqlclnt.rsp to force it to appear in the ODBC Control Panel

Stev