I have a Firebird Database on our server. I only want to read the data from this database from labview 8.2. I installed Performance Microwave's free ODBC labview files per the website http://performancemicrowave.com/sql_LV.html I am stuck at trying to connect to this database. Do I need to create a System DSN? If so, how? I do realize that there is a ODBC package offered from NI, but I wanted to try the "free route" first because I only want to read the database. Anyone have experience using this set of vi's?
- You don't need to create a System DNS but a User DNS. You can do this by navigating to Control Panel -> Admininistrative Tools -> Data Sources (ODBC) and Adding a User DNS.
- The free route should work 🙂 The following is something I have worked with successfully before: LabSQL; don't have any experience with the VIs you have attached.
I installed IBPhoenix Open Source Free ODBC Driver then created a System DSN. Then using LabSQL, I used the Name of my System DSN in that program and got a connection. Thanks for the help Adnan Z.
I would also like to get it to connect without making a System DSN. The 2 ways I 've tried LabSQL and sql-lv Free don't allow me to put in the full connection string from ConnectionStrings . Is there another method to use the full connection string in LabVIEW?
Another useful site listed some general and useful queries in databases.
What kind of connection string are you trying to use?
I have used this method to connect to a mySQL DB (local machine) an MS-Access DB (local machine), and a remote DB (can't remember what type) with no problems.
Yes, I did get a successful data set from the database. AFAIK firebird is a free database that can do many things. There are books on it, but I don't have any experience with managing databases. I just want to read certain information and put it into a report.
