You can provide the result here and I'm glad to help you check it. If you're not sure what version of Visio you're using, click File > Account > About Visio. This template is available in the Visio app for those with Visio Plan 2 or a Visio 2019 license. Press Enter.Īs the article said: The Database Model Diagram template lets you create a database model from an existing database. For Office 2016, Office 365 and Office 2019, the name of folder is Office16. 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. Note: The opss.vbs script is located in the C:\Program Files\Microsoft Office\Office16 folder. Type cscript "%ProgramFiles%\Microsoft Office\Office16\"ospp.vbs /dstatus or cscript "%ProgramFiles(x86)%\Microsoft Office\Office16\"ospp.vbs /dstatus.Open Command Prompt as an Administrator.I suggest you try to check if you have other version of Visio license in PC: Finicky as they are, once you get them to work, take notes on what you did for the next time so you'll know what to do.ĭid you install other version of Visio before? Indeed this takes me back to the old days about 20 years ago of messing around with ODBC drivers. It really isn't intuitive that you need to use a different ODBC Driver (the Generic one) in the Reverse Engineering operation. Once the source connection is tested, it's fair to say that it works. Not sure why this is not a smoother operation, but then anything involving ODBC never has been! It might depend on what version of SQL you are running as to which ODBC driver you use to set up the data source. I used the Generic ODBC Driver in the connection action in Reverse Engineer and despite it flagging a warning, it worked. I had already set up the data source using a SQL Server ODBC Driver (native 11) - after a lot of rigamarole. I decided on a whim to try to connect using the ODBC Generic Driver instead of the one for SQL Server. OK, so I couldn't wait on a solution to fall out of the sky, haha, so I kept looking at what I found and finally worked it out after re-reading the documentation page here: After a day and a half of this, I thought I would share this solution or workaround, rather. I hope that this helps someone who is out here stumbling around trying to figure this out.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |