When I use "Microsoft SQL Server" as the installed Visio driver and set up a DSN, it says "The currently selected visio driver is not compatible with the data source". If I choose "ODBC Generic Driver" I am able to reverse engineer, but, with limited functionality - no views, column datatypes are not reflected correctly, etc. I am using Visio Plan 2 (upgraded from Visio 2016) and have installed the data modeling add-on.
I already tried downloading the Microsoft OLE DB Driver for SQL server - but I already had it.
On a side note, with my same setup, if I open a "Brainstorming diagram" template in Visio and go to Data -> Custom Import -> Microsoft SQL Server Database; I am able to import both tables and views just fine. In fact, it does not even ask me to set up a DSN to import data.
Additionally, I have another work laptop (for a different department within the same company). There, I am using 64 bit version of Visio Plan 2 (upgraded from Visio 2016 as well) to connect to Microsoft SQL Server 2016 SP2-CU17 (as opposed to 2017) and it works fine there. So, is it SQL Server 2016 (works) vs 2017 (doesn't work); or 64 bit office (works) vs 32 bit office (doesn't work); or something to do with database, database server or network configuration.
On the Visio data modeling add-on help page, it says that "Visio for Enterprise Architects" has even more data modeling features - including forward engineering. I was trying to search for it online with no luck. Would really appreciate if you can send me a link about that version. Is it still a supported product? How do I download/install it?
My goal is to be able to at least reverse engineer table, views, procedures, etc from SQL Server 2017 using Visio.