Hello,

We have a SQL2K Ent. on W2K Eng. Adv server. This server
also has MS-Office97 installed because it needs to run a
night job and call Excel's library to generate reports in
Excel format.
It failed to do that after the patch been applied. Excel
returns error message shows "-2147417851 (Method "~" of
object "~" failed)
Please help!!
Gary

RE: SQL server failed to call Excel's library after ms03-026 patch applied by joewu

joewu
Thu Aug 14 09:45:56 CDT 2003

Dear Gary,

Thank your for your post.

I learned that the problem began to occur after applying the new MS03-026
security patch. However, I think the current news group is not the best one
for this problem. To resolve this problem, you may need to check the code
which uses the Excel OCX to generate the Excel reports. Therefore, I
suggest that you post this question in the
microsoft.public.excel.programming news groups, which is primarily for
issues involving Excel development.

The reason why we recommend posting appropriately is you will get the most
qualified pool of respondents, and other partners who read the newsgroups
regularly can either share their knowledge or learn from your interaction
with us. I hope the problem can be resolved quickly.

Thank you for using our News Group.

Regards,
Joe Wu
Product Support Services
Microsoft Corporation

Get Secure! - www.microsoft.com/security

====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
|Content-Class: urn:content-classes:message
|From: "Gary Lam" <garylam@bluecross.com.hk>
|Sender: "Gary Lam" <garylam@bluecross.com.hk>
|Subject: SQL server failed to call Excel's library after ms03-026 patch
applied
|Date: Thu, 14 Aug 2003 01:07:44 -0700
|Lines: 11
|Message-ID: <09f901c3623b$24127dd0$a501280a@phx.gbl>
|MIME-Version: 1.0
|Content-Type: text/plain;
| charset="iso-8859-1"
|Content-Transfer-Encoding: 7bit
|X-Newsreader: Microsoft CDO for Windows 2000
|X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
|Thread-Index: AcNiOyQQwda9TzXcRPujDAHCc0qCAw==
|Newsgroups: microsoft.public.security
|Path: cpmsftngxa06.phx.gbl
|Xref: cpmsftngxa06.phx.gbl microsoft.public.security:30878
|NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
|X-Tomcat-NG: microsoft.public.security
|
|Hello,
|
|We have a SQL2K Ent. on W2K Eng. Adv server. This server
|also has MS-Office97 installed because it needs to run a
|night job and call Excel's library to generate reports in
|Excel format.
|It failed to do that after the patch been applied. Excel
|returns error message shows "-2147417851 (Method "~" of
|object "~" failed)
|Please help!!
|Gary
|


Re: SQL server failed to call Excel's library after ms03-026 patch applied by Tai

Tai
Thu Aug 14 18:14:58 CDT 2003

Another alternative could be to post in the SQL Server programming
newsgroup. The list of SQL Newsgroups, including programming, is found here:

http://www.microsoft.com/sql/community/newsgroups/default.asp

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Please reply only to the newsgroup.


"Joe Wu [MSFT]" <joewu@online.microsoft.com> wrote in message
news:k$7JGLnYDHA.2260@cpmsftngxa06.phx.gbl...
> Dear Gary,
>
> Thank your for your post.
>
> I learned that the problem began to occur after applying the new MS03-026
> security patch. However, I think the current news group is not the best
one
> for this problem. To resolve this problem, you may need to check the code
> which uses the Excel OCX to generate the Excel reports. Therefore, I
> suggest that you post this question in the
> microsoft.public.excel.programming news groups, which is primarily for
> issues involving Excel development.
>
> The reason why we recommend posting appropriately is you will get the most
> qualified pool of respondents, and other partners who read the newsgroups
> regularly can either share their knowledge or learn from your interaction
> with us. I hope the problem can be resolved quickly.
>
> Thank you for using our News Group.
>
> Regards,
> Joe Wu
> Product Support Services
> Microsoft Corporation
>
> Get Secure! - www.microsoft.com/security
>
> ====================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ====================================================
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> --------------------
> |Content-Class: urn:content-classes:message
> |From: "Gary Lam" <garylam@bluecross.com.hk>
> |Sender: "Gary Lam" <garylam@bluecross.com.hk>
> |Subject: SQL server failed to call Excel's library after ms03-026 patch
> applied
> |Date: Thu, 14 Aug 2003 01:07:44 -0700
> |Lines: 11
> |Message-ID: <09f901c3623b$24127dd0$a501280a@phx.gbl>
> |MIME-Version: 1.0
> |Content-Type: text/plain;
> | charset="iso-8859-1"
> |Content-Transfer-Encoding: 7bit
> |X-Newsreader: Microsoft CDO for Windows 2000
> |X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
> |Thread-Index: AcNiOyQQwda9TzXcRPujDAHCc0qCAw==
> |Newsgroups: microsoft.public.security
> |Path: cpmsftngxa06.phx.gbl
> |Xref: cpmsftngxa06.phx.gbl microsoft.public.security:30878
> |NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
> |X-Tomcat-NG: microsoft.public.security
> |
> |Hello,
> |
> |We have a SQL2K Ent. on W2K Eng. Adv server. This server
> |also has MS-Office97 installed because it needs to run a
> |night job and call Excel's library to generate reports in
> |Excel format.
> |It failed to do that after the patch been applied. Excel
> |returns error message shows "-2147417851 (Method "~" of
> |object "~" failed)
> |Please help!!
> |Gary
> |
>