Results 1 to 4 of 4
  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 2565 records are copied but when I count tempACCOUNT no records are listed.
    FBNK.ACCOUNT is a JR file and tempACCOUNT is a XMLMSSQL 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,
    Jenolin

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Hi, I think this should have been posted in the MSSQL forum and not the MySQL forum.
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Mar 2011
    Posts
    7
    This is the MSSQL forum.,

  4. #4
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    I had never heard of jBase before. This is what I found:
    From the very beginning, jBASE was designed with both database and platform independence in mind. Before Microsoft delivered Open Database Connectivity (ODBC), jBASE engineers had already built a Database Management System, (DBMS) which was completely database independent. By means of an innovative open and published interface (jBASE External Device Interface, jEDI), customers could achieve seamless integration with foreign databases. This meant that any jBASE developed application could read and write to whichever database was required for data storage such as the native jBASE database but also Oracle, DB2 and others a first in the industry.
    That would mean that you can do an INSERT in a newly created MSSQL table. You write about files and XML. Are you going to transfer data from jBase to MSSQL via XML files?

    Try doing it with CSV first. It will be a lot faster and will produce smaller files compared to XML.
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Posting Permissions

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