Create ODBC Database DSN Dynamically

[DaveC]

Robert,
Add this statement to the code and see if it works, this contains the location.  Obviously MyDir and MyDatabase.mdb should fit to your parameters.

RegWriteString (REGKEY_HKLM,

 DatabaseKey,

 "DBQ", //The Location,

"C:\\MyDir\\MyDatabase.mdb"); //location of the database on the machine

-Dave

[Robert_Mensah]

Thanks,

I would try it tomorrow to see how it works.

Robert

[Nils_Gokemeijer]

For me, the easiest has been to create a myconnection.dsn file using the ODBC administrator control panel.

Then, in your executable distribution, include the myconnection.dsn file, and stick it in C:\Program Files\Common Files\ODBC\Data Sources

Then, you can use the following connect string : "filedsn= myconnection.dsn;UID=userid;PWD=password", and it works like a charm, both in LabVIEW and LabWIndows

in addition, because the DSN is in a standard location, other application, such as Excel can use it just as easy.