Share via

Unable to reverse engineer SQL Server 2019 databases in Visio Plan 2

Druva Raj Nadimpalli 1 Reputation point
2022-07-04T09:55:25.913+00:00

I have a SQL Server 2019 installed on my local and I am trying to reverse engineer one of the databases to work with the database model in Visio Plan 2. However, even after having the ODBC and OLE DB drivers on the machine, I am not able to use them appropriately. With ODBC driver, the field data types are wrongly imported to either image or text. And, the OLE DB driver is not visible to be displayed in the settings.

Microsoft 365 and Office Visio For business Windows
SQL Server Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2022-07-05T04:14:30.47+00:00

    Hi @DhruvRaj,
    As far as I know, a vendor-supplied 32-bit ODBC driver must be from an ODBC Data Access Pack greater than version 2.0 and ODBC Level 1-compliant or greater. A vendor-supplied OLE DB provider must be compliant with the OLE DB version 1.0 or later specification.

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response 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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.