Hi,
I am using win2000 server and pervasive SQL 2000i

i created a table using this script

CREATE TABLE GL2001
(ID Identity,
TRN_YEAR DOUBLE,
TRN_MONTH DOUBLE,
TRN_GLACCT CHAR(10),
TRN_GLDPT CHAR(4),
TRN_DATE DATE,
TRN_CODE CHAR(10),
TRN_INVC CHAR(10),
TRN_DESC CHAR(25),
TRN_DC CHAR(1),
TRN_AMT CURRENCY,
TRN_TYPE CHAR(2),
TRN_BATCH DOUBLE
)

then i tried to insert some records using this script


INSERT INTO UMCAccessDB.GL2001 (TRN_YEAR, TRN_MONTH, TRN_GLACCT,
TRN_GLDPT, TRN_DATE, TRN_CODE, TRN_INVC, TRN_DESC, TRN_DC, TRN_AMT,
TRN_TYPE, TRN_BATCH)
SELECT
YEAR(BKGL_TRN_DATE),
MONTH(BKGL_TRN_DATE),
RTRIM(BKGL_TRN_GLACCT),
RTRIM(BKGL_TRN_GLDPT),
BKGL_TRN_DATE,
RTRIM(BKGL_TRN_CODE),
RTRIM(LTRIM(BKGL_TRN_INVC)),
BKGL_TRN_DESC,
BKGL_TRN_DC,
BKGL_TRN_AMT,
BKGL_TRN_TYPE,
BKGL_TRN_BATCH
FROM UMCClientDB.BKGLTRAN WHERE BKGL_TRN_DATE < '2001-08-01'

then i get error:

ODBC Error: SQLSTATE = 08S01, Native error code = 10013
You have been unexpectedly disconnected from the server. Re-start your
application, then access the data source again. Contact your system
administrator if you still need assistance.
Driver not capable.

Not sure if this is it, but you should either define a default value for
ID (of 0), or specify this field at 0 in the query. Another problem could
be the differing database files, but this should be allowed as well.

Have you tried this on Pervasive.SQL V8?
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: August, 2004: See our web site for details!


Bre-x wrote: