Groups > comp.databases.ms-sqlserver > #1964

Re: .xml (XML Spreadsheet 2003) to .pdf file

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!mx02.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: .xml (XML Spreadsheet 2003) to .pdf file
Date	Tue, 28 Jun 2016 21:15:29 +0200
Organization	Erland Sommarskog
Lines	22
Message-ID	<XnsA635D8403F24AYazorman@127.0.0.1> (permalink)
References	<0a3baec3-35a4-4752-b011-16db9f97a3a6@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx02.eternal-september.org; posting-host="54b1a6a8d0d78ca3d7e24b3701f94214"; logging-data="28471"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18V1qrD9wiBZBjIN+Kzf6++"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:BWc9RdhwlfiyE9Rzx+2LO+Mtaxs=
Xref	csiph.com comp.databases.ms-sqlserver:1964

Show key headers only | View raw

Rahul Verma (rahul.girdharwal@gmail.com) writes:
> Anybody have any idea, how to convert a .xml file (XML Spreadsheet 2003)
> to a .pdf file in Sql Server only. 
> 

What? SQL Server is a tool for data processing, not file conversion.

> I am trying below approach.
> Open the .xml file in excel.application using sp_oa Methods.
> And then save as .pdf file.
> 
> the issue is, I am not able to open the .xml file into 
> window.application using oa methods. 

Calling anything that interact with the desktop from a service (which 
does not have a desktop) is an utterly bad idea.

I would suggest that you go back to the drawing board and think of a
different solution that does not involve SQL Server.

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

.xml (XML Spreadsheet 2003) to .pdf file Rahul Verma <rahul.girdharwal@gmail.com> - 2016-06-28 08:07 -0700
  Re: .xml (XML Spreadsheet 2003) to .pdf file Erland Sommarskog <esquel@sommarskog.se> - 2016-06-28 21:15 +0200
    Re: .xml (XML Spreadsheet 2003) to .pdf file Rahul Verma <rahul.girdharwal@gmail.com> - 2016-06-29 00:02 -0700
      Re: .xml (XML Spreadsheet 2003) to .pdf file Erland Sommarskog <esquel@sommarskog.se> - 2016-06-29 09:47 +0200
        Re: .xml (XML Spreadsheet 2003) to .pdf file rja.carnegie@gmail.com - 2016-06-29 14:07 -0700

csiph-web