Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to retrieve ODBC database (DSN) drive & path?

Status
Not open for further replies.

AMadden

Technical User
Mar 22, 2002
16
US
Is there an VB API call that will return the drive and path of a database if I provide the DSN name?

For example, I have a Microsoft Access 2000 database located on a network drive: f:\apps\dbs\vstats.mdb. On a client machine I have a DSN for this database named "STATS".

I would like to programatically retrieve the network drive and path to the vstats database from the STATS DSN.

Any help on this would be appreciated. ---------------------------------
Art Madden
amadden@tampabay.rr.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top