Unable To Use Visio Data Model add-on to Connect To SQL Server 2017

Kaushik P 1 Reputation point
2021-09-20T18:46:24.153+00:00

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 reveerse engineer, but, with limited functionality - no views, column datatypes are not reflected correctly, etc. I am using Visio Plan 2 and have installed the data modeling add-on.

Visio Management
Visio Management
Visio: A family of Microsoft products used to create diagrams and vector graphics.Management: The act or process of organizing, handling, directing or controlling something.
248 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Viki Ji_MSFT 4,421 Reputation points
    2021-09-21T07:49:07.51+00:00

    Hi @Kaushik P ,
    Welcome to Q&A forum!

    Please try download the Microsoft OLE DB Driver for SQL server and see if it helps, for more information you can refer to MicrosoftOLE DB Driver for SQL Server.

    Besides, have you installed other versions of Visio before? Please run the follwoing command and share the result with us.

    1. Open Command Prompt as an administrator.
    2. Run cscript "%ProgramFiles%\Microsoft Office\Office16\"ospp.vbs /dstatus or cscript "%ProgramFiles(x86)%\Microsoft Office\Office16\"ospp.vbs /dstatus

    *Please note: The opss.vbs script is located in the C:\Program Files\Microsoft Office\Office16 folder. If you installed the 32-bit version of Office on a 64-bit operating system, go to the C:\Program Files (x86)\Microsoft Office\Office16 folder.*

    Any updates, please let me know.

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

  2. Viki Ji_MSFT 4,421 Reputation points
    2021-09-22T07:12:34.267+00:00

    Hi @Kaushik P ,
    Due to the limited number of comments, I will reply in the answer.

    Thanks for your reply and sharing.
    Running cscript is to help us uninstall Visio licenses other than Visio Plan 2.

    According to your description, are you using 32-bit Visio?
    Currently, I have not retrieved any official documents about 32-bit Visio unable to connect to SQL server.
    Considering that the 64-bit Visio Plan 2 can work normally with SQL Server 2016, and the error message indicates "The currently selected visio driver is not compatible with the data source", I suggest you try to install 64-bit Office to check.
    References:
    Choose between the 64-bit or 32-bit version of Office
    Compatibility between the 32-bit and 64-bit versions of Office

    Regarding "Visio for Enterprise Architects", the official documents indicate:
    "Visio for Enterprise Architects is included in MSDN Premium Subscription, which is available with Visual Studio Professional and Visual Studio Team System role-based editions."
    I suggest you refer to the following page to contact Account & Subscriptions Support for more help.
    Visual Studio Support

    Besides, since we are more focused on general issues about Office client, I also suggest you post a new question with the tag sql-server-general for more professional support on SQL server.

    Hope your issue could be resolved as soon as possible. Thanks for your understanding!

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.