N/APosted on - 08/21/2012
The installation of Visio Add-in for Operations Manager 2007 was a very simple task.
However,I did encounter strange behavior while trying to view Visio integrated web diagrams.
I received the below mentioned error post Visio installation but prior to running the file named OpsMgrDataModule.ps1 file
Visio services was unable to refresh external data connections in this Web Drawings because one or more data provider required by these connections is not trusted by the Visio Graphics Service.To resolve this issue,ask your system administrator to add the data providers you need to refresh this Web Drawing to the Trusted Data Providers list of Visio Graphics Service.
Visio services was unable to refresh external data connections
Where there is a problem, there is a solution. No problem, no solution. And I like the problem so that I can use my brain. Ok let's talk about the problem now. I researched on your problem and found a simple matter related to your problem.
I traced this problem back to a column in your SQL table that contains a data type of DATETIME2. Just remove it and look your problem goes away. I think your problem has been solved.