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

Print button on toolbar

I have Visual Studio 2005 Standard where I am building a web app. In this
web app I have a Report Viewer and the print button on the toolbar is set to
true, however when I run the app it is not there.
Is this a bug?Not if you are using it in Local Mode. Print is not supported in this mode.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brad" <Brad@.discussions.microsoft.com> wrote in message
news:1855A531-0C20-4625-AE88-9BA151104A03@.microsoft.com...
>I have Visual Studio 2005 Standard where I am building a web app. In this
> web app I have a Report Viewer and the print button on the toolbar is set
> to
> true, however when I run the app it is not there.
> Is this a bug?
>

Print button not displayed in report viewer

When i design my report under BIDS(Business Intelligence development studio) i can view the print button of the report

when i use a webapplication i use the reportviewer control installed from C:\\Program files\Microsoft Sql Server\Reporting services...etc.

when i execute the application i dont see the print button displayed

when i checked with the property of reportviewer control the displayprintbutton was set to true but then too the button not present on the form

anything wrong with my installation

plz do help me

thanks

Rama

You are probably printing the report as a LocalReport which does not have a print button the ServerReport does though

|||We had the same issue and installed Reporting services SP2 and it worked.|||

sounded good to me but

I have version 9.00.3054 which I guess is sp2

true I can set the property but I don't get the button

principal to proxy problem

I can successfully execute my package via Business Studio but when I schedule it in SQL Agent I get the error message, 'could not get proxy data for proxy id = 2.' I am trying to execute the scheduled job with that proxy (call it abcd_proxy) because I have a logon id (call it abcd) with access to a specific network drive folder, which holds a required source flat file. The abcd logon is defined as a sysadmin account. I am unable to see that the abcd logon id is an added principal within the abcd_proxy, which I think is because the abcd logon principal has a sysadmin role. My proxy id = 2 definition looks to be defined the same way that my first proxy id was.

Does anyone have an idea about what the message means and how I can fix it?

I had to create a proxy recently to have an SSIS package write a file to a network folder. I am by no means an expert on the subject, but here is what I had to do.

I had to first create a windows account with the right credentials. I then created a credential, a proxy for the credential, and of course set the "Run As" parameter for the step to the proxy. I made sure that the new account was added as a sysadmin in SQL Server, added the account to the "Users" group on the server, as well as to the Logon as batch security policy. When I still had problems with the package being able to read a file it was related to the credentials of the account, which I had the network admin fix. Everything now runs fine.

I apologize if I have stated the obvious to you, but just wanted to share with you all the steps I had to take to perform a task very similar to what you are trying to do. Of course, I had to also use an "absolute" network path and not a mapped drive letter.

Hope this helps.

primary key/foreign key relationship

I'm using MS SQL Server Studio Express 9.0. When selecting SQL Server Compact Edition, I'm able to create tables and primary keys with no problem. But how do I create a relationship with another table (foreign key)?

Bob K.

There is not designer support for doing this with SQL CE, so you must use:

Code Snippet

ALTER TABLE Orders ADD FK_Customer_Order FOREIGN KEY (CustomerId) REFERENCES Customers(CustomerId)

Designer support for this is promised for the next version of SQL CE (3.5) - in the "Orcas" timeframe.

|||thanks Eric.
|||Eric,

is there a way to enter the above sql statement from with Studio Express?
|||Connect to the SDF file, and select File, New, New query, type the text in the query editor and press F5 to execute...|||once again, thank you.
|||uhhh... and the beat goes on...

i've entered the following sql statement:

ALTER TABLE Camera ADD FK_Format_Camera FOREIGN KEY (FormatID) REFERENCES Format(FormatID)

and received the following error:
Major Error 0x80040E14, Minor Error 25501
> ALTER TABLE Camera ADD FK_Format_Camera FOREIGN KEY (FormatID) REFERENCES Format(FormatID)
There was an error parsing the query. [ Token line number = 1,Token line offset = 41,Token in error = FOREIGN ]

i've attached a link that shows the tables and columns i'm attempting to update. i just can't see what i'm doing wrong. could someone help?

bob k.

|||the link:

http://www.rkamarowski.com/errors/error.jpg

|||

Sorry, the correct syntax is (using the sample Northwind.sdf):

Code Snippet

