Connecting LabView with MySQL

Connecting LabView with MySQL

Post by rolf » Wed, 08 Mar 2006 16:10:42



successfully installed MySQL and created database + tables + data...
but how can I connect it under LabView.. can anybody give me an advise?
it's some kind of in .frm file format... which OLE DB Provider should I
use to connect? thanks!!There is a
MyODBC driver that provides this. OLE DB transparently can make use of
ODBC providers, so installing MyODBC and configuring it properly should be enough.

Rolf KalbermatterMessage Edited by rolfk on 03-07-2006 07:42 AM
 
 
 

Connecting LabView with MySQL

Post by rolf » Wed, 08 Mar 2006 19:10:35


sure about UDL and that. I'm always working on ODBC level directly not
involving ADO DB at all but as far as I know, ODBC DSNs, which you can
setup in the ODBC Manager in the Control Panels and in newer Windows
versions in the Control Panels->Administrative  Tools->Data
Sources (ODBC), should be available in the OLE DB functions as well by
giving their name as Connect parameter.

Rolf Kalbermatter

 
 
 

Connecting LabView with MySQL

Post by rolf » Wed, 08 Mar 2006 19:10:39


should I key in for server, user, password etc columns? i've already
tried several times but I do not know where is wrong? pls help me on
this.. thanks....!!!Sorry, haven't
real experience with MySQL. But those settings depend on your MySQL
installation. The server name is probably the machine name of the
computer that has your MySQL server deamon running. The rest is
specific to your setup of the MySQL database and is configured
somewhere in your MySQL server installation.

Rolf Kalbermatter
 
 
 

Connecting LabView with MySQL

Post by 222 » Wed, 08 Mar 2006 20:10:50

After I key in Chong in the server name, it gives me this error: "Chong.tcktechnology.local' is not allowed to connect to this MySQL server"What should I do?? Anyway, thanks
Rolf for your kindness.....
 
 
 

Connecting LabView with MySQL

Post by rolf » Wed, 08 Mar 2006 20:10:51


probably maintains an access list which you can configure. This access
list tells an application which machines, domains or subdomains, IP
addresses or IP address ranges, can or can't connect to the server.
This is for security.  A proper application should install such
that by default you have a deny all access list, possibly with the only
exception for 127.0.0.1 aka localhost.

Maybe entering localhost as server name (if your MySQL server is on the
same machine) might work, depending on how the MySQL deamon is
resolving the incoming address), but the proper solution is to
explicitedly configure MySQL to allow connections from your machine.

Rolf KalbermatterMessage Edited by rolfk on 03-07-2006 11:35 AM