import problems from sybase ASE

This topic is empty.

Viewing 3 reply threads

Author

Posts
- July 15, 2004 at 3:46 pm #16060
  
  benito
  Member
  
  HI
  
  I am using Webyog v3.71 and I am importing not nearly as many records as you are, and I am experiencing the same problem.
  
  When importing data from an ODBC connection, columns that have random NULL values are left “NULL” when in fact, there is data in the fields of the according records.
  
  I am importing from Microsoft SQL Server 2000 into a MYSql 4.11 database.
  
  I have even tried importing the column in question alone AND I tried a completely seperate MYSql database and server , however, I still have the same problem.
  
  I know for a fact the data in the column exists as importing into MS Access via ODBC yeilds the results.
  
  I dont even see the ODBC import feature in SQLYog 4. Please help.
  
  Thank you for your time.
- July 15, 2004 at 5:19 pm #16061
  
  Ritesh
  Member
  
  Can you send me a dump of your database?
  
  Quote:
  
  I dont even see the ODBC import feature in SQLYog 4
  
  Our latest version is SQLyog 3.71.
- July 16, 2004 at 7:01 am #16062
  
  Shadow
  Member
  
  benito may have considered MAX's public beta as v4, it does not have ODBC import functions, yet. Unfortunately, I can't repeat an import involving thousands of records…
- July 26, 2004 at 3:58 am #16063
  
  dubh
  Member
  
  dubh wrote on Jul 5 2004, 02:49 PM:
  
  Yet, if I import the whole table rather than use a query, the data is reproduced in MySQL faithfully.
  
  Or so I thought. See here:
  
  http://www.webyog.com/forums/index.php?act…ct=ST&f=7&t=912
Author

Posts