All geek questions in one place

Visio 2010 data sources not displayed by the reverse engineering wizard

Hi, I am trying to make a database diagram in visio 2010 into an existing database. I use the reverse engineer wizard. When I click a new button on the data source field. I follow the instructions to add a new data source. It seems that everything worked without errors, the connection is checked and it passes. But after the process is complete, he must add it to the data source field so that I can select and continue. But he does not appear. DataSource is still empty.

Features: This is DB R2 2008 Express, trying to connect to using visio 2010. OS is Window 7 64bit.

Can someone help.

+6
source share
3 answers

I had a similar problem when creating a data source as a “file data source”. As soon as I created it as a user or system data source, it appeared. (Using Visio 2010 when connecting WinXp to SQL Server 2008)

+6
source

I had the same problem, here is how I solved it:

  • Next to the installed Visio MS SQL Server drivers, SQL Server Native 10.0 is marked at the bottom of the list

  • In the "Data Sources" section, click "New" (I used the "Custom Data Source"), then on the "Create a New Data Source" screen I used SQL Server Native 10.0

Upon completion of the wizard, a data source has appeared.

The main thing is that SQL Server 10.0 is installed next to the Microsoft SQL Server option (not checked by default)

+2
source

This is really strange, but it seems like using this problem to use the Generic OLE DB driver.

+2
source

Source: https://habr.com/ru/post/885882/

More articles:


All Articles