Proxy table

[Former Member]

I have testing SQLAnywhere12(3457) & 16(1324) by Windows 7 Build 7601 Service Pack 1 on X86_64 I am connecting Oracle10g & Oracle11g by ODBC

I am able to create Remote Server & Proxy tables and read data from proxy table. but problem is if I put condition to retrieve data, database die while I am using SQLAnywhere12(3840) & 16(1324) but if I use SQLAnywhere12(3457) I don't encounter this problem

CREATE EXISTING TABLE "DBA"."INWARD"(
  "OWNER_CODE" VARCHAR(12) NOT NULL,
  "ASN_NO" DECIMAL(8,0) NOT NULL,
  "WHS_CODE" VARCHAR(8) NOT NULL,
  "ASN_DATE" TIMESTAMP NULL,
  "ETA_DATE" TIMESTAMP NULL,
  "PO_NO" VARCHAR(24) NULL,
  "STATUS_CODE" VARCHAR(1) NOT NULL)
 AT 'wms;;WMS_DATA;INWARD';

[Breck_Carter]

Please show us the exact query that causes the problem, and the exact message you get ("database die" doesn't tell us much).

[Former Member]

select * from inward working fine. but select * from inward where owner_code='NAGASE' doesn't work, while issuing SQL, I am opening SQL DBSRV in screen, all sudden disappear, not able to find in Task Manager as well, if I connect from SQLCentral, not able to connect.

[thomas_duemesnil]

I had some problems in regard to numeric columns with Oracle. Can you try to use a integer for ASN_NO ? Does this make a difference ? Only a guess.

[Former Member]

I'm sorry, I did unsigned integer, timestamp change to datetime as well I have applied latest EBF but dbsrv disappear after I execute SQL program with condition.

Regarding SQLAny16, I have done 2 test 1. using existing DB to migrate to 16. 2. I have created database by SQLCentral using 16, create remote server, proxy table (only one) to isolate problem but still same result.

Right now I am not able to apply EBF to SQLAnywhere 12(3457 is using) 3457 never die so far.

Thank you for your advice