Calling a .NET function from SQL Server 2008

Question

Hi.. I have a dotnet function, written in C# which will try to print a pdf by initiating a process to read the file through acrord32.exe...I created the required assemblies in sql server and tried calling the function. The function executed, but the print never happened. The acroRD32.exe never got initiated. Is there a way to print PDFs through sql server code? Please help.

Answer 1

Hello ravi,

This won't work; a CLR assembly embedded in SQL Server will run server side under the service context, it don't know anything about your printers on client side etc.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing