f



Connection Parameters for Connecting directly to MS Access with SQL Toolkit

I tried to connect directly with the SQL Toolkit (Connect.vi) to a MS
Access database. After reading the article 1LQ7KVUT (ID number), I set
the connection parameters for Connect.vi as followed:
"DRIVER=Microsoft Access-Driver
(*.mdb);DBQ=E:\\Workspace\\Favorite\\database\\Impmessung-13-04-2004-2.mdb"

Running the Connect.vi results in Error 2702 and I got the following
error messages:
"Connect - Number contains invalid character: dBase files - Word
Number contains invalid character: dBase files - Word
Number contains invalid character: dBase files - Word
Number contains invalid character: dBase files - Word
<and so on>"

What invalid characters do I use?
Why is the error message referring to dBase files?
How to setup the connection to the MS Access database properly?
0
x9561 (148442)
6/18/2004 12:40:14 PM
comp.lang.labview 35213 articles. 1 followers. vasusachin24 (1) is leader. Post Follow

2 Replies
471 Views

Similar Articles

[PageSpeed] 58

The easiest way to create and verify a connection string is to
right-click your desktop and select New->Microsoft Data Link. This
brings up a pretty straightforward dilaog for configuring your
database connection (including a connection test). After that, the
"data link" is on your desktop as a text file. Open the file and
copy-paste the connection string.

An excellent resource for connection strings is this webpage:
http://www.able-consulting.com/tech.htm.

If you need to change the database from a running application, you
might want to invoke the configuration dialog via ActiveX
(MSADASC.IDataSourceLocator).
0
x9561 (148442)
6/18/2004 1:08:59 PM
Alexander,

It appears that you are using the old SQL Toolkit.  This toolkit uses
3rd party ODBC drivers and you can only connect to a database using
the ODBC Administrator and defining a DSN.

The article you read about connection strings refers to the Database
Connectivity Toolkit, which uses Microsoft's ActiveX Data Objects to
communicate with databases.  Those connection strings and the Data
Links that Herbert describes only work with this Toolkit - released in
2001 and works with every version of LabVIEW from 6.0 to 7.1.
0
x9561 (148442)
6/18/2004 2:36:41 PM
Reply: