LabWindows/CVI

cancel
Showing results for 
Search instead for 
Did you mean: 

CVI Database Connectivity (SQL) Toolkit and OLE-DB connection

Some years ago I developed an application using CVI 6.0 and the SQL Toolkit, connecting to a MS Access database through an ODBC connection.

Now I'm planning a new application, and I did some web researches to see what's new in this topic.

I read that using an OLE-DB provider is faster than an ODBC driver, so I wonder if I should use it for a new application.

Is the OLE-DB the state of the art?

Has is some disadvantages compared to ODBC?

 

And, the most important thing: could I use this kind of connection with the CVI SQL Toolkit?

I think so because the help for the DBConnect() functions has an Attribute called Provider in the connectionString parameter, but I wonder if someone of the forum gurus has already used it

Vix
-------------------------------------------
In claris non fit interpretatio

-------------------------------------------
Using LV from 7
Using LW/CVI from 6.0
0 Kudos
Message 1 of 2
(3,772 Views)

Hi Vix,

 

it is possible to do this with LV so it would also be possible in CVI.

 

Cheers,

 

M

Matteo Brunella
Application Engineer
NI Italy
0 Kudos
Message 2 of 2
(3,754 Views)