Path from an ODBC Alias

I want to get the path of my access database connected via ODBC into my application so that I can compact them.  Anyone help?
dvkAsked:
Who is Participating?
 
NetoManConnect With a Mentor Commented:
You can get it from your registry windows file. There is some sample on how to get this information :

var
  AppRegistry: TRegistry;
  RegistryPath, FPath: string;

begin

  AppRegistry := TRegistry.Create;
  try
     RegistryPath := '\SOFTWARE\ODBC\ODBC.INI\accesdb';
    AppRegistry.OpenKey(Format('%s', [RegistryPath]),True);
    FPath := AppRegistry.ReadString('DBQ');
  finally
    AppRegistry.Free;
  end;
   

when accesdb is your ODBC Alias
0
 
NetoManCommented:
Check also if this path is correct but have to be for your ODBC Instances becuase is standard.

to check use regedit and look for it on HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\
0
 
NetoManCommented:
does it work ? I sure it Did....

I haved work whit this kind of operations...

If you need some more help...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.