Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Posts
    7

    Question Unanswered: Conversion of JBase files to RDBMS tables(MSSQL)

    Hi,
    I need to convert my jbase files to RDBMS table(conversion programs not available). I am using SQL2008, R10 LocalHost.The connection is successful,
    created stubfiles and all those stuffs.

    While I copied as
    COPY FROM FBNK.ACCOUNT TO tempACCOUNT ALL
    it shows 2625 records are copied but when I
    COUNT tempACCOUNT
    no records are listed.
    Here FBNK.ACCOUNT is a JR file and tempACCOUNT is a XMLMSSQL file.(But able to copy the records to another JR file).

    The XMLdriver.log file shows info as,(also attached the complete log file)
    .......
    .........
    R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar

    09 14:31:36 - tempACCOUNT - tempACCOUNT -

    dbExecuteRead: Start
    R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar

    09 14:31:36 - tempACCOUNT - tempACCOUNT - accReadRow:

    *** WARNING *** The record is not found!
    R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar

    09 14:31:36 - tempACCOUNT - tempACCOUNT - drvRead:

    drvREAD - Record with key USD190050001 not found
    ..............
    ...............
    R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar

    09 14:31:36 - tempACCOUNT - tempACCOUNT - ErrorRecord:

    HResult: 0x80040e14
    Description: Statement(s) could not be prepared.
    SQLErrorInfo: 42000
    Source: Microsoft SQL Server Native Client 10.0
    File: dbProcess.cpp, Line: 1993


    R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar

    09 14:31:36 - tempACCOUNT - tempACCOUNT - ErrorRecord:

    HResult: 0x80040e14
    Description: Incorrect syntax near the keyword 'as'.
    SQLErrorInfo: 42000
    Source: Microsoft SQL Server Native Client 10.0
    File: dbProcess.cpp, Line: 1993

    R10.91634 - 3460 - (jutil.copycommand.b,196) - Wed Mar

    09 14:31:36 - tempACCOUNT - tempACCOUNT -

    dbExecuteInsert: End

    Can anyone help me on this?

    Thanks in Advance

  2. #2
    Join Date
    Oct 2003
    Location
    Germany
    Posts
    6
    Hi,

    Having not used jBase specifically, I am not able to directly answer your question.

    However, there is a jBase specific google group, where I am sure you will find alot of people ready to help.

    jBASE | Google Groups

    Hope that helps.

Posting Permissions

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