Need .mdb path from ODBC datasource 
Author Message
 Need .mdb path from ODBC datasource

I have an Access '95 odbc datasource named ITEM set up and I need to
determine the path to the .mdb file for that source
at runtime. I know that for data access, I don't need this - I'd just use
the DSN, but I need the path itself as a string for
other reasons.
        I found the entry in the registry under
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\ITEM\DBQ
and tried to grab the string using GetSetting, but it kept returning an
emptry strng. I may be passing the wrong
parameters. GetSetting needs (appname,section,key) I use "DBQ" for the key,
but I'm not sure what values to use for
appname and section.
        Could anyone fill in the holes here, or is there an easier way to do this?

Any help would be greatly appreciated,

Chris Desany



Fri, 10 Mar 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Need .mdb path from ODBC source

2. .mdb path to Access datasource

3. .mdb Path for Access Datasource

4. PATH-APP AND MDB-PATH

5. app-path and mdb-path

6. Using MDB on Web as datasource

7. Connect to MDB without configuring Datasource

8. connect mdb without configuring datasource

9. Dynamically setting MailMerge Datasource Path

10. Open xl datasource/path

11. need help updating a local front end mdb from an mdb on an ftp site

12. Access 2.0 Maintaining connection to ODBC Datasource

 

 
Powered by phpBB® Forum Software