Microsoft Office Tutorials and References
In Depth Information
First, get to the instance of the diagram services of the active document, which is the page. set the Visio services
Version and the visibility of the external data sources window to true:
diagramServices = ActiveDocument.DiagramServicesEnabled
ActiveDocument.DiagramServicesEnabled = visServiceVersion140
Application.ActiveWindow.Windows.ItemFromID(visWinIDExternalData).Visible = True
the following steps are optional here. they are to populate the external data source with values to facilitate
a designer’s choice to bind the row data to the shapes in design mode. Connect to the sQL store, retrieve the
recordset, and add the recordset to the active document data record set collection:
commandText = "SELECT ServerName, ServerIP, ServerStatus FROM tblServerStatus"
connectionString = "Provider=SQLOLEDB;Data Source=<YourDataSourceName>;
Initial Catalog=VisioServices;Integrated Security=SSPI; "
Set vsoDataRecordset = ActiveDocument.DataRecordsets.Add(
connectionString, commandText, 0, "Server
set the custom data-provider assembly details to the recordset command string. set and enable the diagram
services to the active document:
ActiveDocument.DiagramServicesEnabled = diagramServices
So far, you’ve seen a lot of information on Visio and Visio Services. Now it’s time to get to know some more
references and information. You have seen the administration of Visio Services using the UI in Central Administration.
Now, you will learn more options for administering Visio Services using both CA and Windows PowerShell.
Administration of Visio Services
Administering Visio Services can be done using either Central Administration (CA) or PowerShell (PS). To access
PowerShell, simply click on Start ➤ All programs ➤ Microsoft SharePoint 2013 Products ➤ SharePoint 2013
Before administering Visio Services, be sure to follow these two steps:
Set up an application pool and a managed account. Most of the settings and configurations
require both application pool accounts and managed accounts, and you really don’t want
to go back to create them in the middle of an operation. Plan ahead, and make a list of all
these accounts before you begin setting up your farm/application.
Make sure you are member of the Administrators group. Again, you definitely need to be
the local administrator for many obvious reasons. You don’t want to start your application
with a low-privilege account and have your access denied for an administration job.
Search JabSto ::