Solved

ERWIN rev Eng from SQL Server 2005

Posted on 2012-04-10
6
1,051 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

828 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