- Posts: 6
- Thank you received: 0
Problem connecting to MySQL Repository
- SIRsquiggles
- Topic Author
- Offline
- New Member
-
Less
More
4 years 11 months ago #18707
by SIRsquiggles
Problem connecting to MySQL Repository was created 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?
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?
Please Log in or Create an account to join the conversation.
4 years 11 months ago #18708
by admin
Mike
ETL Architect
Replied by admin on topic Problem connecting to MySQL Repository
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
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.
- SIRsquiggles
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 6
- Thank you received: 0
4 years 10 months ago #18744
by SIRsquiggles
Replied by SIRsquiggles on topic Problem connecting to MySQL Repository
Thank you, it worked!
Please Log in or Create an account to join the conversation.