Reply Interested Question

[ºa¤Ö@¤½¥q]

Problem fixed
^.^

Using ADODB.Command and call stored procedure

It can pass unicode data

You cannot call the stored procedure by using following method

set rs = server.createobject("ADODB.Recordset")
rs.execute "stored_procedure 'param1', 'param2'", connection

This method is sql collation dependency, and cannot stored other coding
for example: if you want said simplify chinese in database, which collation
is Taiwan, it is failed although you set the field as N'' type
^.^

 

[Bob Barrows [MVP]]

Problem fixed
^.^

Using ADODB.Command and call stored procedure

It can pass unicode data

You cannot call the stored procedure by using following method

set rs = server.createobject("ADODB.Recordset")
rs.execute "stored_procedure 'param1', 'param2'", connection

A recordset does not have an Execute method. Perhaps you intended to use
"Open" instead ... ?

This method is sql collation dependency, and cannot stored other
coding for example: if you want said simplify chinese in database,
which collation is Taiwan, it is failed although you set the field as
N'' type ^.^

I have no strong objections to using the command object, but perhaps you
should try:

set rs = server.createobject("ADODB.Recordset")
rs.open "stored_procedure N'param1', N'param2'", connection

Or:

set rs = server.createobject("ADODB.Recordset")
connection.stored_procedure param1,param2, rs

Bob Barrows

 

[ºa¤Ö@¤½¥q]

Yes, using Open
hehe
typing error~~ sorry

Of course, you can using addnew method to pass unicode

^.^