Re: Client side printing

From: sansaw80 (sansaw80_at_discussions.microsoft.com)
Date: 02/11/05 

Date: Fri, 11 Feb 2005 00:23:08 -0800

Thanks Tibor, yes what you are suggesting, makes sense.

But I feel it will be better if I drop this idea and look for some different
option. Because if we want to specify UNC naming for printer. I need to make
printer as shared and need to give permissions so it can be accessible from
server by other users. Since printers are getting cheaper and cheaper, almost
everyone at client-side got there own printers, so I doubt if client admin
will accept this solution.

"Tibor Karaszi" wrote:

> xp_cmdshell is executed on the server machine, which has no knowledge of the client who submitted
> the SQL command. Perhaps you can specify the printer name using UNC naming so the print is done on
> the server machine, but the destination is specified as the client?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> http://www.sqlug.se/
>
>
> "Santosh" <Santosh@discussions.microsoft.com> wrote in message
> news:A37189CF-9AFE-403A-97FC-2586C96C275B@microsoft.com...
> > Hi
> >
> > I am trying to print Query Result directly to the printer from Client
> > machine. I managed to do this on Server machine. Where I had written SP which
> > accepts SQL as parameter and using osql and xp_cmdShell command I am
> > outputting CSV file to printer. I want to do same from client machine but I
> > want print out should get printed on client printer not on Server.
> >
> > Any ideas or suggestions??
> >
> > Many thanks in advance.
> >
> > Regards,
> > Santosh
> >
>
>
>

Relevant Pages

  • Re: Err.Raise in COM+ Component loses Err.Source and Err.Description
    ... error" on 2 different server machines running the same server-side package. ... I wish I had another Win2000 machine I could try as a client to ... Using the same SERVER machine and varying CLIENT machines running the same ... Set cnDBMS = New Connection ...
    (microsoft.public.vb.general.discussion)
  • Re: DCOM on Windows 2003 server
    ... Client and server are not in the same box. ... The server runs on a Windows ... The account of the user does not exist at the server machine. ...
    (microsoft.public.win32.programmer.ole)
  • Re: DCOM on Windows 2003 server
    ... > Client and server are not in the same box. ... > 2003 server machine, the client ist a quite standard PC with Windows XP ... each user is logged in as his own individual account. ...
    (microsoft.public.win32.programmer.ole)
  • Purging Remote Names Table Remotely...
    ... I have an ASPNET server application that allows a remote intranet ... client to change Tcp/Ip settings on the server machine. ...
    (microsoft.public.win32.programmer.networks)
  • Purging Remote Names Table Remotely
    ... I have an ASPNET server application that allows a remote intranet ... client to change Tcp/Ip settings on the server machine. ...
    (microsoft.public.win2000.networking)