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 6 reply threads
  • Author
    Posts
    • February 19, 2004 at 1:52 am #8334
      dgoadby
      Member

      I have a problem with ODBC import. Using the import wizard I select a User DSN and enter a username and password. I select Copy Tables and then Select-All and the program crashes: SQLYOG.EXE at 0167:004664ae

      By a slow process of elimination I have found that only two tables from my list crash the program. The simpler of the two tables is structured thus:

      Code, Text(5), Required, Indexed with dups allowed

      SourceMaterial, Text(12), Required, Indexed with dups allowed

      Weight, Single, Percent, 3 dec places, Required, Not Indexed

      Any idea what the problem is? Even if I am trying the impossible the program should not crash but should offer a sensible error message.

    • 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 6 reply threads
  • You must be logged in to reply to this topic.