Solved

ERWIN rev Eng from SQL Server 2005

Posted on 2012-04-10
6
1,035 Views
Last Modified: 2012-08-13
Hi,

I am trying to reverse engineer a SQL Server 2005 DB with Erwin Reverse Engineering tool and I am getting the following error:

Unable to locate client connectivity software. Check with your database administrator to install the appropriate client software.

Anyone know why?

Thanks in advance and regards.
0
Comment
Question by:robespierre_2010
  • 4
  • 2
6 Comments
 
LVL 17

Expert Comment

by:Barry Cunney
ID: 37827450
Find c:\windows\systems32\ntwdblib.DLL,

Copy that to  "c:\program files\CA\AllFusion ERwin Data Modeler" folder.
0
 

Author Comment

by:robespierre_2010
ID: 37827679
Cannot find c:\windows\systems32\ntwdblib.DLL
0
 
LVL 17

Expert Comment

by:Barry Cunney
ID: 37827868
That may the problem - ntwdblib.DLL
 is a SQL Server Database module - do a global search to see if you can locate this D;; anywhere on your machine
0
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.

 

Author Comment

by:robespierre_2010
ID: 37829020
It is not in my machine.

Can it be downloaded from an official Microsoft page (msdn,...)?
0
 
LVL 17

Accepted Solution

by:
Barry Cunney earned 500 total points
ID: 37838504
I am not 100% sure of a definite official download location - but I have seen the following location mentioned
http://www.dlldll.com/ntwdblib.dll_download.html

You could download it and see if this resolves the problem and then decide on finding an official source - I will have another search and see if I can get something more for you on the 'official' aspect
0
 
LVL 17

Expert Comment

by:Barry Cunney
ID: 37838527
Actually that link was suggested on http://social.msdn.microsoft.com/forums
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

911 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