Problem connecting to MySQL Repository

More
4 years 11 months ago #18707 by SIRsquiggles
I am having trouble making a MySQL Repository for my new installation of Visual Importer Enterprise. I keep receiving the error in the attachments. Basically it does not recognize the existence of the MySQL tables. I'm using

Visual Studio Importer 9.2.4.1
MySQL 5.7
ODBC Driver 5.3(Also tried ODBC8)

I've made sure the MySQL users have the proper permissions. Tried Multiple ODBC Drivers. Assure the MySQL installation has all the proper ib* files.

During the new creation wizard the test connections are all successful. Looking at the database all the tables are created and populated.

Does anyone know what could cause these errors?
Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 11 months ago #18708 by admin
I think this is because on unix table names are case sensitive by default and n windows they are not.

You can fix the issue by setting lower_case_table_names=1

Mike
ETL Architect
The following user(s) said Thank You: SIRsquiggles

Please Log in or Create an account to join the conversation.

More
4 years 10 months ago #18744 by SIRsquiggles
Thank you, it worked!

Please Log in or Create an account to join the conversation.