ODBC connections

R

raven

I haven't been getting *any* responses in the general forums, so I'll try you
guys out:
After closing my Visio document, when I re-open it, I have to re-link the
..dsn file. How can I
1) automate re-linking the DB
2) keep the link active

Am I asking too much? What I mean is, is this working as designed and I'm
expecting too much for a "free" solution? Do ODBC connections always need to
be re-linked?
 
A

Al Edlund

You'll probably have to write a little code to 'auto' link to whatever
database you are using. I'd probably
do it by writing a little vba tied to the document opened event. To start
you might consider using the create macro
tool to capture what happens under the cover when you link to the database
and then wrap that with the event
code.

http://msdn.microsoft.com/library/d...-us/devref/HTML/DVS_21_Event_Handling_843.asp

Some good resources are Graham Widemans book (visio developers survival
guide) and David Edsons book as well.

Al
 
Top