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.
| Author |
Topic |
|
TorreyKite
Starting Member
40 Posts |
 Posted - 2006-09-27 : 17:12:03
|
Hi all,I'm trying to register a SQL 7.0 DB server via enterprise manager on my desktop machine(XP sp2). When I go through the wizard it ends up saying "Data source name not found and no driver specified". I think my problem is that my desktop does not have the proper drivers installed. When I go to "administrative tools> ODBC datasource administrator" I only have MS text driver, when other machines have tons of drivers installed.Things i've tried: un-installing/re-installing SQL Server 7 .Installing MDAC 2.7 nothing seems to work. Does it seem like the driver thing is my issue? is it something completely different. Has any one heard of ODBC driver problems like this? I'm quite sure the the server is set up properly because a distributed application is able to access it with no problem.Any help would be much apreciated. Thanks!!!!TK  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-27 : 17:32:21
|
| Yes MDAC is the problem. In order for you to connect, you will need the SQL Server driver. Since it is not appearing in the ODBC list, then it isn't installed.Tara Kizer |
 |
|
|
TorreyKite
Starting Member
40 Posts |
Posted - 2006-09-27 : 21:29:21
|
| Is MDAC 2.7 or 2.8 the proper version or should I find the SQL driver somewhere else(i thought that it would be installed with the SQL server re-install)?I'm confused because I thought that MDAC included the driver, but after I installed it there are still no new drivers in my "administrative tools> ODBC datasource administrator". Is it just that it should work but my PC is messed up? Do I need to uninstall MDAC first before re-installing it? Thanks,Torrey |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-28 : 01:32:36
|
| Yes MDAC has the driver in it. If MDAC is being installed successfully, then you've got some issue on the PC. I'd suggest reinstalling service pack 2 for XP to see if that fixes any corrupted DLLs. If that doesn't work, you might need to consider reimaging the PC.Tara Kizer |
|
|
|
|
|
|
Server Registration