Re: errors calling linked oleDB server stored procedures

From: gerry (germ_at_hotmail.com)
Date: 04/28/04 

Date: Wed, 28 Apr 2004 12:18:43 -0400

Thanks again for the reply.

The remote database is not DB2 , it is uniVerse.

Remote procedure calls work fine via adoDB using the same oleDB provider
both with & without parameters but neither work with SQL server's
OpenQuery()

I think you are right, although the documentation states that this should
work , SQL server appears to have a BIG hole in its support for non-sql
server linked servers. Every other oleDB aware language/system/package i
have tried has no problem with invoking remote stored procedures using this
provider and successfully using the returned dataset.

thanks for you time with this issue.

""Michael, Cheng [MSFT]"" <v-mingqc@online.microsoft.com> wrote in message
news:CLPdCyRLEHA.308@cpmsftngxa10.phx.gbl...
> 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
    ... So I am not sure whether the provider you used could support ... would you please try to call a stored procedure without dynamic ... I am not sure the correct syntax of DB2. ... Microsoft Online Support ...
    (microsoft.public.sqlserver.programming)
  • Re: SBS Turn-Key Operation
    ... My entire business is primarly mobile, with the chance that an SMB needs ... > then use XP Remote Desktop support a lot easier. ... >> my customers are residental w/ a few SMB accounts. ...
    (microsoft.public.windows.server.sbs)
  • Re: Getting rid of old, obsolete kernels
    ... > to login via terminal server, enter user/password, hard reset the ... LILO and make the system unrecoverable without a boot disk. ... You need a remote serial concentrator to do this effectively. ... Some of the higher end ones support SSH now, ...
    (comp.os.linux.setup)
  • RE: performancecounter object and remote server
    ... you're using the .NET performance counter to open ... counters on remote machine, however, you got the following error, correct? ... running under a local account, has same username/password on both machine). ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.general)
  • RE: performancecounter object and remote server
    ... you're using the .NET performance counter to open ... counters on remote machine, however, you got the following error, correct? ... Microsoft MSDN Online Support Lead ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.general)