Visio 2010 DataSources not showing in reverse engineer wizard

Question

Hi I am trying to do a database diagram in visio 2010 to existing database. I am using the reverse engineer wizard. When I push new button on datasource field. I follow the steps to add new datasource. It looks like everything worked no errors, tested connection and it passes. But after finishing the process it should add it to the datasource box so I can select and proceed on. But it does not show up. DataSource is still blank.

Specifics: It is a 2008 R2 Express db trying to connect to using visio 2010. OS is Window 7 64bit.

Can anyone help.

Answer 1

I had a similiar problem when creating the datasource as "file data source". Once I created it as user or system datasource it showed up. (Using Visio 2010 on WinXp connecting to SQL-server 2008)

Answer 2

It's really odd but it seems that using Generic OLE DB driver works for this issue.