In which database type i should store large amount of data?

[Nishant]

Hiii, Enrique

           I have downloaded the examples and go through some of the basic vis and then after i have go to the examples, like fetch data from table, but it was not successful, as there is nothing specified in the vi, that which table we want to use for the data..., so can you plese explain me where and how to give the table name, from which we can fetch the data.

Thanks,

Nishant

[Enrique]

Hi Nishant;

About PostgreSQL - My guess is that you want the Windows version. You can download it from here (at the time of this writing):

http://www.postgresql.org/ftp/binary/v8.1.4/win32/

You should download postgresql-8.1.4-1.zip

About the VIs - Which ones are you talking about? LabSQL or the DB connectivity toolkit?

[Enrique]

Hi Nishant;
I realized you are talking about LabSQL. I am attaching an example on PostgreSQL and LabSQL. Check also the following info at PostgreSQL:

http://archives.postgresql.org/pgsql-interfaces/2005-08/msg00045.php Enrique

[Nishant]

Hiii, Enrique

            Thanks for the reply and for the vi also, but i am still in confusion about where to insert the database name? We are giving the driver, DSN, Uname, Pword etc. but main thing is from whic *.mdb file or any other databse file it will take table from which we want the data, without which it is not possible either to fetch the data from the table or to insert the data into the table? please give me some explanation about that.

Thanks,

Nishant

[Enrique]

You need to edit the string in the VI diagram. The first item is the name of the database (Access, Citadel, PostgrSQL, etc.) and the "database" is the name of your table (yourdata, etc.)

Message Edited by Enrique on 05-29-2006 09:57 AM

[Nishant]

Hiii, Enrique

                  Thanks for the reply, as you told me i have made changes accordingly into the vi, but i am getting the error "Exception occured in Microsoft OLE DB Provider for ODBC Drivers, [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.  in ADO Connection Open.vi->LabSQLtestVI_1.vi", in the main vi, now can you please show me what should i write connection string while i am using the MS Access as database? and as i am remembering somewhat, i have to create the driver for the OLEDB in the ODBC Data source Administrator, please tell me the procedure, how to do that? i think that will clear me some idea about this ADO connections.

Thanks,

Nishant

[Enrique]

I have someone that has the right expertise in databases in my team. As soon as I get an answer from him I'll let you know.

In the meantime, I believe you need to go in your computer to Control Panel -> Administrative Tools -> Data Sources (ODBC) and add your database to "System DSN".

[Nishant]

Hiii, Enrique

          Thanks for the reply, please do it as early as posible!!! as you told me , i already had tried in my database! but the thing is I couldnt fing driver for the OLEDB and that is what required here for using MS ACCESS!!

Thanks,

Nishant

[Dennis_Knutson]

When you click the Add button in the ODBC Data Source Administrator, do you see a driver called "Microsoft Access Driver (.mdb)"? If you don't, you might have an old or corrupt MDAC installation. MDAC is Microsoft Data Access Components. You can get the latest from Microsoft at http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&Displa....

[Nishant]

Hiii, Dennis

          Thanks for the reply, and as you gave information i have download the new version of MDAC, infact i had have the last version, but i still want to make sure about it, anyways, but i am in doubt that, the driver i will create, will it be accepted by the LabVIEW, cos i already have done this, but LabVIEW was not accepting it and was giving me an error, thats why i am in doubt, once i will try and i ll tell you, if it doesnt accept it.

Thanks,

Nishant