Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jslist
Starting Member
1 Post |
 Posted - 2014-09-11 : 11:13:04
|
| Can you reverse engineer SQL tables and display the data type using Visio 2010? This is what I'm doing now: Click on File - Software & Database - Database Model Diagram - Create Click on Database - Reverse Engineer - Generic OLE DB Provider Select SQL Server Native Client 10.0 - Next - enter servername, windws NT, database name- OK Get msg The default driver was changed to Generic OLEDB provider. Uncheck Stored procedures - Next - Choose my tables - Next - Next - Finish ** When I click on reverse engineering and have to select a driver - with Microsoft SQL Server - I can create a new datasource but it never shows up in the list under Microsoft SQL Server. It shows up under ODBC. Also - the my computer is a 64 bit machine and the software is 32 bit.JS |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-09-11 : 11:35:52
|
| ODBC is fine. Just specify the appropriate connection string. |
 |
|
|
|
|
|
Visio 2010 Reverse Engineering Display Data Types