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.

 

[Al Edlund]

I guess the first question is, what are your sql skills since it is
obviously a two part question (get data from shape, perform query). The get
data from shape code is in the visio sdk (read a custom property). I usually
recommend that those new to coding sql in vb down load the 101 examples
package from ms downloads. It's a great teaching tool.
what version of visio are you using?
al

 

[geoff_durham]

Visio 2007 Professional.

 

[geoff_durham]

I have SQL developers available to provide the scripts but are on my
own in the Visio space and although reasonable proficient with basic
VBA scripts I would not consider myself a developer so if you could
provide any details to get me started it would be much appreciated.

Regards,

Geoff.

 

[Al Edlund]

Geoff,
The good news is that v2007 professional has some very strong data
manipulation tools under the covers. I've got a v2007 sample drawing that
demonstrates reading an o2007 excel workbook and then drawing and populating
network racks (nodes and cabling) that I'd be happy to share with you. We
should probably take this off-line.
Al
__edlund60014__at__yahoo__dot__com