TestComplete with mysql

[vbarros]

Hello,





I'm trying to use MySQL with TestComplete. I have already installed mysql-5.1.63-win32.msi and mysql-5.1.63-win32.msi already created the database but when I make the following steps:





1 - Double click the project

2 - I create a new variable of type DB Table

3 - I select as a Default Value, Database table

4 - I fill right Connection, login and password





After selecting the desired table and click on Table View displays the following message





---------------------------

TestComplete

---------------------------

Unable to display the table data. The Following error occurred:

[MySQL] [ODBC 5.1 Driver] [mysqld-5.1.63-community] You have an error in your SQL syntax; check the manual That Corresponds to your MySQL server version for the right syntax to use near '[car]' at line a

---------------------------

OK Help

---------------------------





Can anyone help me with this or even point me to a tutorial to solve this problem?

[HKosova · Accepted solution]

Hi Victor,



Sorry for the delayed reply.



It's a known issue with TestComplete 8, and we have a patch that fixes this. To get the patch, please open a support ticket and refer to this thread.



Alternatively, you can upgrade to TestComplete 9 that doesn't have this issue.