LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

large data to database mssql server

I looking for Labview interface to database.
I am having Labview6.1 and database being
Mssql server 7.0 on windows NT.

I would like to know :
1. How can i store large data (BLOB) to Mssql server database using labview and its interface for database.

At present i am able to store and retrieve sucessfuly
only about 4000 bytes of data.

I want to continously store data from my application
to database using Labview ie.size of data will in
Megabytes.

Is that possile with Labview for mssql server.
0 Kudos
Message 1 of 3
(2,774 Views)
If you are using the Database Connectivity Toolset or ADO, I highly recommend connecting to the database using the OLE DB provider for SQL Server. The ODBC driver is unable to write more than 8 kB of data at once.
0 Kudos
Message 2 of 3
(2,774 Views)
I would suggest that you consider the Database Connectivity Toolset for LabVIEW. It is a simplified interfact to database programming and it uses SQL to communicate with them. Here is a link to NI's webpage which discusses the toolset.
J.R. Allen
0 Kudos
Message 3 of 3
(2,774 Views)