# How do i bind mysql table to global list?

**URL:** <https://discuss.workflowgen.com/t/how-do-i-bind-mysql-table-to-global-list/1112>\
**Category:** General WorkflowGen Discussion\
**Created:** [July 24, 2018, 7:53am UTC](https://discuss.workflowgen.com/t/how-do-i-bind-mysql-table-to-global-list/1112 "2018-07-24T07:53:38Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![hagane92](https://avatars.discourse-cdn.com/v4/letter/h/cc9497/32.png) [@hagane92](https://discuss.workflowgen.com/u/hagane92)\
**Post date:** [July 24, 2018, 7:53am UTC](https://discuss.workflowgen.com/t/how-do-i-bind-mysql-table-to-global-list/1112/1 "2018-07-24T07:53:39Z")

</div>

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](https://canada1.discourse-cdn.com/flex030/uploads/workflowgen/original/1X/5cb5e61851316a1dee4d7b2ed60f84d2fafdd507.png)

![image](https://canada1.discourse-cdn.com/flex030/uploads/workflowgen/original/1X/4dbbbe4be8c1ba1a8d160a2a5437f1b14124941f.png)

---

<div class="post-metadata">

**Author:** ![eddy.daouk](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/eddy.daouk/32/672_2.png) [@eddy.daouk](https://discuss.workflowgen.com/u/eddy.daouk)\
**Post date:** [July 24, 2018, 1:05pm UTC](https://discuss.workflowgen.com/t/how-do-i-bind-mysql-table-to-global-list/1112/2 "2018-07-24T13:05:34Z")

</div>

Hi,

I believe this article will solve your issue:

> [@How to connect to a MySQL database](https://discuss.workflowgen.com/t/how-to-connect-to-a-mysql-database/1068):
>
> 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.

---

<div class="post-metadata">

**Author:** ![hagane92](https://avatars.discourse-cdn.com/v4/letter/h/cc9497/32.png) [@hagane92](https://discuss.workflowgen.com/u/hagane92)\
**Post date:** [July 25, 2018, 2:16am UTC](https://discuss.workflowgen.com/t/how-do-i-bind-mysql-table-to-global-list/1112/3 "2018-07-25T02:16:36Z")

</div>

Hi Eddy,

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

---

<div class="post-metadata">

**Author:** ![eddy.daouk](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/eddy.daouk/32/672_2.png) [@eddy.daouk](https://discuss.workflowgen.com/u/eddy.daouk)\
**Post date:** [July 25, 2018, 12:55pm UTC](https://discuss.workflowgen.com/t/how-do-i-bind-mysql-table-to-global-list/1112/4 "2018-07-25T12:55:36Z")

</div>

Hi,

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

Regards,  
Eddy.

---

<div class="post-metadata">

**Author:** ![hagane92](https://avatars.discourse-cdn.com/v4/letter/h/cc9497/32.png) [@hagane92](https://discuss.workflowgen.com/u/hagane92)\
**Post date:** [July 26, 2018, 1:07am UTC](https://discuss.workflowgen.com/t/how-do-i-bind-mysql-table-to-global-list/1112/5 "2018-07-26T01:07:10Z")

</div>

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](https://canada1.discourse-cdn.com/flex030/uploads/workflowgen/original/1X/4dbbbe4be8c1ba1a8d160a2a5437f1b14124941f.png)

---

<div class="post-metadata">

**Author:** ![hagane92](https://avatars.discourse-cdn.com/v4/letter/h/cc9497/32.png) [@hagane92](https://discuss.workflowgen.com/u/hagane92)\
**Post date:** [July 26, 2018, 2:30am UTC](https://discuss.workflowgen.com/t/how-do-i-bind-mysql-table-to-global-list/1112/6 "2018-07-26T02:30:17Z")

</div>

Hi Eddy,

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

---

<div class="post-metadata">

**Author:** ![eddy.daouk](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/eddy.daouk/32/672_2.png) [@eddy.daouk](https://discuss.workflowgen.com/u/eddy.daouk)\
**Post date:** [July 30, 2018, 3:19pm UTC](https://discuss.workflowgen.com/t/how-do-i-bind-mysql-table-to-global-list/1112/7 "2018-07-30T15:19:15Z")

</div>

Great - Thank you for the update.

---

<div class="post-metadata">

**Author:** ![karenschmidt](https://avatars.discourse-cdn.com/v4/letter/k/a8b319/32.png) [@karenschmidt](https://discuss.workflowgen.com/u/karenschmidt)\
**Post date:** [October 24, 2018, 9:07pm UTC](https://discuss.workflowgen.com/t/how-do-i-bind-mysql-table-to-global-list/1112/8 "2018-10-24T21:07:50Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![eddy.daouk](https://yyz2.discourse-cdn.com/flex030/user_avatar/discuss.workflowgen.com/eddy.daouk/32/672_2.png) [@eddy.daouk](https://discuss.workflowgen.com/u/eddy.daouk)\
**Post date:** [October 29, 2018, 2:17pm UTC](https://discuss.workflowgen.com/t/how-do-i-bind-mysql-table-to-global-list/1112/9 "2018-10-29T14:17:14Z")

</div>

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.