Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Problem connecting to MySQL Repository

Problem connecting to MySQL Repository 2 months 3 days ago #18707

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.

Problem connecting to MySQL Repository 2 months 3 days ago #18708

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7406
  • Karma: 32
  • Thank you received: 390
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
The following user(s) said Thank You: SIRsquiggles

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

Mike

Problem connecting to MySQL Repository 1 month 2 weeks ago #18744

Thank you, it worked!

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

  • Page:
  • 1

We have 780 guests and no members online