Batch Satement issued in c Code using SQLEXECDIRECT is
INSERT INTO DOCUMENT (RPT_VERSION_ID, RPT_AND_PAGE, RPT_ID, RPT_VERSION_CMP, STARTING_PAGE_NUM, STARTING_PAGE_RBA, PAGE_COUNT, SECTION_ID ) VALUES (?,?,?,?,?,?,?,?)


While getting trace from SQL Profiler we have found that in windows
Batch insert statement is converted fine as

INSERT INTO DOCUMENT (RPT_VERSION_ID, RPT_AND_PAGE, RPT_ID, RPT_VERSION_CMP, STARTING_PAGE_NUM, STARTING_PAGE_RBA, PAGE_COUNT, SECTION_ID ) VALUES (758477476,1252817530000000001,'AC001','7995988683 8883',1,58,8,'SALE') INSERT INTO DOCUMENT (RPT_VERSION_ID, RPT_AND_PAGE, RPT_ID, RPT_VERSION_CMP, STARTING_PAGE_NUM, STARTING_PAGE_RBA, PAGE_COUNT, SECTION_ID ) VALUES (758477476,1252817530000000009,'AC001','7995988683 8883',9,2360,6,'MANU')

but on SOLARIS SQL profiler shows the above statement as

INSERT INTO DOCUMENT (RPT_VERSION_ID, RPT_AND_PAGE, RPT_ID, RPT_VERSION_CMP, STARTING_PAGE_NUM, STARTING_PAGE_RBA, PAGE_COUNT, SECTION_ID ) VALUES (758474060,1252817530000000001,'AC001','7995988684 8579',1,58,8,'SALE'⤀   䤀䔀 䤀 䐀䌀e䴀䔀 ⠀t䔀䤀䤀䐀Ⰰ t䄀䐀t䄀䜀䔀Ⰰ t䤀䐀Ⰰ t䔀䤀䌀䴀tⰀ 䄀䤀䜀t䄀䜀䔀e 䴀Ⰰ 䄀䤀䜀t䄀䜀䔀䈀䄀Ⰰ t䄀䜀䔀䌀eⰀ 䔀䌀䤀䤀䐀 ⤀ 䄀䰀e䔀 ⠀758474060,1252 817530000000009,'AC001','79959886848579',9,2360,6, 'MANU'⤀ 



It seems to be a driver related problem (for Batch Inserts) and we are looking into it .




Anyone with solution??