Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Data source name not found and no default driver specified

 
   Database Help (Home) -> Connect RSS
Next:  mysql linked server  
Author Message
Stephen Costanzo

External


Since: Feb 18, 2005
Posts: 1



(Msg. 1) Posted: Fri Feb 18, 2005 5:14 pm
Post subject: Data source name not found and no default driver specified
Archived from groups: microsoft>public>sqlserver>connect (more info?)

Data source name not found and no default driver specified

This is the error I get when attempting to install my copy of SQL Server
2000 developer edition.

I had SQL Server installed on my workstation, functioning correctly. My
computer crashed and it appears that there is some sort of registry
corruption because I could not open up my local instance in Enterprise
Manager.

Checking ODBCAD32, it did not appear that I had any drivers installed for
any source (MS Access, standard ODBC, SQL Server, etc.)

I attempted to execute the MDAC on the Microsoft web site with no results.
The component Checker determined that I had MDAC 2.8 SP1 on Windows XP SP2.

I uninstalled and reinstalled SQL Server and on the final step, the above
message appeared.

How do I get the default SQL Server driver reinstalled to my workstation. My
network techs indicate that I have to reinstall my OS to get the drivers
back. This seems a little extreme.

Thank you in advance.

 >> Stay informed about: Data source name not found and no default driver specified 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Cannot generate SSPI context - Hi All, I am experiencing problems with a remote user (w2k pro,sql 7) attempting to connect and replicate with a Sql Server 7 on NT server. They are receiving 'Cannot generate SSPI context' messages when trying to use a vb app over a vpn. This problem..

connection string does not work for a different server - Hi all, I currently have an ASP .Net project running locally, and accessing a local SQL server 2000 database. The project runs fine since it is able to open the connection to the database, and perform operations on it locally using a connection dtata..

IIS 6 and Windows Authentication to SQL Server 2000 - I am running a Windows Server 2003 machine as my web server. I would like to use Windows authentication for connections to my SQL Server 2000 instance on a Windows 2000 server. I've read where mirroring the ASPNET account and password on the web server...

SSL Security error -ConnectionOpen(SECDoClientHandshake) - Please help. On my default instance of SQL Server 2000, which could be accessed OK with both Windows and SQL server authentication, I now get the error in the subject line above. The message in the error window - in SQL server enterprise manager- suggest...

Connecting client to SQL Server via Cisco VPN - We are having one client PC running Win XP. SQL Server has been set to Windows Authentication, TCP/IP 1433, Windows 2003 (!). Via Cisco VPN we are making a connection. IAS has been configurated, so the local user profile doesn't matter. The server..
   Database Help (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]