PDF from SQL Procedure
-
I have a problem with creating pdf files directly from SQL 2005. I have a procedure, which transforms the text file into pdf one and sends it via email. I've tried to use PDF creator and everything is fine if I am logged on the server, where the SQL is placed. The Command Shell procedure uses
"C:\Program Files\PDFCreator\PDFCreator.exe" /PF"C:\file\file_name.txt".
It creates in the catalogue C:\file\file_name.pdf
If I try however to do the same but remotely,the text file is being created but the pdf file is not being created out of it. The files transform info pdf only when I'm logged on the server. I tried to install the PDF Creator in a server mode and then as a service, but unfortunately it did not improve the situation.
I've tried to use the NoStart button , but it did not help in any way as well.
Maybe some of you have any idea how to use the PDF Creator orany other freeware software to create the pdf file directly from the the SQL 2005 server procedure e.g. through the command line?
-
It may be because PDF creator installs as a print device... I've seen issues with PDF Creator and other PDF generation tools that work this way unless someone is logged in, unfortunately. The docs indicate you need to use an admin user if you're using it as a service... is SQL Server using a local or domain user account? If so, have you tried running PDFCreator under that user context?
K. Brian Kelley
@kbriankelley -
PDFCreator have 2 type of installation, standard (for workstation) and server. I've tried install PDFCreator in standard mode on Admin account. I've tried to install PDFCreator in a server mode as a service on admin's account but it did not work out as well...
But it's not working...
-
So you went through the document that talks about using tools from the Resource Kit? If so, that's the only solution I know of. Similar types of solutions we've tried in the past for other PDF conversion products went as spectacularly well and we ended up having to leave a logged on user.
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply