Unsupported Screen Size: The viewport size is too small for the theme to render properly.

ODBC Import problem

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › ODBC Import problem

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • February 19, 2004 at 2:50 am #15486
      Ritesh
      Member

      What is your source DB?

      Can you send us a backup of the tables?

    • February 19, 2004 at 12:54 pm #15487
      Shadow
      Member

      Do the table names contain characters that are considered illegal in MySql? (A dot /'.'/ for example)

    • February 19, 2004 at 4:17 pm #15488
      dgoadby
      Member

      The table is called SpecificationComponents and all field names are plain text no odd characters or spaces.

      The field size of the weight is single precision which I assume maps ok to MySQL.

      I have attached a stripped down database (zipped) that only includes the problem tables. They were created in Access 2000. If you open it using Access then ignore any reference to the switchboard it is not required.

    • February 20, 2004 at 6:42 am #15489
      Ritesh
      Member

      We were able to import the database without any problem using the ODBC Import Wizard. We have Office XP and SQLyog 3.64.

      Is SQLyog crashing when you are importing empty table(s)?

      Which version of MySQL are you using?

    • February 21, 2004 at 1:11 am #15490
      dgoadby
      Member

      I am using Win98SE and Access2000.

      IThe problem is with MySQL 4.1.1a which I have been using for a while with no other problems. I installed a copy of 4.015 on another machine to test and, guess what, it imports fine.

      So, the problem seems to be with the latest 4.1.1a release. As I now have sub-selects I do hope that this can be fixed!

      SQLyog crashes the instant I click on the table selector check box. I have tried empty tables and non-empty tables and the result is the same.

    • February 21, 2004 at 5:15 am #15491
      Ritesh
      Member

      Thanks for the info.

      I will work on it and revert back soon.

  • Author
    Posts
Viewing 5 reply threads
  • You must be logged in to reply to this topic.