Hi listers,
We are trying to generate pdf files with BCA. To do that, we have written a VBA script that uses the PdfWriter driver. This script runs fine on the server interactively but doesn’t work when scheduled via the BCA.
It generates a PdfWriter error.
Any idea/solution is welcome.
TIA,
Christophe
Listserv Archives (BOB member since 2002-06-25)
Christophe.
Is the problem to do with the fact that the PDFWriter printer driver requires a filename ?
You can switch this option off by altering your win.ini file to specify a filename that will be used all the time by the printer driver. (But that defeats the object.) Why don’t you set up you BCA machine with the Adobe Distiller printer driver so the output is in .PS (postscript) format then have the Distiller application running on the server to convert the files to PDF? Although this would leave the reports on the server so you would have to employ a different type of distribution method to that of BCA. (To a particular folder on the server perhaps - you can alter Distiller settings to accomplish this).
We are trying to generate pdf files with BCA. To do that, we have written a VBA script that uses the PdfWriter driver. This script runs fine on the server interactively but doesn’t work when scheduled via the BCA.
It generates a PdfWriter error.
Any idea/solution is welcome.
TIA,
Christophe
Listserv Archives (BOB member since 2002-06-25)
One thing to look at - do you have any connections set / does the script write to a shared drive?
I am just wondering if maybe you are using a resource that is not available to the system when you are not logged in, eg, just a service is running… Things like shares may not be available to that service / the user that the service connects as.
Good luck,
Brent
Hi listers,
We are trying to generate pdf files with BCA. To do that, we have written a
VBA script that uses the PdfWriter driver. This script runs fine on the server interactively but doesn’t work when
scheduled via the BCA.
It generates a PdfWriter error.
Listserv Archives (BOB member since 2002-06-25)
Darren,
I set the filename in the __pdf.ini in my script. I use PdfWriter instead of Distiller because it is synchrone. When the pdf file has been generated, I put it in a mail so I need to know when the pdf file is ready. With distiller (3.01) if I put the .ps file in the in folder, I must wait that the .pdf file is in the out folder. Moreover, I had better quality using PdfWriter.
Brent,
My script is just writing into a log file on local drive C: and the pdf file is also generated on the local drive c:. And BCA can access this directory because BCA can open the .rep file which is in the same directory.
Thanks,
Christophe
Listserv Archives (BOB member since 2002-06-25)
Christophe.
The output of Distiller can be configured to match that of PDFWriter. Compare your settings of both.
Darren.
Darren,
I set the filename in the __pdf.ini in my script. I use PdfWriter instead of Distiller because it is synchrone. When the pdf file has been generated, I put it in a mail so I need to know when the pdf file is ready. With distiller (3.01) if I put the .ps file in the in folder, I must wait that the .pdf file is in the out folder. Moreover, I had better quality using PdfWriter.
Brent,
My script is just writing into a log file on local drive C: and the pdf file is also generated on the local drive c:. And BCA can access this directory because BCA can open the .rep file which is in the same directory.
Thanks,
Christophe
Listserv Archives (BOB member since 2002-06-25)