Database: SqlServer2008R2
Database connection methods: ODBC
Questions as follows:
PB are defined in the execution of the stored procedure code below
DECLARE logical_procedure_name2 PROCEDURE FOR Mapping
@ Param1=: ls_typeCode,//value for '001'
@ Param2=: ls_code,//value for '002'
@ Param3=: ls_name,//value of 'Chinese boy'
@ Param4=: ls_Comments,//value of 'to'
@ Param5=: ls_doccode,//value for '0003'
@ Param6=: ls_docname//value for 'greater China'
USING pacs_tran;
PB call a stored procedure in place the following
The EXECUTE logical_procedure_name2;
I in the database to track to the execution result is the following
The Exec Mapping '001', '002', 'Chinese boy', 'to', '0003', 'big
If the @ Param3=: ls_name,//value for 'China good child'
Performs the EXECUTE in PB logical_procedure_name2; After
In the database to track the result is
The Exec Mapping '001', '002', 'Chinese boy', 'to', '0003', 'large and medium-sized
Very strange began to suspect that is a question of ODBC examined a nothing important also,
Have a character set might be the problem?
CodePudding user response:
Problem has been found is the problem that the parameters of the PB connection ODBCSpyware doctor BParm="ConnectString='DSN=sql2008R2; UID=sa; The PWD=ZXXXC (* & amp; ', DisableBind=1, StaticBind=0, CallEscape='No', DelimitIdentifier='Yes', StripParmNames=' Yes'
"Switch to
Spyware doctor BParm="ConnectString='DSN=sql2008R2; UID=sa; The PWD=ZXXXC (* & amp; ', CallEscape='No', DelimitIdentifier='Yes', StripParmNames=' Yes'
"