ALTER TABLE Orders ADD CONSTRAINT Reference FOREIGN KEY ([Customer ID]) REFERENCES Customers ([Customer ID])

|||perfect! thanks eric.
|||

Good Afternoon Erik,

Can you help me out with a project of my?! I programming for the first time in the .net cf and i create my database all manualy thought SqlCeEngine..

But i want to know if there is a better approach to do this by the "next, next theory" (visuali) . if i create the database using a GUI of sql serv mobile edition, how can i choose where this database will be created and how can i indicate to the datasource in the connection string of an sqlConnection where is my database?! can you help me? i have a checkpoint day 17 to present my work and i would like to finish the hole project will that date to get some time to another project that is coming up, so its kind of urgent subject.

Thank you anyway!

Preview pane not showing data

I have a problem within the Report Designer in Visual Studio .NET. I a new
report, I define a dataset that returns data via a SQL query fine. I design
the report without issues, but when I try to preview the report, no data is
displayed.
This error seems to have occured after applying reporting services SP1 to my
machine. No errors are reported, and nothing appears in the event log.
Any ideas as to how I can correct this problem out there?
Thanks in advance.
MattIs there an .rdl.data file in the same directory as your .rdl file? If so, delete it and try again.
Also, does hitting the Refresh button in the preview pane have any effect?
--
Thanks.
Donovan R. Smith
Software Test Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt Pothier" <Matt.Pothier@.sonepar-us.com> wrote in message
news:eEtr8WvfEHA.596@.TK2MSFTNGP11.phx.gbl...
> I have a problem within the Report Designer in Visual Studio .NET. I a new
> report, I define a dataset that returns data via a SQL query fine. I design
> the report without issues, but when I try to preview the report, no data is
> displayed.
> This error seems to have occured after applying reporting services SP1 to my
> machine. No errors are reported, and nothing appears in the event log.
> Any ideas as to how I can correct this problem out there?
> Thanks in advance.
> Matt
>|||Thanks for the response. There were .rdl.data files in the same directory.
I tried deleting them, but got the same results. The refresh button did not
help either.
In a moment of frustration I uninstalled reporting services; performed a
repair install on VS .Net, reinstalled Reporting services; applied the
service pack and started over again. Everything seems to be working now.
"Donovan R. Smith [MSFT]" <donovans@.online.microsoft.com> wrote in message
news:%23iGKIuvfEHA.3556@.TK2MSFTNGP12.phx.gbl...
> Is there an .rdl.data file in the same directory as your .rdl file? If
so, delete it and try again.
> Also, does hitting the Refresh button in the preview pane have any effect?
> --
> Thanks.
> Donovan R. Smith
> Software Test Lead
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Matt Pothier" <Matt.Pothier@.sonepar-us.com> wrote in message
> news:eEtr8WvfEHA.596@.TK2MSFTNGP11.phx.gbl...
> > I have a problem within the Report Designer in Visual Studio .NET. I a
new
> > report, I define a dataset that returns data via a SQL query fine. I
design
> > the report without issues, but when I try to preview the report, no data
is
> > displayed.
> >
> > This error seems to have occured after applying reporting services SP1
to my
> > machine. No errors are reported, and nothing appears in the event log.
> >
> > Any ideas as to how I can correct this problem out there?
> >
> > Thanks in advance.
> >
> > Matt
> >
> >
>

Preview a Report in Design Mode (VS 2005)

I am working with SQL Server Reporting Services and Visual Studio .Net 2005 Beta 2. In VS 2003 you could preview a report in design mode by clicking on the preview tab. There is no such tab in 2005 Beta 2. Does anyone know how to preview a report in design mode? Thanks.When you are using the Report Controls in local mode (embedded), there is no preview since your application is responsible for creating the data set to bind into the control. You will need to execute your application to preview.

Designer preview is only present in report server mode.

Preview a Report in Design Mode (VS 2005)

I am working with SQL Server Reporting Services and Visual Studio .Net 2005 Beta 2. In VS 2003 you could preview a report in design mode by clicking on the preview tab. There is no such tab in 2005 Beta 2. Does anyone know how to preview a report in design mode? Thanks.When you are using the Report Controls in local mode (embedded), there is no preview since your application is responsible for creating the data set to bind into the control. You will need to execute your application to preview.

Designer preview is only present in report server mode.