How do i bind mysql table to global list?

[hagane92]

Hi,

How do I bind mysql table to global list. I’ve install the correct sql driver in server by when i test, it returns error.

[eddy.daouk]

Hi,

I believe this article will solve your issue:

How to connect to a MySQL database

You can use the ODBC connector to connect to the MySQL server. The connection string should look as follows: <add name="MySQL" connectionString="Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=test;uid=nativeuser;pwd=password;" providerName="System.Data.Odbc"/> This connection string can be stored in the wfgen\web.config file in order to use it in multiple forms. Make sure the ODBC connector is installed on your server: https://dev.mysql.com/downloads/connector/odbc/. Note: In MySQL…

Regards,
Eddy.

[hagane92]

Hi Eddy,

Thanks for the respond. Tried the solution but, doesn’t worK

[eddy.daouk]

Hi,

What doesn’t work? Please post a screenshot of the error.

Regards,
Eddy.

[hagane92]

The error is as below when i tried to query. The DSN already been added and also also the connection string already been set in the web.config.

[hagane92]

Hi Eddy,

Found the problem, Installed the wrong version of the driver. I accidentally installed a 32 bit version instead of 64bit.

[eddy.daouk]

Great - Thank you for the update.

[karenschmidt]

Can this databind with MySQL configuration be used with the delivered web form designer. Is it available in WFG v7.5? I do not see the databind tab in my text variables. Is there a setting or add on I need to install to get this option?

[eddy.daouk]

Hi Karen,

The databind feature is only available for List controls such as ListBox and DropdownListBox .
For other controls, you would need to use the code behind to perform the databind.

Regards,
Eddy.