Connecting LabView with MySQL

[222]

Hi all,

I've 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!!

[rolfk]

---

@222 wrote:
Hi all,

I've 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 Kalbermatter

Message Edited by rolfk on 03-07-2006 07:42 AM

[222]

I've already installed MyODBC driver... how to do the setup?? How can the LabView connect it using udl??

[rolfk]

---

@222 wrote:
I've already installed MyODBC driver... how to do the setup?? How can the LabView connect it using udl??

---

Not 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

[222]

ok.. now i'm in here .. what 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....!!!

[rolfk]

---

@222 wrote:
ok.. now i'm in here .. what 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

[222]

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.....

[rolfk]

---

@222 wrote:
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.....

---

MySQL 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 Kalbermatter

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

[cosmin]

Hi,

i succesfully used mySQL with Labview with little modifications to database toolbox (when you create a table the types in mysql does not corespond with the types from database toolbox).

for configuring odbc use localhost to server name, and root as user name. for administrating purposes use Mysql Administrator. When you install mysql you give a password for root user, use this password in odbc configuration.

cosmin

[222]

Thanks.... I managed to link it finally....