Acrobat and SQL Server 7 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Acrobat and SQL Server 7

Author

Topic

edb2003
Yak Posting Veteran

66 Posts

Posted - 2003-09-29 : 15:24:49

Hi Everyone,
Here is an interesting request that sprouted into my area. There is a SQL Container that contains a part number. When a record(s) are populated into a container, a stored procedure will add a .pdf to the part and go to a mapped path in a hard drive, open and print the pdf file behind the scenes.

Does anyone know of a tool that automatically opens the pdf file and fires it off to a printer in SQL Server?

Any Negative or Positive input on this would be helpful as I do not think it is possible. I am checking right now with Adobe to see if there is such a tool.

Happy Day,
Ed

chadmat
The Chadinator

1974 Posts

Posted - 2003-09-29 : 15:45:24

Not 100% sure, but I think Crystal Reports can do something like this.

-Chad

http://www.clrsoft.com

Software built for the Common Language Runtime.

X002548
Not Just a Number

15586 Posts

Posted - 2003-09-29 : 15:46:33

Outside of SQL Server, can you do it?

Never heard of directly printing a pdf...

but if it could be done, my bet would be on

master..xp_cmdshell

Brett

8-)

SELECT @@POST FROM Brain ORDER BY NewId()

That's correct! It's an AlphaNumeric!

edb2003
Yak Posting Veteran

66 Posts

Posted - 2003-09-29 : 16:20:50

So Far from my search on the web there is this. I simply need to get it to work on the command line in DOS.

http://cwashington.netreach.net/depo/view.asp?Index=793&ScriptType=jscript

Thanks for all your input.

Happy Day,
Ed

X002548
Not Just a Number

15586 Posts

Posted - 2003-09-30 : 09:35:37

OK...

Some4thing like...


DECLARE @file varchar(256), @App varchar(256), @Cmd varchar(1000)
SELECT    @file = 'C:\Program Files\Adobe\Acrobat 6.0\Help\ENU\Reader.pdf'
	, @App =  'C:\Program Files\Adobe\Acrobat 6.0\Reader\acroRd32.exe /p '
SET @Cmd = '"' + @App + '" "'+  '''' + @File + '''' + '"'
SELECT @cmd

EXEC master..xp_cmdshell @Cmd

but you're link references a java script....think that has to be built first, then referenced in the command shell...

Brett

8-)

SELECT @@POST FROM Brain ORDER BY NewId()

That's correct! It's an AlphaNumeric!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources