Re: errors calling linked oleDB server stored procedures

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Fri, 30 Apr 2004 02:58:22 GMT

Hi Gerry,

Thanks for you instant reply.

You could have a try on registering COM in SQL Server. However, I am not
sure whether the COM will call stored procedures in Linked Server
successfully.

Based on my knowledge, SQL Server provide such stored procedures to call
COM component:
sp_OACreate, which is used to create an instance of the OLE object on an
instance of Microsoft SQL Server.
sp_OASetProperty, which is used to set a property of an OLE object to a new
value.
sp_OAMethod, which could call a method of an OLE object.

Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are here to be of assistance!

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

  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Views vs Stored Procedures, whats the difference?
    ... I develop both applications and databases. ... >Microsoft C#.NET and Microsoft SQL Server 2000 Production and 2005 Test ... >Should I be accessing views from stored procedures? ... Hugo Kornelis, SQL Server MVP ...
    (comp.databases.ms-sqlserver)
  • Re: Securing Stored Procedures from being seen
    ... username, but in SQL Server, there are too many users to map an individuals ... granting the group execute permissions. ... but I would have to know what groups the user belongs ... see the names of any stored procedures to which he has no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7
    ... For parsing a string to a date/time, the 103 format doesn't limits the user ... > which is used as the row source for the results form). ... > other solutions assuming I have to use SQL Server 7? ... > I don't understand how I can use parameterized stored procedures to solve ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Limiting views on data in a table
    ... returns the Windows login the user uses to connect to SQL Server. ... > The way I was implementing this was to use Windows Auth with a Windows ... > covered by which salespeople, ... > with it via the stored procedures. ...
    (microsoft.public.sqlserver.security)