Workflow Soluiton

 View Only
Back to discussions
Expand all | Collapse all

Table Generator with MySQL?

  • 1.  Table Generator with MySQL?

    Posted Mar 22, 2015 04:23 AM

    Is the Table Generator only compatible with SQL Server?  I'm trying to use it with an ODBC connection to MySQL and it keeps throwing errors.

    1. On the Connection form for the generator I can enter an ODBC connection string, click the Test Connection button and get a Connection Test Suceeded message
    2. Then on clicking the drop down to select a table I get a message "The connection string is invalid or selected server is not responding".  No table names are populated
    3. If I manually enter a valid table name I get a message "Cannot get definitions from table [table name here]: ERROR [42000][MySQL][ODBC 5.1 Driver][mysqld-5.6.22-log]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntac to use near '[table name here]' at line 1
    4. The account I'm using has full priviledges to the instance/schema

    Unlike my other post ( http://www.symantec.com/connect/forums/mysql-odbc-generator-syntax-error ) I don't really get any opportunity to modify the query being used.