Lost ODBC driver for SQL Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Lost ODBC driver for SQL Server

Author

Topic

ymjdvd
Starting Member

4 Posts

Posted - 2008-01-21 : 12:58:28

Hi,
After I install and uninstall then reinstall SQL Server 2000 person editon several times on Dell XP machine
I can not reinstall SQL Server person edition, error message prompt me to check log file in C:\WINDOWS\sqlstp.log.
Here is errors
driver={sql server};server=xxxxxx;UID=sa;PWD=;database=master
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
SQL Server configuration failed.
I checked Data Source (ODBC), no driver for "SQL Server" listed there.
What I do can bring back ODBC driver for SQL Server?
Thanks
yj

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-21 : 16:07:46

Install mdac first.

ymjdvd
Starting Member

4 Posts

Posted - 2008-01-21 : 16:49:27

rmaio,
Thanks for replying
How to install correct mdac? I did go to MDAC download webpage http://msdn2.microsoft.com/en-us/data/aa937730.aspx and download MDAC 2.8 SP1 -- MDAC_TYP.EXE
Then I clicked it to install, but message came out means it not for my windows version.

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2008-01-21 : 17:14:14

Try this download.
http://www.microsoft.com/downloads/details.aspx?FamilyId=8F0A8DF6-4A21-4B43-BF53-14332EF092C9&displaylang=en

If you dont have Service Pack 2 for Windows XP installed, I would suggest doing so. Hopefully the report it generates pinpoint your problem.

ymjdvd
Starting Member

4 Posts

Posted - 2008-01-21 : 18:07:22

Tripodal,
My machine is dell, do install xp sp2 on it.
Check version with ComponentChecker 2.0 -- cc_pck.exe, result is
The following product releases were matched:
MDAC 2.8 SP1 On windows XP SP2
I ran check special for MDAC 2.8 SP1
a bunch of items under mismatch field are none while a few are a expected version, no special wrong.

After rerun MDAC 2.8 SP1, one called Fatal Setup Error still came out “This setup does not support installing on this operating system”

I reinstalled SQL Server 2000 same error
Any Idea?
Thanks for all

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-21 : 18:19:31

Tried with mdac 2.7?

ymjdvd
Starting Member

4 Posts

Posted - 2008-01-23 : 11:36:26

I re-installed MDAC 2.8 on XP SP2 successfully. Then ODBC driver SQL Server came back.
Thanks for macropool website display how to Repair MDAC 2.8 Under Windows XP with SP2 Installed -- on http://www.macropool.de/en/download/mdac_xp_sp2.html
And thanks all your guys

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources