Re: errors calling linked oleDB server stored procedures

From: Michael, Cheng [MSFT] (v-mingqc_at_online.microsoft.com)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 12:29:24 GMT

Hi Gerry,

Thanks for you instant reply.

First of all, I have no idea about IBM.uniOLEDB, it is not supported by
Microsoft. So I am not sure whether the provider you used could support
remote call DB2 stored procedure and the error message is thrown by
IBM.uniOLEDB. Would you have a check that it support reomte stored
procedure call?

Secondly, would you please try to call a stored procedure without dynamic
parameter, like OPENQUERY (LinkedTableName, "call TestProc"), will it give
you right answer? I am not sure the correct syntax of DB2.

Thirdly, I think you could try using four-part named stored procedure
instead of OPENQUERY like
LinkedTableName.databaseName.ownerName.storedProcedureName

Anyway, I am convinced that running stored procedures from DB2 Server is
not supported by SQL Server, even you may get result, it is not reliable.

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know.

Sincerely yours,

Michael Cheng
Microsoft Online Support
***********************************************************
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.

Relevant Pages

  • Re: errors calling linked oleDB server stored procedures
    ... The remote database is not DB2, ... So I am not sure whether the provider you used could support ... would you please try to call a stored procedure without dynamic ...
    (microsoft.public.sqlserver.programming)
  • RE: after INSERT fail, make UPDATE guidelines
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... However if your intention is to recognize which column for each parameter it represents, you can create a stored procedure in your SQL ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)
  • RE: VS2008 & SQL Server Debugging
    ... The bug happens when the parameter of the stored procedure is user defined ... defined type parameter ... Check the output window from Debug output after it fails to step into ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.debugging)
  • RE: Linq to SQL Decimal output Parameters
    ... Initially when I encountered this problem I was mapping a stored procedure ... Regarding on this LINQ sp issue, I've performed some test according to the ... System.NullableparamValue) ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Non initialized Cmd Parameter Collection via ASP vs SQL Server
    ... component to access database and execute some stored procedure. ... error when change the database from SQL server 2000 to SQL Server 2005, ... Microsoft MSDN Online Support Lead ... Delighting our customers is our #1 priority. ...
    (microsoft.public.data.ado)