Unanswered: is this a driver problem or sqlyog problem
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-
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
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.