I was using sqlyog migration tool kit from webyog.com to retrive the sybase datbase 12 on sun workstation on solaris 2.7 to a mysql 5 database on a pc with windows 2k. for accessing the dta i used 3 type of sybase odbc drivers available on the internet-

1. datadirect
2. pcclient1252
3. the ase driver tht comes with ase 15 .

the first and second gave the fillowing error:


Error Code : 1072
Key column '' doesn't exist in table
(0 ms taken)

this is the ddl generated by sqlyog

CREATE TABLE `test`.`CMLoginInfo`( `LoginRecId` int(10) NOT NULL ,
`LoginId` smallint(5) NOT NULL ,
`WorkStnId` tinyint(3) UNSIGNED NOT NULL ,
`LoginTime` timestamp(23) NOT NULL ,
`LogoutTime` timestamp(23) NOT NULL ,
`WorkStnMode` tinyint(3) UNSIGNED NOT NULL ,
PRIMARY KEY ( `LoginRecId` ) ,
UNIQUE KEY `CMLoginInfo_pk` (`LoginRecId` ASC ,`` DESC ) )Type=InnoDB


As u can see that in the last line of the ddl statement it refers to some column name '' with sort order as DESC.

this is the table schema of the cmmogininfo table when quried at sybase.

Name Owner Type Data_located_on_segment When_created
CMLoginInfo dbo user table default Feb 21 2007 11:14AM





Column_name Type Length Prec Scale Nulls Default_name Rule_name Identity

LoginRecId int 4 NULL NULL 0 NULL NULL 0
LoginId smallint 2 NULL NULL 0 NULL NULL 0
WorkStnId tinyint 1 NULL NULL 0 NULL NULL 0
LoginTime datetime 8 NULL NULL 0 NULL NULL 0
LogoutTime datetime 8 NULL NULL 0 CMLoginInf_Logout_1081054887 NULL 0
WorkStnMode tinyint 1 NULL NULL 0 NULL NULL 0



index_name = CMLoginInfo_pk
index_description = clustered, unique located on default
index_keys = LoginRecId

index_max_rows_per_page = 0
index_fillfactor = 0
index_reservepagegap = 0

keytype = primary
object = CMLoginInfo
related_object = none

object_keys = LoginRecId, *, *, *, *, *, *, *


related_keys = *, *, *, *, *, *, *, *

AS U SEE NO WHERE THE SORT ORDER OF THE INDEX IS MENTIONED AS ASC OR DESC.

BUT THE ddl GENERATED BY MIGRATION TOOLKIT MENTIONS THE SORT ORDER AS asc AND ALSO MANTIONS A COL '' WITH SORT ORDER AS desc .



when i used the ase 15 driver

I could not access the sybase tables. I created a datasource called system121 and tested the connection. which gave the message "connection succeeded". but when i used the driver in the migration tool then no tables from sybase database were listed.


Plese tell me what is the problem.

Is it due to mismatch of sybse db ver and th edriver i am using.

please suggest some other sybase driver.

please anybody solve this problem

how about using MySQL's migration toolkit