By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,784 Members | 1,182 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,784 IT Pros & Developers. It's quick & easy.

PRINT command Not Working For Database Client

P: n/a
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.
Jul 20 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
eh****@hotmail.com (James) wrote in message news:<46**************************@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
Jul 20 '05 #2

P: n/a
[posted and mailed, please reply in news]

James (eh****@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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3

P: n/a


Erland Sommarskog wrote:
[posted and mailed, please reply in news]

James (eh****@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

Jul 20 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.