Connecting to a DSN

[googie]

I have multiple DSNs set up on my server so that I can access databases through Active Server Pages. Is there a way to connect to a DSN on the server through VB? I need to access these databases but would rather use a DSN instead of the path so that I can update the DSN if the path of a DB changes.

Any help is appreciated.

[bashfirst]

In VB 5.0 (and I assume VB 6 as well) there is a ODBC login form in the form wizard. It has some good code for generating a list of the DSNs available on a client box. Try creating the form with the wizard and cutting out the code you like.

Bash