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

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.