Use Oracle database with LabVIEW

[Rajashekar]

I am new to using Oracle database and i worked on MS Access database. I want to use Oracle database in one of our application to store the data and retreive data using SQL statements instead of MS Access. Plz give some suggestions which least version can i use? is there any free version i can get?. This i need to deilver along with the software.

[smercurio_fc]

Please

do

a

search

!!

Option 1: Database Toolkit.http://sine.ni.com/nips/cds/view/p/lang/en/nid/209060 

Option 2: LabSQL: http://jeffreytravis.com/lost/labsql.html

I will leave it to you to actually click on the links and read.

[ErnieH]

What is wrong with asking questions (even basic ones) on this board? Most if not all questions posted can be answered by searching or doing a little research. If you find these offensive, why answer?

[smercurio_fc]

How To Ask Questions The Smart Way

---

If you find these offensive, why answer?

---

Because I like to help.

[mikeporter · Accepted solution]

Yes there is a free version called Oracle XE that works very well. In fact, it is intended for (what Oracle referes to as) OEM applications. It is free to use and there are support forums available that are also free. The free version has all the features of Enterprise witha couple limit: First, it will only access one core in your CPU. Second, the maximum data size is 4 Gbytes.

In terms of connecting to it, check out this discussion.

MIke...

[Mark_Yedinak]

PostGRES and MySQL are also some decent free databases. MySQL is now supported by Oracle and even if you go with the Enterprise Edition it is a cheaper alternative to Oracle.

[smercurio_fc]

Is the question here what Oracle database to use, or is the question how to use Oracle with LabVIEW?

The last two responses seemed to be centered on the interpretation that the OP is asking what alternatives to Oracle to use. My interpretation of the question was how to use Oracle with LabVIEW. These are two different questions.

[mikeporter]

Yes they are, and in my post I answered both - at least to the driver level.

Obviously there are other questions like how to structure the interactions and how to design the database itself, but those can be sorted out best once he's got a database installed and is talking to it.

Mike...

PS: There is also the huge issue of translating the Jet dialect of SQL into the ANSI standard version that Oracle runs - potentially lots of fun to be had there...

Mike...

[Rajashekar]

Thanks for your valuable replies. Actually we are working out for one of our project, there the customer is clearly indicated to use the Oracle database. Since i am new to oracle database i wanted to know which version of datbase to use and how cost effective it is. However the Database Connectivity toolkit can be used to communicate with Oracle database which supports OLE DB and ODBC. I just checked the Oracle website and found that the Oracle XE is free version which can be used.

Thanks and Regards,

Rajashekar

[mikeporter]

Yes the DCT can be used. But given the problems it can cause you might not want to. Plus the DCT is not free...

Mike...