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

Program crash during ODBC import

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Program crash during ODBC import

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 5, 2004 at 1:40 am #8316
      dgoadby
      Member

      I created an ODBC File DSN to an Access database. I wanted to import a table to my empty MySQL database. The ODBC connected ok and I selected copy tables from data source. I was presented with a list of tables to select. The moment I click on one particular table in the list the program crashes with a page fault in SQLYOG.EXE.

      The table has 17000 entries and has a single primary key and 27 columns. Even if the table is empty it crashes. Any ideas where to look?

      SQLyog 3.63 on Win98SE with Access 2000

    • February 5, 2004 at 2:24 am #15444
      Ritesh
      Member

      Can you send me a backup of the database (specifically the errorneous table)?

    • February 6, 2004 at 5:42 am #15445
      peterlaursen
      Participant

      Try the opposite way around.

      Create empty table(s) in the database that your ODBC-thread works with.

      From Access choose file .. export .. ODBC-database..your MySQL database. Afterwards you can adjust field names, field length and type if necessary using SQLYOG.

      It has always worked for me with Access2000 and every version of MySQL and SQLYOG, that i've tried.

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