Re: Display Database Query in Visio

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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@xxxxxxxxxxx> wrote in message
news:1170767350.286756.185010@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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.



.

Relevant Pages

  • Re: freetexttable query never completes nor times out?
    ... Full text does not perform with a nested loop because the search is done for each iteration, if your server doesn't have much memory you will have a huge IO issue. ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ... dB (this time from the actual ASP page that passes the query to the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable query never completes nor times out?
    ... Full text does not perform with a nested loop because the search is done for each iteration, if your server doesn't have much memory you will have a huge IO issue. ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ... dB (this time from the actual ASP page that passes the query to the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable query never completes nor times out?
    ... if your server doesn't have much memory ... and the "executing query" ball just kept ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable query never completes nor times out?
    ... SQL Server MVP ... This is a dev server so I hadn't even been ... When I get properties for the FT catalog, ... I just ran a similar query on ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Single-Threading / Performance issues
    ... SQL Server MVP ... > Early this year my database was migrated from a single CPU, ... (when a long select query is running, ... server guy also sez it's not his problem. ...
    (microsoft.public.sqlserver.server)