Display Database Query in Visio

[geoff_durham]

I have searched a bit on this and haven't found a sufficient answer
so
I hope someone has figured this one out.

I have a network diagram with a number of system (server) components
each with complete custom properties (Server name, Type, OS...).


I also have an SQL database with interface details for all system
components (Source IP, Dest IP, Direction, Protocol, Ports...).


What I want is a way of performing a SQL query based on a value of
one
of the custom properties for an item (i.e. Server Name). I then want
to display the query (recordsets) in a tabular (or similar) format
over the visio diagram.


Is this possible - If so - How?


Regards,


Geoff.

 

[David Parker]

VIsio 2007 Professional includes "Link Data to Shapes".
This can can be programmitcally run using a stored procedure, thus you could
write code to to this and to pass an argument from a Shape Data row (nee
Custom Property)