Re: xplog70.dll

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/18/05 

Date: Mon, 17 Oct 2005 23:00:15 -0600

What extended stored procedure are you calling from
xplog70.dll? You wouldn't really (shouldn't really) be
calling the dll directly but rather one of the extended
stored procedures in that dll.

-Sue

On Fri, 14 Oct 2005 21:59:00 GMT, "szv584 via
SQLMonster.com" <u14900@uwe> wrote:

>Hi!
>
>I'm not sure if this is the right group but I give it a try:
>
>I have a job that executes a DTS-package which in turn call a store procedure
>which calls another store procedure. The last procedure calls xplog70.dll
>passing a filename (full path) to get some information back about the file.
>This has worked for a long time without any trouble but it stopped working
>after we have patch the server with the latest patches from Microsoft
>(atleast that is the theory) -
>
>MS05-050
>MS05-051
>MS05-052
>MS05-046
>MS05-047
>MS05-048
>MS05-049
>MS05-044
>MS05-045
>
>Also, if you ignore the job and execute the whole "chain" from the DTS
>package the result is the same. However, if you start the "chain" by
>executing the first store procedure from Query Analyzer it works fine.
>
>When this fails the result from xplog.70.dll is nothing.
>Running the job as system administrator (windows account) or database owner
>gives the same "bad" result.
>
>Any ideas that can explain why i works from QA but running the job or DTS?
>
>Thank's in advance
>Bjorn

Relevant Pages

  • Re: DBD::Sybase and $sth->{syb_result_type} v. DBD::ODBC (Sql Server)
    ... write output parameters and return a value. ... individual operations in the procedure by calling odbc_more_results. ... Things get a little more complex for what I guess Sybase calls CS_MSG_RESULT ... the status from a stored procedure was ...
    (perl.dbi.users)
  • Re: Foreign key constraints problem in SNC SQL Native client
    ... calling one stored procedure before calling dw_1.update method. ... stored procedure system is trying to delete parent data from Table A. ... rows from table B before deleting the related rows from A. ...
    (microsoft.public.sqlserver.connect)
  • Re: Best practice
    ... > Best coding strategies for calling stored procedures from ASP.NET. ... > objOracleParameterSTATUS = new System.Data.OracleClient.OracleParameter ... > So on the whole we are setting 9 properties for a single parameter and if ... > this stored procedure accepts 10 parameters, then this process has to be ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: ntext/>8K as OUTPUT param
    ... You can create a temporary table in the calling stored procedure, ... > very complex and needs to EXEC some sql which cannot be done in a UDF. ... > I have found some references to calling a COM .dll using sp_OA*, ...
    (microsoft.public.sqlserver.programming)
  • Re: Logging within User_Defined Functions (UDF)
    ... Despite its name, xp_execresultset is an ordinary stored procedure, not an extended stored procedure. ... Ultimately you can only execute ... > DECLARE @cmdstr nvarchar ...
    (microsoft.public.sqlserver.programming)