Reply Interested Question

[ºa¤Ö]

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]]

ºa¤Ö@¤½¥q wrote:

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
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[ºa¤Ö]

Yes, using Open
hehe
typing error~~ sorry

Of course, you can using addnew method to pass unicode

^.^

"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> wrote in message
news:e4**************@TK2MSFTNGP10.phx.gbl...

ºa¤Ö@¤½¥q wrote:

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
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"