Oracle Database Discussions

Hi Experts,

When inserting data into a table on SQL Server, I got the error: [ODBC SQL Server Native Wire Protocol driver]String data, right truncated. Error in parameter 9. {22001}. But I didn't get the error when inserting the same data into the table on another SQL Server with another gateway. It's successful. What's wrong? Is the gateway's configuration issue?


Table:
create table "dbo".SQLSVR_DT_TGT_INSERT( ID int primary key, C_BINARY binary(17), C_BIT bit, C_CHAR char(17), C_DATETIME datetime, C_DECIMAL decimal(7,3), C_FLOAT float(7), C_INT int, C_MONEY money, C_NCHAR nchar(17), C_NUMERIC numeric(7,3), C_NVARCHAR nvarchar(17), C_REAL real, C_SMALLDATETIME smalldatetime, C_SMALLINT smallint, C_SMALLMONEY smallmoney, C_TINYINT tinyint, C_VARBINARY varbinary(17), C_VARCHAR varchar(17))');

DML:

INSERT
INTO
"dbo"."SQLSVR_DT_TGT_INSERT"@"DG4MSQL@MSQL_LOC"
( "SQLSVR_DT_TGT_INSERT"."C_BINARY",
"SQLSVR_DT_TGT_INSERT"."C_BIT",
"SQLSVR_DT_TGT_INSERT"."C_CHAR",
"SQLSVR_DT_TGT_INSERT"."C_DATETIME",
"SQLSVR_DT_TGT_INSERT"."C_DECIMAL",
"SQLSVR_DT_TGT_INSERT"."C_FLOAT",
"SQLSVR_DT_TGT_INSERT"."C_INT",
"SQLSVR_DT_TGT_INSERT"."C_MONEY",
"SQLSVR_DT_TGT_INSERT"."C_NCHAR",
"SQLSVR_DT_TGT_INSERT"."C_NUMERIC",
"SQLSVR_DT_TGT_INSERT"."C_NVARCHAR",
"SQLSVR_DT_TGT_INSERT"."C_REAL",
"SQLSVR_DT_TGT_INSERT"."C_SMALLDATETIME",
"SQLSVR_DT_TGT_INSERT"."C_SMALLINT",
"SQLSVR_DT_TGT_INSERT"."C_SMALLMONEY",
"SQLSVR_DT_TGT_INSERT"."C_TINYINT",
"SQLSVR_DT_TGT_INSERT"."C_VARBINARY",
"SQLSVR_DT_TGT_INSERT"."C_VARCHAR",
"SQLSVR_DT_TGT_INSERT"."ID"
)
VALUES
("S2_0_C1$1",
"S2_1_C5$1",
"S2_2_C8$1",
"S2_3_C3$1",
"S2_4_C1$1",
"S2_5_C2$1",
"S2_6_C7$1",
"S2_7_C0$1",
"S2_8_C2$1",
"S2_9_C3$1",
"S2_10_C3$1",
"S2_11_C4$1",
"S2_12_C0$1",
"S2_13_C8$1",
"S2_14_C3$1",
"S2_15_C5$1",
"S2_16_C4$1",
"S2_17_C1$1",
"S2_18_I1$1"
)
;


Thanks,
David

Edited by: user9546759 on May 19, 2011 2:03 PM