Embed ODBC Connection info in Visio document

[LostBrain]

Hi all,

I want to see if there is a way to embed the ODBC connection information
into the visio document instead of using an external dsn file. I have many
users that will need to access the database from different parts of the
network. Groups do not have same network shares, so putting on the network is
not an option.

Can the dsn file be accessed via http or https? This would be a great
solution.

 

[Al Edlund]

consider saving it as a custom property in the document sheet so you can
read it programatically.
al

 

[LostBrain]

Tried. No joy. 'ODBC.Connection' seems to be looking for a DSN file OR I'm
just not forming the string correct for shapesheet usage.

This works:
odbcdatasource=c:\filename.dsn

This does not work:
prop.odbcconn= "driver=sql server|database=test1|server=vm531a"
odbcdatasource=prop.odbcconn

 

[Al Edlund]

Specifically what I was thinking of was a technique used in one of the early
demo's
http://msdn.microsoft.com/library/en-us/dnvisio00/html/netconfig.asp?frame=true
where the database name was stored in a docsheet and then the vba program
grabbed it from there and created the call.
al