07-28-2009 09:17 AM
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
07-29-2009 02:42 AM
Hi Vix,
it is possible to do this with LV so it would also be possible in CVI.
Cheers,
M