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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top