ODBC data source creation using App builder/ installer??

[jdebuhr]

Is it possible to creat the DSN entries for database use within LabVIEW (lv8)??

Basically I have 3 Database files and When I deploy my App, I manually enter each DSN in the ODBC Data Source manager, is there a way to have this done during my App install?

If so, how do I go about adding it to my installer?

[Steve_Brooks]

I have always used .udl files instead of ODBC on installations.  In your installer you can add the .udl file and point your database connect to this file.  I can send you an example if you want.

Steve

[jdebuhr]

I am using UDL, but don't you also need to have the DSN set up as well?

[Steve_Brooks]

No, the UDL file contains all the information that a DSN entry in ODBC has.

[Steve_Brooks]

Here is a zip file that contains a VI, UDL file and a database file.  The file opens the database connection using the path to the UDL file.  Now when you install these they have to go to specific locations otherwise the UDL may not point to the database.  One good thing about a UDL file is that you can edit from LabVIEW like a text file if disk locations do change.  Put these three file in "C:\Temp" and you can see what it does.  The VI runs a simple SQL on a serial number to see what the next run number would be.

Hope this helps,

Steve

[jdebuhr]

OH I see, you used the Jet 4.0 driver and then you can just specify a location.. Cool. I will try that out