Character being converted when calling Execute method

From: Michael Bauers (MichaelBauers_at_discussions.microsoft.com)
Date: 11/24/04


Date: Wed, 24 Nov 2004 14:35:01 -0800


We pass in a _bstr_t containing a call to a stored procedure using the
connection object's execute method. The code page of the local box is
latin-1.

The code page of the table we are running the stored proc against is CP1250.

We are passing in a string constant stored in CP1250. We set auto translate
to false.

The stored procedure does not execute properly. If its manually run in the
query, it analyzer DOES run correctly.

It seems as if the actual SQL string gets changed somewhere in ADO, or
something undesired happens when the stored procedure gets called.



Relevant Pages

  • Re: Problem with boolean return parameter of CallableStatement.exe
    ... Looks like the Sybase driver is wrong. ... parameter and it does no updating, so the execute method should return true. ... result set and checks that the boolean return parameteris true before then ... Please also show the text of the stored procedure. ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: SSIS Exec SQL Task Output Parm Value Not Updating Package Vari
    ... Instead of using an OUTPUT parameter in the sp, set the Execute SQL Task (on ... With stored procedures, the other connection ... listed in the stored procedure, which makes the connection a little more ... I've created a Master Package that will be used as a template for developing ...
    (microsoft.public.sqlserver.dts)
  • RE: SSIS Exec SQL Task Output Parm Value Not Updating Package Variable
    ... With stored procedures, the other connection ... listed in the stored procedure, which makes the connection a little more ... I've created a Master Package that will be used as a template for developing ... At the end of the process, the created audit record will be ...
    (microsoft.public.sqlserver.dts)
  • RE: MS Query "Connections"
    ... handle that with my connection string. ... for using the stored procedure route is that it is faster. ... If you truly want to pass in the query string, ...
    (microsoft.public.excel.programming)
  • Re: How to navigate recursive stored procedures results
    ... connection is inherited by the next user, ... beforehand so any residual #Temp tables would be dropped. ... the identity is not "flow"ing to the SQL Server - ... union a SQL query and the results of a stored procedure. ...
    (microsoft.public.dotnet.framework.adonet)