Re: Console application to generate Excel file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


"Cor Ligthert [MVP]" <notmyfirstname@xxxxxxxxx> wrote in message
news:eYggKMTOHHA.5064@xxxxxxxxxxxxxxxxxxxxxxx
Rad,

Will you be so kind not to answer C# questions in the VB.Net
newsgroup.

I never saw that done by a MVP without telling at least that there was
a better newsgroup for that.

Thanks in advance

Cor

"Rad [Visual C# MVP]" <nospam@xxxxxxxxxx> schreef in bericht
news:11sk3cspsbwqy.dlg@xxxxxxxxxxxxxxxxxxx
On 15 Jan 2007 05:33:02 -0800, Senthil wrote:

Hi all
I created a C# console application that is called through a
stored procedure using xp_cmdshell. The application generates an
Excel
report from the database with a macro embedded in it. The report
generation fails when it is through xp_cmdshell.
But when I tried to run the executable from the command prompt the
report gets generated successfully with the macro. What could be the
problem here??

Thanks in advance
Senthil

Probably the sql server account that you use to run the xp_cmdshell
account
does not have the rights to run such system stored procedures. You'll
need
to grant the account the appropriate rights

--
Bits.Bytes
http://bytes.thinkersroom.com




.

Relevant Pages

  • Re: Re-occuring error message SceClient 1202 Application Log error
    ... just post back in the newsgroup. ... This posting is provided "AS IS" with no warranties, and confers no rights. ... > expands them and remove the account. ...
    (microsoft.public.windows.server.migration)
  • Re: Console application to generate Excel file
    ... was a better newsgroup for that. ... report from the database with a macro embedded in it. ... Probably the sql server account that you use to run the xp_cmdshell ... does not have the rights to run such system stored procedures. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Console application to generate Excel file
    ... Tsk tsk tsk. ... WHY DO WE USE A NEWSGROUP NAMED DOTNET FOR A LANGUAGE THAT ISNT CALLED ... report from the database with a macro embedded in it. ... Probably the sql server account that you use to run the ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Console application to generate Excel file
    ... Will you be so kind not to answer C# questions in the VB.Net newsgroup. ... report from the database with a macro embedded in it. ... Probably the sql server account that you use to run the xp_cmdshell ... does not have the rights to run such system stored procedures. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Console application to generate Excel file
    ... WHY DO WE USE A NEWSGROUP NAMED DOTNET FOR A LANGUAGE THAT ISNT CALLED ... report from the database with a macro embedded in it. ... Probably the sql server account that you use to run the xp_cmdshell ...
    (microsoft.public.dotnet.languages.vb)