sql-lv Free ODBC problem connecting to Firebird Database

[Branson]

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?

Thanks for you help,

Branson 

[AdnanZ]

- 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.

[Neil.Pate · Accepted solution]

You do not actually need a DSN entry at all, if you wire in the correct connection string.

[Branson]

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.

-Branson 

[Neil.Pate]

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.

[Branson]

Its a Firebird Database on a Server inside my building.  Here is the screen shot of the connection string and vi block diagram.

 

[Branson]

Sorry, I had a few typos.  Missing colon and missing space in my connection string.

 

[Neil.Pate]

I take it from your screenshot you successfully SELECT'ed some data out of your DB?

Is firebird any good as a DB? I had not heard of it until now...

[Branson]

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.

[ramses64]

Hi Branson,
I would like to be able to create, read and write in a Firebird Database.
Do you have any exemple ?
Best regards,

Message Edité par ramses64 le 03-26-2010 03:08 AM