Database Connection

Hi,

I am a fairly novice Visio user. I am trying to link shapes to SQLserver table entries using the "Link to Database..." option. Link is succesful. However, I seem to be able to affect only Custom properties.

Example:

1) I have a network connector labelled "10". Custom properties will include a description for the connection, Protocol and destination ports. I can get all this from the database, as long as I keep a custom property called "Connid". I would like to query using as a key the label, not the custom property (in other words I want to avoid to define in multiple places the same data).

2) The database table has many connections for connid "10". Some are TCP, others are ICMP others are UDP. These I keep in seperate rows in the database with column named "Protocol". Ideally I would like Visio to retrieve all rows corresponding to the same connection, -or- append the information with commas in the same property. Of course I can always put my ports as a string prefixed by the protocol, i.e. "TCP: 39,80, UDP: 27,489". But in this case I loose valuable information.

Can this be done with the Link to database wizard, or do I have to develop custom VBA scripts?

Thanks,

You will have to probably write VBA. The database wizard is pretty
simplistic in how it sends and retrieves data.
Al
"Nikos" wrote in message
...
Hi,

I am a fairly novice Visio user. I am trying to link shapes to SQLserver
table entries using the "Link to Database..." option. Link is succesful.
However, I seem to be able to affect only Custom properties.

Example:

1) I have a network connector labelled "10". Custom properties will
include a description for the connection, Protocol and destination ports. I
can get all this from the database, as long as I keep a custom property
called "Connid". I would like to query using as a key the label, not the
custom property (in other words I want to avoid to define in multiple places
the same data).

2) The database table has many connections for connid "10". Some are TCP,
others are ICMP others are UDP. These I keep in seperate rows in the
database with column named "Protocol". Ideally I would like Visio to
retrieve all rows corresponding to the same connection, -or- append the
information with commas in the same property. Of course I can always put my
ports as a string prefixed by the protocol, i.e. "TCP: 39,80, UDP: 27,489".
But in this case I loose valuable information.

Can this be done with the Link to database wizard, or do I have to develop
custom VBA scripts?

Thanks,