Solved

System DSN error

Posted on 2013-01-03
3
1,338 Views
Last Modified: 2013-01-04
SQL server 2008 was installed.
The sql client was installed and then the application.


After that ,while trying to  configure the Sysem DSN, an error occurs.

The setup routines for the SQL native client ODBC driver could not be found. Please reinstall the driver.
On checking the drivers, the sql native client 10.0 driver seems to be present.


Can anyone tell what to do . How to solve this.

Regards,
0
Comment
Question by:AmmarDJ
3 Comments
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 38739279
0
 
LVL 42

Accepted Solution

by:
EugeneZ earned 500 total points
ID: 38739540
please clarify what OS (version- edition sp- probably you have /64bit(in this case use 32-bit odbc admin -see above post))

is this pack with the client installed on  box or some another pc\server?

if some another server -- you may need to include in your distr pack MDAC (all or just part)
or sql connectivity dlls

MDAC
http://www.microsoft.com/en-us/download/details.aspx?id=5793

How to check for MDAC version
http://support.microsoft.com/kb/301202
0
 

Author Comment

by:AmmarDJ
ID: 38743858
Eugene

The application and sql client are installed on the same box.
database server is another box.
 MDAC is already there,

nt sure what could be the problem.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question