List ODBC data sources in combobox
lazarus / 16-Databases

----------------------------------------------------------------------
mm_coder · 2017-03-13 19:37

Porting a vb6 application to Lazarus.

I need to know how to display the list of installed ODBC drivers in a
combo box for
the user to select for application setup.

Windows platform

----------------------------------------------------------------------
Thaddy · 2017-03-13 20:25

Something like:
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i // add
registry to the uses clauseprocedure TForm1.FormCreate(Sender:
TObject);var  Reg:TRegistry;begin Reg := TRegistry.Create; try 
 Reg.RootKey:= HKEY_LOCAL_MACHINE; 
 Reg.OpenKey('Software\ODBC\ODBCINST.INI\ODBC Drivers',False); 
 Reg.GetValueNames(Combobox1.Items); finally   Reg.Free; end;end;

----------------------------------------------------------------------
eny · 2017-03-13 21:19

Quote from: mm_coder on March 13, 2017, 08:37:50 pmWindows platform
Also note that in case you are using SQL Server (small chance  ofc )
Windows has a new ODBC driver that requires a separate download and
installation.

----------------------------------------------------------------------
mm_coder · 2017-03-13 23:14

Working perfectly. Thanks for taking the time.

Still getting used to the pascal way.
Thanks