Solved

System DSN error

Posted on 2013-01-03
3
1,328 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

863 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now