LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

LV and MySql : error- 1

 

Hi all

I have the problem with LV and MySql

I installed MySql and Driver MySql the last versions.

Then I created the small VI

But I received this error:

DB Tools Open Connec (Path).vi->Untitled 1<ERR>The file provided is not a data link (UDL) or a file DSN.

Where is my error ?

Best regards

Iskander

0 Kudos
Message 1 of 6
(3,475 Views)
Did you create a ODBC connection to the database? You should. It is possible
to do without (using file paths), but it is much more difficult.

Go to control panel, administrative tools, ODBC connections. Create a new
ODBC item, that points to your database, using the mySQL driver.

Use DSN=yourdnsname as connection string.

Regards,

Wiebe.


0 Kudos
Message 2 of 6
(3,450 Views)

Hi

Thanks for the attention

I have the next ODBC connections  MySQL:

Please explain me: What am I connect ?

Regards

Iskander

0 Kudos
Message 3 of 6
(3,434 Views)
It seems to me you have a MySQL database, and you've created an ODBC
connection to it called "11".

Now, in LabVIEW, you have a connect VI (or new connection, or something like
it). Open an example that does a query. One of the inputs of this VI is
probably called "database name", "connection string" or something. I don't
have the toolkit installed, so I can't give the exact details. The string
connected to it is probably the database name of the example, either
"DNS=databasename" or simply "databasename". Replace "databasename" with
your database name, "11", without the quotes.

The example query that is done should be modified to suit your database.
That means, the table name should exist in your database, and the column
name should exist in that table. If you have an empty database, it's easiest
to create a table and some random data not uning LabVIEW, but using MySQL's
command line (see the manual). You can do queries to create tables and
columns, but that is not something to begin with.

That should do it, or you get an error that should give some more
information.

If you still can't get it to work, perhaps you should try to get some thing
working with an access database first.

Regards,

Wiebe.


0 Kudos
Message 4 of 6
(3,408 Views)

Dear Wiebe.

Thanks for the help and attention

All are working

Excuse me for the waiting

Regards

Iskander

0 Kudos
Message 5 of 6
(3,362 Views)

HI

I have else question

I created mini VI with fetch data from table of the MYSQL

But I have the big delay = 6 sek to fetch only one data

Why Have I the big delay with MYSQL?

Respect

Iskander

Message Edited by Iskander on 10-05-2008 11:56 AM
0 Kudos
Message 6 of 6
(3,323 Views)