forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › ODBC Import problem
- This topic is empty.
-
AuthorPosts
-
-
February 19, 2004 at 1:52 am #8334dgoadbyMember
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 #15486RiteshMember
What is your source DB?
Can you send us a backup of the tables?
-
February 19, 2004 at 12:54 pm #15487ShadowMember
Do the table names contain characters that are considered illegal in MySql? (A dot /'.'/ for example)
-
February 19, 2004 at 4:17 pm #15488dgoadbyMember
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 #15489RiteshMember
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 #15490dgoadbyMember
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 #15491RiteshMember
Thanks for the info.
I will work on it and revert back soon.
-
-
AuthorPosts
- You must be logged in to reply to this topic.