Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    10

    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-

    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.

  2. #2
    Join Date
    Apr 2007
    Posts
    10
    please anybody solve this problem

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •