PRINT command Not Working For Database Client

Hello,

The PRINT command works fine on Query Analyzer.
However, when I used it with other Database Client,
eg: Aqua Data Studio, nothing got printed out.

Is there a way to make it work?

Thanks in advance.ehchn1@.hotmail.com (James) wrote in message news:<46fb4b22.0405272205.4e2e0bd4@.posting.google.com>...
> Hello,
> The PRINT command works fine on Query Analyzer.
> However, when I used it with other Database Client,
> eg: Aqua Data Studio, nothing got printed out.
> Is there a way to make it work?
>
> Thanks in advance.

I don't know anything about Aqua Data Studio, but the client has to
handle the PRINT output correctly - see "Using PRINT" in Books Online
for more details. The message is returned as an error, so perhaps Aqua
is treating it as an error, and doing something else with it. But you
should probably ask whoever makes the product.

Simon|||[posted and mailed, please reply in news]

James (ehchn1@.hotmail.com) writes:
> The PRINT command works fine on Query Analyzer.
> However, when I used it with other Database Client,
> eg: Aqua Data Studio, nothing got printed out.
> Is there a way to make it work?

Just like Simon, I have never heard of Aqua Data Studio before, but
a quick search on the net indicates that this is some of sort of
multi-platform Query Analyzer. If that sort of tool does not handle
PRINT correctly, this is a big defeciency, and you should raise an
issue with the vendor.

It could be, however, that the problem is in the JDBC driver, so trying
another driver could be worth a try. Then again, Aquafold says on
http://www.aquafold.com/docs-jdbcdrivers.html: "Microsoft SQL Server JDBC
Drivers - The SQL Server JDBC drivers included with ADS work across all
versions of SQL Server. There is no need to change or update this driver."

So you should probably talk to the vendor in this case too.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||
Erland Sommarskog wrote:

> [posted and mailed, please reply in news]
> James (ehchn1@.hotmail.com) writes:
>>The PRINT command works fine on Query Analyzer.
>>However, when I used it with other Database Client,
>>eg: Aqua Data Studio, nothing got printed out.
>>
>>Is there a way to make it work?
> Just like Simon, I have never heard of Aqua Data Studio before, but
> a quick search on the net indicates that this is some of sort of
> multi-platform Query Analyzer. If that sort of tool does not handle
> PRINT correctly, this is a big defeciency, and you should raise an
> issue with the vendor.
> It could be, however, that the problem is in the JDBC driver, so trying
> another driver could be worth a try. Then again, Aquafold says on
> http://www.aquafold.com/docs-jdbcdrivers.html: "Microsoft SQL Server JDBC
> Drivers - The SQL Server JDBC drivers included with ADS work across all
> versions of SQL Server. There is no need to change or update this driver."
> So you should probably talk to the vendor in this case too.

If the product uses JDBC, it is likely that the PRINT output will
be available to the JDBC driver via the Connection and Statement
getWarnings() call. You may get quicker turnarouond from the product
vendor if you include this fact.
Joe Weinstein at BEA