You receive an "Unable to connect to the data" error message when you try to update data in a Visio 2010 diagram, and you use a connection in an ODC file to a SQL Server that requires you to provide credentials for SQL Server Authentication

Article ID: 983001 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario:
  • You have an Office Data Connectivity (ODC) file that provides a connection to a data source on a Microsoft SQL Server, and this server requires you to provide credentials for SQL Server Authentication.
  • You create a diagram in Microsoft Visio 2010.
  • You import data into the diagram by using the ODC file. To do this, when you are prompted for the URL or the UNC, you type the path of the ODC file, and then you finish the Import wizard.
  • When the import of the data is finished, you click the Data tab, and then you click Refresh All.

In this scenario, the data is not updated in the diagram. Additionally, you receive the following error message:
Unable to connect to the data.

WORKAROUND

To work around this behavior, follow these steps:
  1. Save the Visio diagram.
  2. Exit Visio.
  3. Start Visio, and open the diagram that you saved in step 1.
  4. Click Refresh on the Data tab.
  5. When you are prompted, type your SQL Server credentials for the data source.

MORE INFORMATION

For more information about connections that are stored in Office Data Connectivity (ODC) files, visit the following Microsoft TechNet website:
Plan Visio Services security (SharePoint Server 2010)
For more information about SQL Server Authentication, visit the following Microsoft Developer Network (MSDN) website:
Choosing an Authentication Mode

Properties

Article ID: 983001 - Last Review: August 26, 2011 - Revision: 2.2
APPLIES TO
  • Microsoft Visio Premium 2010
  • Microsoft Visio Professional 2010
  • Microsoft Visio Standard 2010
Keywords: 
kbsurveynew kbprb kbtshoot kbexpertiseinter kberrmsg KB983001

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com