I should read more carefully... This is SUPPOSE to be vb so your code looks wrong in general. You should be using & and not +

query = "USE [TrapDB] "
query = query & "GO "
query = query & "DECLARE @return_value int "
query = query & "DECLARE @Data Binary(4096) "
query = query & "SET @Data =CONVERT(binary(4096)," & Validate("ahoj") & ") "
query = query & "EXEC @return_value = [dbo].[LBLPRT_AddPrintJob] "
query = query & " @PrintServer = N" & Validate(Text3) & ","
query = query & " @PrinterName = N" & Validate(Text4) & ", "
query = query & " @PrintedBy = N" & Validate(UserName) & ", "
query = query & " @PrintedFrom = N" & Validate(ComputerName) & ", "
query = query & " @PrintIssued = N" & Validate(Format(Now, "YYYY-MM-DD hh:mm:ss")) & ", "
query = query & " @PrintData = @Data "
query = query & "GO "


But yes if you just call the SP directly you don't need to worry about any of this!

__________________
Jason Hall

Follow me on Twitter @jhall2013

This will invoke an error. Because of GO must reside in single line. But as I told you, other breaks was there for the cosmetic purposes :-D, But it isnt help at all, I was try it before I submit this thread.

__________________
JVV