Link to home
Start Free TrialLog in
Avatar of David Bach
David BachFlag for United States of America

asked on

Unable To Connect To SQL Server 2017 Using Viso 365

Greetings:

I'm using Microsoft SQL Server 2017 remotely.

I'm using Microsoft Visio for Office 365 MSO (16.0.11328.20220) 32 bit.

I downloaded and installed the ODBC Driver 17 for SQL server.

Within Visio:
  1. I created a new Database Model Diagram from the Software and Database template
  2. I clicked on Database -> Reverse Engineer.
  3. Under Setup, ODBC Driver 17 for SQL Server is the only driver selected
  4. I double click on my data source.
  5. I enter the password for the data source.
  6. The following error comes up - "The currently selected Visio driver is not compatible with the data source"

Any assistance one might give is most appreciated.

Much thanks,
David Bach
Avatar of Davis McCarn
Davis McCarn
Flag of United States of America image

Avatar of David Bach

ASKER

Greetings Davis:

I previously went to the page you listed above. The file name I downloaded was 'msoledbsql_18.2.1.0_x64.msi' as well as 'msoledbsql_18.2.1.0_x86.msi'. I installed 'msoledbsql_18.2.1.0_x64.msi'.

I'm using Windows 10 Pro (64-bit) and Visio 365 (32-bit).

I subsequently went to the control panel -> Administrative Tools -> ODBC Data Sources (32-bit)
User generated imageFrom this list I selected ODBC Driver 17 for SQL Server. I subsequently enter the SQL server address, user id, password and point the default database to mine. The testing of the connection succeeds, however, when I go to Visio to reverse engineer the database, I receive message above.

Much thanks, David
Did you try the Native Client 11.0 or the ODBC Driver 13?
Greetings Davis:

Just now tried with Native Client 11.0 and subsequently with ODBC Driver 13 ... neither worked for me.


Much thanks, Davis
And then what version of Windows is running on the server and what version of SQL server?
Greetings Davis:

Windows 10 Pro (64-bit)

SQL Server 2017 (64-bit)


Much thanks, Davis
So the remote machine running SQL server 2017 is a Windows 10 Pro host?
Greetings Davis:

My apologies for not understanding your question at first.

The remote host is running Windows 2012 Server (64-bit). The SQL server on the remote host is running the Standard edition of SQL Server.

I am running Windows 10 Pro.


Much thanks, Davis ...
Is your pc joined to the domain or are you running through RDP?
Greetings Davis:

I am not using RDP. I provide the remote SQL server name, user id, password and database name either from within Visio or by opening the ODBC control panel app.

I hope this helps.


Much thanks, Davis ...
Greetings Davis:

By selecting the generic ODBC from the list of Visio drivers, the connection to the remote SQL database was established. I was able to successfully reverse engineer the database. I did receive warnings from Visio when the generic ODBC is used as follows:

User generated image
In using the generic ODBC driver, I may be missing out on options the Visio SQL database driver may provide.

I'm still looking for a better answer than the Visio generic ODBC driver.


Much thanks, Davis
Greetings Davis:

I took your suggestions to heart.

So far, my problem has become more complicated. I am able to connect to the SQL Server database using the generic ODBC driver within Visio Pro, however, when I look at table columns the nvarchar columns are defined as image.

I called and opened an incident report with Microsoft Office Support. This was 2 days ago. I've been prodding Microsoft why I haven't received a response to no avail.

I am prepared to escalate this. I will post back when I've found an answer.

Thank you for all your patience and time you've put into helping me, Herb. It is greatly appreciated.

David Bach
Another thread with your initial error message was solved using the information and driver listed in this article:
https://docs.microsoft.com/en-us/sql/connect/oledb/oledb-driver-for-sql-server?view=sql-server-2017
ASKER CERTIFIED SOLUTION
Avatar of David Bach
David Bach
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
It is October 2021 and the issue still exists. I am not able to reverse engineer SQL Server 2017 using the Visio Plan 2 Subscription using Microsoft SQL Server Visio Driver. I can use ODBC Generic Driver, but, not able to reverse engineer database views. Also, datatypes are not accurate for tables. Anyone found any solution?