How do i bind mysql table to global list?


#1

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.

image


#2

Hi,

I believe this article will solve your issue:

Regards,
Eddy.


#3

Hi Eddy,

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


#4

Hi,

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

Regards,
Eddy.


#5

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.

image


#6

Hi Eddy,

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


#7

Great - Thank you for the update.


#8

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?


#9

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.