disable all triggers: March 2012

Thursday, March 29, 2012

directors, actors, films (was "SqlPlus query. Need some help")

What i want to find is the following:

Find first and lastname for all female directors who have directed more than 5 movies,
and have used the same actor in all of their movies.

I've done the first part of this query which lists female directors with more than 5 movies:

select firstname, lastname
from person
where gender = 'F' AND personid in
(select personid
from participation
where partname = 'director'
group by personid
having count(personId)>5)
order by surname;

Now, how do I find the directors that have used the same actor in all of their movies?

5957HOMEWORK! :) :)

how do you define an actor? and when you say "have used the same actor in all of their movies" does this mean any actor or all actors?

by the way, you shouldn't have participation_id as the primary key of Participation -- the primary key should consist of the pair of columns person_id, film_id|||1. an actor is defined to participate in a film whenever partname = 'actor'.

2. Any actor is sufficient

Directly printing Report from RS without previewing

Hi All,
Is there a way to send a report from Reporting service directly to the printer without previewing in VS 2005 web application? I tried out an example which exports the report into a pdf and then sends it over to the printer but apparently it did not print. It stopped working after saving the reoprt on the client machine. The article is located at

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and

PrinterSettings printerSettings = new PrinterSettings();
printerSettings.MaximumPage = m_numberOfPages;
printerSettings.MinimumPage = 1;
printerSettings.PrintRange = PrintRange.SomePages;
printerSettings.FromPage = 1;
printerSettings.ToPage = m_numberOfPages;
printerSettings.PrinterName = "Hp Dj 550"; //here goes printer's name.
PrintDocument pd = new PrintDocument();

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

Inside of pd_PrintPage method, i don't have anything about the printer, just code to conver a byte[] into a graphics file... what ever, nothing goes to the printer... thanks in advance for your attention.

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

My ADO.NET skills are not quite up to par - how would I modify the Run method of this example to execute an existing server based report that I have? I have managed to convert the report from an RDL to an RDLC, and added it to my Console Project with VB.NET. In addition, I created a new Data Set within this project that returns the data from the original stored procedure that was used for the RDL file. I now need to associate this new Data Set with the RDLC report, as well as pass some parameters to it, but I am not sure how to proceed.

Any suggestions/direction would be greatly appreciated.

Thanks!

Directly printing Report from RS without previewing

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

Any suggestions/direction would be greatly appreciated.

Thanks!

Directly printing Report from RS without previewing

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

Any suggestions/direction would be greatly appreciated.

Thanks!

sql

Directly printing Report from RS without previewing

http://www.codeproject.com/vb/net/RSPrintLandscape.asp

Thanks for the help in advance.

Sanat

what version ? 2000 or 05 ?

printer on the server or on the client ?
if you look at the samples there is a printer delivery sample.

in rs 2000 I hacked that up some to output to a printer w/o the subscription stuff.
basicly when Render() is called it makes a windows EMF file that can then be sent to a printer as a page of output.

do that in a loop and you get printed copy.

just set the page up at the start with the right settings...

|||

and, you know how send the emf correctly to a printer?...

mm.. or how to construct a Printer Settigs or PrinterDocument?...

what should i do?

this is a part of code, and

pd.PrinterSettings = printerSettings;

pd.PrintPage += new PrintPageEventHandler(this.pd_PrintPage);

pd.Print();

|||Have you taken a look at http://www.gotreportviewer.com/? There is a sample called "Print a report from a console app" that uses the ReportViewer control to do this.|||

Thanks for the link Brian - this is almost exactly what I need to do (automatically print local reports).

Any suggestions/direction would be greatly appreciated.

Thanks!

Directly print to Printer

Hi,
I have a VB Application with Crystal Report 8. If I click the print button in VB, I dont want to show the Crystal Report. I want to print the contents of the report directly to the Printer without showing the report. Is there a way to do this?
Thanks in advance
MadhivananFrom memory, so.........please forgive any errors from failed memory......:-))

assumes using CR active x control:

Dim objPrintApp As CRAXDRT.Application
Dim objReport As CRAXDRT.Report

Set objPrintApp = New CRAXDRT.Application
Set objReport = objPrintApp.OpenReport(strReportSourcePath & strSourceFile)
objPrintApp.LogOnServerEx "pdsodbc.dll", "database", "database", "user", "pwd"

' set PromptUser to False, NumberOfCopies to value >=1
' all parameters in brackets are optional.
objReport.Printout [PromptUser], [NumberOfCopies], [Collated], [StartPageNumber], [StopPageNumber]

dave|||Thanks springsoft. I think this is for CR9 but what is the code for CR8?.

Madhivanan

Directly generate PDF file

Is it possible to generate directly a PDF file with a name, and not first
come in the HTML page and then eport to PDF.
I hope someone knows how.
Kind regards
A. MoeskerSure, you can do this with either web services or URL integration. You
specify the render method. The default is HTML. If you have a link in your
report use the jump to URL instead of jump to report. Look at books online
and search on URL
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"A. Moesker" <a.moesker@.home.nl> wrote in message
news:OAk2oUqRFHA.3140@.tk2msftngp13.phx.gbl...
> Is it possible to generate directly a PDF file with a name, and not first
> come in the HTML page and then eport to PDF.
> I hope someone knows how.
> Kind regards
> A. Moesker
>|||I use the following JavaScript to determine the output from a standard asp
search results page.
The URL is built up and then calls a window to open up the new URL which
automatically causes the document to either open or be saved (users selection
via dialogue box).
var HLINK="";
HLINK = HLINK + "http://{RS Server Name}/ReportServer"
HLINK = HLINK + "?%2f{Folder Name}%2f"+sReportName
HLINK = HLINK + "&rs%3aClearSession=true"
HLINK = HLINK + "&rs%3aCommand=Render"
HLINK = HLINK + "&rs%3aFormat=" + aFormat //HTML4.0 - PDF - EXCEL
HLINK = HLINK + "&S_Customer="+S_Customer //Params go here
HLINK = HLINK + "&rc%3aToolbar=True"
HLINK = HLINK + "&rc%3aJavaScript=True"
HLINK = HLINK + "&rc%3aLinkTarget=_top"
HLINK = HLINK + "&rc%3aArea=Toolbar"
HLINK = HLINK + ""
You can see how the URL is built up. I use some 12 or so params with this
page and thay can be bolted on where I have indicated.
Best of luck,
Tony
"Bruce L-C [MVP]" wrote:
> Sure, you can do this with either web services or URL integration. You
> specify the render method. The default is HTML. If you have a link in your
> report use the jump to URL instead of jump to report. Look at books online
> and search on URL
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "A. Moesker" <a.moesker@.home.nl> wrote in message
> news:OAk2oUqRFHA.3140@.tk2msftngp13.phx.gbl...
> > Is it possible to generate directly a PDF file with a name, and not first
> > come in the HTML page and then eport to PDF.
> >
> > I hope someone knows how.
> >
> > Kind regards
> >
> > A. Moesker
> >
> >
>
>

Directly editing data in results pane with SQL 2005 Management Studio

In SQL 2000 Enterprise Manager, one was able to edit and commit data on-the-fly directly from the results pane. Action->Open Table->Query with the SQL Pane shown gives you an interface similar to Query Analyzer. One could write a complex select statement with where clauses and joins, and the results pane would show the resulting data. The data is editable and instantly updated. We are now planning to migrate to SQL 2005, and so will need the same capabilities that were availiable from its predecessor. I believe there to be an option/configuration setting or panel in Management Studio that would expose this functionality. I have SQL 2005 Standard Client Tools installed with the SQL 2005 Express Engine, as well as SQL 2000 Client Tools.
The question is this: How do you edit data in the results grid in SQL 2005 Management Studio as you would in SQL 2000 Enterprise Manager when you Open Table via Query (Action->Open Table->Query), and what option/configuration setting or panel would you need to enable/show to make this a permanent feature? In other words, what is the equivalent of Action->Open Table->Query in Management Studio? And how do you make it the default setting?

Can this be done in SQL 2005? Or only in SQL 2000?|||You can use the Open Table functionality to modify the data in a table or schema-bound view. To do this, right click on a table (or view) and select Open Table (or Open View).|||I'm looking for Open Table via Query, not just All Rows.|||bump|||

Open a SQL Editor window, type some text, highlight the text, and select Design Query in Editor. This will bring up a modal dialog containing a Query Designer with your SQL.

Is this what you were looking for?

|||

I too have spent hours trying to figure out how to do tasks that were easy in SQL 2000 EM. If I open a table, it retrieves all rows, not something I want to do with a remote server.

I'd like to query a table, and be able to add or delete records, as well as edit data. SQL Management Studio seems to be lacking this feature of Enterprise Manager and Query Analyzer.

If I save a query to an .sql file, I can't add new records. There's got to be a better way.

|||

Can you safely use SQL 2000 client tools (Enterprise Manager/Query Analyzer) with SQL Server 2005? Is that a viable alternative to Management Studio?

|||

I searched for a possible solution and the only one is using SQL 2000 Enterprise Manager. If you want to use Management Studio this is bad, because we were using this feature for querying one or two records and changing some simple data. Now we have to write update queries, be aware of rowcount, take care of transactions, etc. Maybe this is the way MS wants people to do.

Also our DB admins will not be happy when developers use "Open Table" in Management Studio and query all data in tables which has millions of rows.

|||

I created a small table with just a few records. I open the table, and then paste my SQL query into the SQL pane, so I can query any table I want. I'll probably create a few more small tables so that I can use them for opening multiple queries at the same time.

This gets me by for now. I suspect Microsoft wants me to develope my own application or web pages to manage data, or use MS Access. It just seems that Management Studio should do the basics, and do them well. Wordwrap and pressing the INS key to toggle insert mode in the results pane don't work either, by design i've been told, which is unbelievable. I guess as a server product it's not designed to be as user friendly as I expect.

|||

I can't get the "open table" command to work. Was I suppose to set this function up during install or is it something within SSMS?

|||In SQL Management Studio, just right click a table.|||

Topm,

When I tried doing this I got this error,

"Object reference not set to an instance of an object. (SQLEditors)"

This doesn't tell me anything.

|||I was running SSMS remotely, apparently it doesn't like this. When I remote to the server then run SSMS it works fine.|||

The 'Open Table' command opens a grid with a * 'new row' at the end.
When I enter some data there it says always:

No row was updated.
The data in row 1 was not commited.
Error Source: Microsoft.VisualStudio.DataTools.
Error Message: The update row has changed or been deleted since data was last retrieved.
Correct the errors and retry or press ESC to cancel the change(s).

If I link that table from an Access database I can enter new data as it should be.

What is wrong here?

|||I have a related problem. In the query designer of Server Management Studio I can't enable the results option in the Pane. So I have to close the query designer to execute it. Does anyone knows how to enable the results pane in query designer?

Directly editing data in results pane with SQL 2005 Management Studio

Open a SQL Editor window, type some text, highlight the text, and select Design Query in Editor. This will bring up a modal dialog containing a Query Designer with your SQL.

Is this what you were looking for?

|||

I too have spent hours trying to figure out how to do tasks that were easy in SQL 2000 EM. If I open a table, it retrieves all rows, not something I want to do with a remote server.

I'd like to query a table, and be able to add or delete records, as well as edit data. SQL Management Studio seems to be lacking this feature of Enterprise Manager and Query Analyzer.

If I save a query to an .sql file, I can't add new records. There's got to be a better way.

|||

Can you safely use SQL 2000 client tools (Enterprise Manager/Query Analyzer) with SQL Server 2005? Is that a viable alternative to Management Studio?

|||

Also our DB admins will not be happy when developers use "Open Table" in Management Studio and query all data in tables which has millions of rows.

|||

I can't get the "open table" command to work. Was I suppose to set this function up during install or is it something within SSMS?

|||In SQL Management Studio, just right click a table.|||

Topm,

When I tried doing this I got this error,

"Object reference not set to an instance of an object. (SQLEditors)"

This doesn't tell me anything.

|||I was running SSMS remotely, apparently it doesn't like this. When I remote to the server then run SSMS it works fine.|||

The 'Open Table' command opens a grid with a * 'new row' at the end.
When I enter some data there it says always:

If I link that table from an Access database I can enter new data as it should be.

What is wrong here?

sql

Directly editing data in results pane with SQL 2005 Management Studio

Open a SQL Editor window, type some text, highlight the text, and select Design Query in Editor. This will bring up a modal dialog containing a Query Designer with your SQL.

Is this what you were looking for?

|||

I too have spent hours trying to figure out how to do tasks that were easy in SQL 2000 EM. If I open a table, it retrieves all rows, not something I want to do with a remote server.

I'd like to query a table, and be able to add or delete records, as well as edit data. SQL Management Studio seems to be lacking this feature of Enterprise Manager and Query Analyzer.

If I save a query to an .sql file, I can't add new records. There's got to be a better way.

|||

Can you safely use SQL 2000 client tools (Enterprise Manager/Query Analyzer) with SQL Server 2005? Is that a viable alternative to Management Studio?

|||

Also our DB admins will not be happy when developers use "Open Table" in Management Studio and query all data in tables which has millions of rows.

|||

I can't get the "open table" command to work. Was I suppose to set this function up during install or is it something within SSMS?

|||In SQL Management Studio, just right click a table.|||

Topm,

When I tried doing this I got this error,

"Object reference not set to an instance of an object. (SQLEditors)"

This doesn't tell me anything.

|||I was running SSMS remotely, apparently it doesn't like this. When I remote to the server then run SSMS it works fine.|||

The 'Open Table' command opens a grid with a * 'new row' at the end.
When I enter some data there it says always:

If I link that table from an Access database I can enter new data as it should be.

What is wrong here?

Directly editing data in results pane with SQL 2005 Management Studio

Open a SQL Editor window, type some text, highlight the text, and select Design Query in Editor. This will bring up a modal dialog containing a Query Designer with your SQL.

Is this what you were looking for?

|||

I too have spent hours trying to figure out how to do tasks that were easy in SQL 2000 EM. If I open a table, it retrieves all rows, not something I want to do with a remote server.

I'd like to query a table, and be able to add or delete records, as well as edit data. SQL Management Studio seems to be lacking this feature of Enterprise Manager and Query Analyzer.

If I save a query to an .sql file, I can't add new records. There's got to be a better way.

|||

Can you safely use SQL 2000 client tools (Enterprise Manager/Query Analyzer) with SQL Server 2005? Is that a viable alternative to Management Studio?

|||

Also our DB admins will not be happy when developers use "Open Table" in Management Studio and query all data in tables which has millions of rows.

|||

I can't get the "open table" command to work. Was I suppose to set this function up during install or is it something within SSMS?

|||In SQL Management Studio, just right click a table.|||

Topm,

When I tried doing this I got this error,

"Object reference not set to an instance of an object. (SQLEditors)"

This doesn't tell me anything.

|||I was running SSMS remotely, apparently it doesn't like this. When I remote to the server then run SSMS it works fine.|||

The 'Open Table' command opens a grid with a * 'new row' at the end.
When I enter some data there it says always:

If I link that table from an Access database I can enter new data as it should be.

What is wrong here?

Directly editing data in results pane with SQL 2005 Management Studio

Open a SQL Editor window, type some text, highlight the text, and select Design Query in Editor. This will bring up a modal dialog containing a Query Designer with your SQL.

Is this what you were looking for?

|||

I too have spent hours trying to figure out how to do tasks that were easy in SQL 2000 EM. If I open a table, it retrieves all rows, not something I want to do with a remote server.

I'd like to query a table, and be able to add or delete records, as well as edit data. SQL Management Studio seems to be lacking this feature of Enterprise Manager and Query Analyzer.

If I save a query to an .sql file, I can't add new records. There's got to be a better way.

|||

Can you safely use SQL 2000 client tools (Enterprise Manager/Query Analyzer) with SQL Server 2005? Is that a viable alternative to Management Studio?

|||

Also our DB admins will not be happy when developers use "Open Table" in Management Studio and query all data in tables which has millions of rows.

|||

I can't get the "open table" command to work. Was I suppose to set this function up during install or is it something within SSMS?

|||In SQL Management Studio, just right click a table.|||

Topm,

When I tried doing this I got this error,

"Object reference not set to an instance of an object. (SQLEditors)"

This doesn't tell me anything.

|||I was running SSMS remotely, apparently it doesn't like this. When I remote to the server then run SSMS it works fine.|||

The 'Open Table' command opens a grid with a * 'new row' at the end.
When I enter some data there it says always:

If I link that table from an Access database I can enter new data as it should be.

What is wrong here?

Directly editing data in results pane with SQL 2005 Management Studio

Open a SQL Editor window, type some text, highlight the text, and select Design Query in Editor. This will bring up a modal dialog containing a Query Designer with your SQL.

Is this what you were looking for?

|||

I too have spent hours trying to figure out how to do tasks that were easy in SQL 2000 EM. If I open a table, it retrieves all rows, not something I want to do with a remote server.

I'd like to query a table, and be able to add or delete records, as well as edit data. SQL Management Studio seems to be lacking this feature of Enterprise Manager and Query Analyzer.

If I save a query to an .sql file, I can't add new records. There's got to be a better way.

|||

Can you safely use SQL 2000 client tools (Enterprise Manager/Query Analyzer) with SQL Server 2005? Is that a viable alternative to Management Studio?

|||

Also our DB admins will not be happy when developers use "Open Table" in Management Studio and query all data in tables which has millions of rows.

|||

I can't get the "open table" command to work. Was I suppose to set this function up during install or is it something within SSMS?

|||In SQL Management Studio, just right click a table.|||

Topm,

When I tried doing this I got this error,

"Object reference not set to an instance of an object. (SQLEditors)"

This doesn't tell me anything.

|||I was running SSMS remotely, apparently it doesn't like this. When I remote to the server then run SSMS it works fine.|||

The 'Open Table' command opens a grid with a * 'new row' at the end.
When I enter some data there it says always:

If I link that table from an Access database I can enter new data as it should be.

What is wrong here?

Directly editing data in results pane with SQL 2005 Management Studio

Open a SQL Editor window, type some text, highlight the text, and select Design Query in Editor. This will bring up a modal dialog containing a Query Designer with your SQL.

Is this what you were looking for?

|||

I too have spent hours trying to figure out how to do tasks that were easy in SQL 2000 EM. If I open a table, it retrieves all rows, not something I want to do with a remote server.

I'd like to query a table, and be able to add or delete records, as well as edit data. SQL Management Studio seems to be lacking this feature of Enterprise Manager and Query Analyzer.

If I save a query to an .sql file, I can't add new records. There's got to be a better way.

|||

Can you safely use SQL 2000 client tools (Enterprise Manager/Query Analyzer) with SQL Server 2005? Is that a viable alternative to Management Studio?

|||

Also our DB admins will not be happy when developers use "Open Table" in Management Studio and query all data in tables which has millions of rows.

|||

I can't get the "open table" command to work. Was I suppose to set this function up during install or is it something within SSMS?

|||In SQL Management Studio, just right click a table.|||

Topm,

When I tried doing this I got this error,

"Object reference not set to an instance of an object. (SQLEditors)"

This doesn't tell me anything.

|||I was running SSMS remotely, apparently it doesn't like this. When I remote to the server then run SSMS it works fine.|||

The 'Open Table' command opens a grid with a * 'new row' at the end.
When I enter some data there it says always:

If I link that table from an Access database I can enter new data as it should be.

What is wrong here?

sql

Directly editing data in results pane with SQL 2005 Management Studio

Open a SQL Editor window, type some text, highlight the text, and select Design Query in Editor. This will bring up a modal dialog containing a Query Designer with your SQL.

Is this what you were looking for?

|||

I too have spent hours trying to figure out how to do tasks that were easy in SQL 2000 EM. If I open a table, it retrieves all rows, not something I want to do with a remote server.

I'd like to query a table, and be able to add or delete records, as well as edit data. SQL Management Studio seems to be lacking this feature of Enterprise Manager and Query Analyzer.

If I save a query to an .sql file, I can't add new records. There's got to be a better way.

|||

Can you safely use SQL 2000 client tools (Enterprise Manager/Query Analyzer) with SQL Server 2005? Is that a viable alternative to Management Studio?

|||

Also our DB admins will not be happy when developers use "Open Table" in Management Studio and query all data in tables which has millions of rows.

|||

I can't get the "open table" command to work. Was I suppose to set this function up during install or is it something within SSMS?

|||In SQL Management Studio, just right click a table.|||

Topm,

When I tried doing this I got this error,

"Object reference not set to an instance of an object. (SQLEditors)"

This doesn't tell me anything.

|||I was running SSMS remotely, apparently it doesn't like this. When I remote to the server then run SSMS it works fine.|||

The 'Open Table' command opens a grid with a * 'new row' at the end.
When I enter some data there it says always:

If I link that table from an Access database I can enter new data as it should be.

What is wrong here?

Directly editing data in results pane with SQL 2005 Management Studio

Open a SQL Editor window, type some text, highlight the text, and select Design Query in Editor. This will bring up a modal dialog containing a Query Designer with your SQL.

Is this what you were looking for?

|||

I too have spent hours trying to figure out how to do tasks that were easy in SQL 2000 EM. If I open a table, it retrieves all rows, not something I want to do with a remote server.

I'd like to query a table, and be able to add or delete records, as well as edit data. SQL Management Studio seems to be lacking this feature of Enterprise Manager and Query Analyzer.

If I save a query to an .sql file, I can't add new records. There's got to be a better way.

|||

Can you safely use SQL 2000 client tools (Enterprise Manager/Query Analyzer) with SQL Server 2005? Is that a viable alternative to Management Studio?

|||

Also our DB admins will not be happy when developers use "Open Table" in Management Studio and query all data in tables which has millions of rows.

|||

I can't get the "open table" command to work. Was I suppose to set this function up during install or is it something within SSMS?

|||In SQL Management Studio, just right click a table.|||

Topm,

When I tried doing this I got this error,

"Object reference not set to an instance of an object. (SQLEditors)"

This doesn't tell me anything.

|||I was running SSMS remotely, apparently it doesn't like this. When I remote to the server then run SSMS it works fine.|||

The 'Open Table' command opens a grid with a * 'new row' at the end.
When I enter some data there it says always:

If I link that table from an Access database I can enter new data as it should be.

What is wrong here?

Directly edit table data?

Here is a most basic of questions from a past user of Enterprise Manager where I used to simply connect, hit the database, open the data in table view and voila, edit, add or delete table data when such a thing was needed in a pinch.

I've downloaded and installed MS SQL Server Management Studio and worked with the table structure (columns, field types, etc) but cannot for the life of me figure out how to get my hands on the actual data as I used to so simply!

Help! What am I missing! I searched here as well and found entries noting how to build an application to do such a thing, but surely that functionality hadn't been lost, has it?

alyoung *at* bluemarble *dot* net

Just try right-clicking on the desired table and select "Open Table".|||Oh.My.Gosh. How dumb am I!? If only all life's questions could be answered so easily!

directly deleting sql view

i have created a view. And deleted it directly from the database. using Shift+delete. WIll it affect the tables, which has used in that view?No, data and tables are OK....
Dont worry.... :)

You have to be careful thou on what you do with a database it could be millions of dollars lost for the company or not accounted for.
Get yourself test database or play with Pubs first.

Directions on how to install SQL 2000 not as Windows admin

Can someone point me to the KB article, guide, or white paper on how to inst
all SQL Server 2000 using a Windows account that is not system administrator
for the the server?"Hal" <Hal@.discussions.microsoft.com> wrote in message
news:EE70A9F1-FC92-4381-8428-8D01475E4B7C@.microsoft.com...
> Can someone point me to the KB article, guide, or white paper on how to
install SQL Server 2000 using a Windows account that is not system
administrator for the the server?<
Hmmm, typically you need to have local administrative rights to perform
application installs. Perhaps you could negiotiate, or create (depending on
your position on this ;), a local account that has administrative rights,
use that for the install, then disable the account once SQL Server is
installed.
Steve|||I appreciate the response, but it wasn't helpful.
I am certain Microsoft has produced a guide to setting up a SQL Server 2000
with an account that is not SysAdmin. I want a link to that guide.
If there isn't a guide, then someone should surely write one.
"Steve Thompson" wrote:

> "Hal" <Hal@.discussions.microsoft.com> wrote in message
> news:EE70A9F1-FC92-4381-8428-8D01475E4B7C@.microsoft.com...
> install SQL Server 2000 using a Windows account that is not system
> administrator for the the server?<
> Hmmm, typically you need to have local administrative rights to perform
> application installs. Perhaps you could negiotiate, or create (depending o
n
> your position on this ;), a local account that has administrative rights,
> use that for the install, then disable the account once SQL Server is
> installed.
> Steve
>
>|||Is your question how to install SQL Server from a Windows account that
does not have Windows administrator rights, or is your question how to
install SQL Server so that the Windows user who installed SQL Server
cannot connect to the new SQL Server as SQL Server system administrator,
or is you question something about post-installation SQL Server setup?
I don't think you can do either of the first two, simply because the
installation makes changes to both Windows and SQL Server that should
not be allowed by someone without administrator privileges.
In any case, it would help if you could be more specific about whether
"account" means Windows account, SQL Server account (login), or
something else, whether SysAdmin refers to the SQL Server system
administrator role or something else, and what you mean by "setting up".
Steve Kass
Drew University
Hal wrote:
[vbcol=seagreen]
>I appreciate the response, but it wasn't helpful.
>I am certain Microsoft has produced a guide to setting up a SQL Server 2000
with an account that is not SysAdmin. I want a link to that guide.
>If there isn't a guide, then someone should surely write one.
>"Steve Thompson" wrote:
>
>|||I'm betting the question is "How do I install SQL 2K and configure it so the
Service Account is something besides the Local System or an Admin Account".
If that's the case, create an account you want the service to run with and
then specify that account
during the install. If you've already installed, then go into Enterprise Ma
nager and select the Security Tab. Type in the account info there and click
on OK. SQL with then apply the correct security permissions to that accoun
t. If you do it in the Ser
vices portion of computer manager, the security permissions won't be applied
and the service will not start.
"Steve Kass" wrote:

> Is your question how to install SQL Server from a Windows account that
> does not have Windows administrator rights, or is your question how to
> install SQL Server so that the Windows user who installed SQL Server
> cannot connect to the new SQL Server as SQL Server system administrator,
> or is you question something about post-installation SQL Server setup?
> I don't think you can do either of the first two, simply because the
> installation makes changes to both Windows and SQL Server that should
> not be allowed by someone without administrator privileges.
> In any case, it would help if you could be more specific about whether
> "account" means Windows account, SQL Server account (login), or
> something else, whether SysAdmin refers to the SQL Server system
> administrator role or something else, and what you mean by "setting up".
> Steve Kass
> Drew University
> Hal wrote:
>
>sql

Direction of Chart Axis Labels

Sometimes the chart axis labels are vertical.
Sometimes the chart axis labels are horizontal.
How can I control this?
Thank you in advance.
JerryDid you see this related thread?
http://msdn.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=3f2c6661-5754-4d85-bd41-bf5fdc97a5db&sloc=en-us
In RS 2000, the orientation is determined automatically based on the
available space. Providing additional manual and automatic label modes is
under consideration for a future release.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jerry Nixon" <jerrynixon@.gmail.com> wrote in message
news:36f558cf.0410120839.b124e0@.posting.google.com...
> Sometimes the chart axis labels are vertical.
> Sometimes the chart axis labels are horizontal.
> How can I control this?
> Thank you in advance.
> Jerry

Directing batch pring jobs to a remote printer

Has anyone tried directing batch sql reporting services print jobs to a remote printer? Any tips on how to do this would be appreciated.
Thanks,
John

Take a look at the printer delivery extension that is included with the product.

Directing batch pring jobs to a remote printer

Has anyone tried directing batch sql reporting services print jobs to a remote printer? Any tips on how to do this would be appreciated.
Thanks,
John

Take a look at the printer delivery extension that is included with the product.

DirectCopyXform error when using DTS

I am trying to import data and I receive an error that it failed to copy one table. The error says conversion error: Destination does not allow NULL on column pair 2(source column 'DateUsed' (DBYTYPE_DATE), destination column 'DateUsed'(DBTYPE_DBTIMESTAMP)). I have tried to change the data type for DateUsed to several different types in Access. I am not sure why it is not accepting it. If anyone has any ideas, I would appreciate it. Thanks.Well, for starters, what's the actual SOurce? SQL Server?

What's the Destination? MS Access?

Why not DTS The Source to the Destination and let DTS create an object for you, and see what it defines.

Then comapre the 2.|||The source is actually Access and the destination is SQL server. I used DTS to import data from an Access db and it failed to copy one table because of this date error.|||OK.

What I suggests still stands.

Use DTS and let it create a sql server table and find out what it creates.sql

Direct vs. Indirect Package Configurations

If your XML configuration files will be in the same location on your Development, UAT and PROD servers, is there any merit to making your configurations indirect?

I am modifying the connection string with the XML. My strategy is to set up an XML configuration for each database that we have. The Dev XML config will point to Development connection, UAT to UAT etc..

My thought is that by using the direct configuration it will eliminate the need for environment variables and also allow me to add configs without having to reboot the servers, which you would need to do in order to get server to recongize the EV.

Thanks

There isn't in real advantage to using indirect XML configurations if you're 100% sure that the location of your configuration file is never going to change and be identical in development, staging, and production environments. However, indirect configuration are a huge advantage if the location of your configuration files should change. Our project has over 50 SSIS packages (and growing) and I would hate to be the poor sap that would have to go change and test each and every package should the configuration file location ever was changed.|||

By the way, I wrote a batch configuration changer that you can use to modify the configuration settings in a group of packages. It's available as part of the downloadable samples for my book. A few have used it and saved some time with it.

It's called ConfigBatch.exe.

You can select a set of packages and bulk add, delete, modify configurations within those packages.

|||

Dear Kirk,

I got your book, and downloaded the samples. For the Config utility you included an msi, but the batch utility was a c# project. I don't have c# in my visual studio, could you perhaps mail an msi or .exe?

btw, the book is very readable so far (I'm at chapter 4).

thanks,

John.

Direct vs. Indirect Package Configurations

If your XML configuration files will be in the same location on your Development, UAT and PROD servers, is there any merit to making your configurations indirect?

Thanks

It's called ConfigBatch.exe.

You can select a set of packages and bulk add, delete, modify configurations within those packages.

|||

Dear Kirk,

btw, the book is very readable so far (I'm at chapter 4).

thanks,

John.

Direct vs. Indirect Package Configurations

If your XML configuration files will be in the same location on your Development, UAT and PROD servers, is there any merit to making your configurations indirect?

Thanks

It's called ConfigBatch.exe.

You can select a set of packages and bulk add, delete, modify configurations within those packages.

|||

Dear Kirk,

btw, the book is very readable so far (I'm at chapter 4).

thanks,

John.

direct update

Doing transactional replication, set up with nosync initialization, it
seems to work great, but does not generate and does not use custom SPs
for each input/update/delete.
In the profiler I can see that, after I run a simple "update"
statement on the publisher, the same SQL gets run on the subscriber.
Which parameter of what call is it that determines whether I am using
this "direct update" business, and what are the implications, and
where (if anywhere!) is this discussed in BOL (or elsewhere), cuz I
can't find it!
Thanks.
Joshua Stern
On Mon, 22 Nov 2004 14:27:08 -0800, jxstern <jxstern@.nowhere.com>
wrote:
>Which parameter of what call is it that determines whether I am using
>this "direct update" business, and what are the implications, and
>where (if anywhere!) is this discussed in BOL (or elsewhere), cuz I
>can't find it!
Found it (in my own scripts, of course!)
exec sp_addarticle @.publication = N'myPUB', @.article = N'tbl_foo',
@.source_owner = N'dbo', @.source_object = N'tbl_foo',
@.destination_table = N'tbl_foo',
@.type = N'logbased', @.creation_script = null, @.description = null,
@.pre_creation_cmd = N'drop',
@.schema_option = 0x00000000000000F3, @.status = 0,
@.vertical_partition = N'false',
@.ins_cmd = N'SQL', @.del_cmd = N'SQL', @.upd_cmd = N'SQL',
@.filter = null, @.sync_object = null, @.auto_identity_range = N'false'
Those "@.ins_cmd" and such say "SQL", which echoes the SQL, rather than
use CALL, MCALL, or XCALL. See also BOL section, "Using Custom Stored
Procedures in Articles"
J.

direct report to a folder located at network drive?

Hi,
Can I redirect report to \\server\folder\reports? Thanks for the help.
HenryHi,
It means you want to deploy at this location then it is "NO"
Amarnath
"Henry Chen" wrote:
> Hi,
> Can I redirect report to \\server\folder\reports? Thanks for the help.
> Henry|||Hi, Amarnath,
You know what? I find the answer, and yes it can be done.
Check this link:
http://msdn2.microsoft.com/en-us/library/ms159264.aspx
Note: (share my experience to everyone during my testing of this problem)
1. use standard subscription
2. add an acccount to the file share folder, and that account will be used
in your subscription
3. path in standard subscription is \\server_name\folder_name
4. when you enter your account name, I need to enter abcsit\hchen instead of
just hchen. where abcsit is our company's domain name, hchen is my login
account.
Henry
"Amarnath" wrote:
> Hi,
> It means you want to deploy at this location then it is "NO"
> Amarnath
> "Henry Chen" wrote:
> > Hi,
> > Can I redirect report to \\server\folder\reports? Thanks for the help.
> > Henrysql

Direct Printout of PDF still not possible?

Hi everybody,
I've been doing some research on the problem, that it is not possible to
print out a report in a PDF directly. The "open" or "save" dialogue comes up
first. I did read in some postings that there should be a possibility after
SP2 of the reporting services. By the way, I am using the 2000-Version of
the RS. Still, I can't find a proper solution to send a PDF directly to the
acrobat reader.
Does anyone has a solution to this?
Thx in advance.
Regards
MichaelWhy would you want to do this' View the reports through report manager,
.pdf files surely just makes them unedittable, how can that be helpful
unless you want to present them in an email or something and in that case
you would want to save the reports so you had a back up?
Sorry if i've missed the point but i can't see why you'd want to do this?
bob
"Michael Bender" <technik@.salescom.de> wrote in message
news:dl2776$f5o$02$1@.news.t-online.com...
> Hi everybody,
> I've been doing some research on the problem, that it is not possible to
> print out a report in a PDF directly. The "open" or "save" dialogue comes
> up first. I did read in some postings that there should be a possibility
> after SP2 of the reporting services. By the way, I am using the
> 2000-Version of the RS. Still, I can't find a proper solution to send a
> PDF directly to the acrobat reader.
> Does anyone has a solution to this?
> Thx in advance.
> Regards
> Michael
>

Direct Printing with RS 2005?

I have tried the PrinterDeliverySamples with RS2000 without success. I have
read about new printing functionality with RS 2005. Is direct printing per
subscription to a printer supported wit hthe bnew version or not? Or do they
still just offer those $()Â§$!"& PrinterDevliverySamples?
Thanks.
--
Markus PÃ¶hler
netpoint-edv gmbh
GermanyThere is a printer delivery sample with SQL 2005. (I don't know if it is
like SQL 2k, because I never messed with the 2k one.)
However you compile this, install it, change some config files. AND a
subscriber can choose the printer and print to the printer as part of a
subscription... However, the printer must be defined at the RS IIS box, and
Reporting services must run on a domain account ( not local system)...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"MarkusPoehler" <MarkusPoehler@.discussions.microsoft.com> wrote in message
news:DBF063C1-4D16-4891-A80A-6D9BD070456C@.microsoft.com...
>I have tried the PrinterDeliverySamples with RS2000 without success. I have
> read about new printing functionality with RS 2005. Is direct printing per
> subscription to a printer supported wit hthe bnew version or not? Or do
> they
> still just offer those $()§$!"& PrinterDevliverySamples?
> Thanks.
> --
> Markus Pöhler
> netpoint-edv gmbh
> Germany|||you can run under the local system
or network service accounts if you install the printers under all users and
computers. you'll need to use the rundll32 with the printui to do it, but
there are several script that already do it. you will also need to turn off
the printer validation on the ValidateUserData function in the sample.
Cade Roby
Lead Developer
Wolverine Power Supply Coop.
10125 W. Watergate Ave.
Cadillac, MI 49601
"Wayne Snyder" wrote:
> There is a printer delivery sample with SQL 2005. (I don't know if it is
> like SQL 2k, because I never messed with the 2k one.)
> However you compile this, install it, change some config files. AND a
> subscriber can choose the printer and print to the printer as part of a
> subscription... However, the printer must be defined at the RS IIS box, and
> Reporting services must run on a domain account ( not local system)...
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "MarkusPoehler" <MarkusPoehler@.discussions.microsoft.com> wrote in message
> news:DBF063C1-4D16-4891-A80A-6D9BD070456C@.microsoft.com...
> >I have tried the PrinterDeliverySamples with RS2000 without success. I have
> > read about new printing functionality with RS 2005. Is direct printing per
> > subscription to a printer supported wit hthe bnew version or not? Or do
> > they
> > still just offer those $()Â§$!"& PrinterDevliverySamples?
> >
> > Thanks.
> > --
> >
> > Markus PÃ¶hler
> > netpoint-edv gmbh
> > Germany
>
>

Direct Printing

Hallo,
we have a Windows Application in .Net.
Now we want to use Reporting Services. That is no problem.
But how we can print direct on a client pc?Hi sqlhaas,
You can do this by installing a new printer extension for RS. Take a look
at this article (under Yesterday's QOD):
http://www.sqlservercentral.com/newsletter/452004newsletter.htm
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
sqlhaas wrote:
> Hallo,
> we have a Windows Application in .Net.
> Now we want to use Reporting Services. That is no problem.
> But how we can print direct on a client pc?|||Check Bryan's log http://blogs.msdn.com/bryanke/articles/71491.aspx.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Jake Marx" <msnews@.longhead.com> wrote in message
news:u%23nFdEQvEHA.1988@.TK2MSFTNGP12.phx.gbl...
> Hi sqlhaas,
> You can do this by installing a new printer extension for RS. Take a look
> at this article (under Yesterday's QOD):
> http://www.sqlservercentral.com/newsletter/452004newsletter.htm
> --
> Regards,
> Jake Marx
> MS MVP - Excel
> www.longhead.com
> [please keep replies in the newsgroup - email address unmonitored]
>
> sqlhaas wrote:
> > Hallo,
> > we have a Windows Application in .Net.
> > Now we want to use Reporting Services. That is no problem.
> > But how we can print direct on a client pc?
>

Direct printing

Hi there,
I know there has been a lot of discussions and irritations that RS does not
offer direct printing, instead the user has to export to pdf(or another
format) and then open that and print the report from there, but I would like
to know if it something that Microsoft is working on and if so when it may be
available.
Surely with the amount of interest shown in the printing it will be soon?
ThanksCurrently we are looking at including client side printing in the next
version of SQL. We have heard the cries of pain and are also looking at the
possibility of including it our next service pack. As of this time though we
have made no formal announcement on what will or won't be included in the
next SP.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"PLSH" <PLSH@.discussions.microsoft.com> wrote in message
news:FE9846D1-B924-4FEB-97B2-28C7D720D3AE@.microsoft.com...
> Hi there,
> I know there has been a lot of discussions and irritations that RS does
not
> offer direct printing, instead the user has to export to pdf(or another
> format) and then open that and print the report from there, but I would
like
> to know if it something that Microsoft is working on and if so when it may
be
> available.
> Surely with the amount of interest shown in the printing it will be soon?
> Thanks|||So basically you guys at Microsoft created this great product for viewing
reports and doing great things but figured when someone wants to view it they
surely wouldn't want to print and therefor left that part out . . . . . and
now after all this time still haven't included it? Ok, just wanted to make
sure.
Come on guys your product kicks @.ss, please can we have a way of printing
our reports without having to export them, open them and then print them.
Hopefully someone will come up with a reletively easy way to print soon.
PLEEEEEEASE!!
"Daniel Reib [MSFT]" wrote:
> Currently we are looking at including client side printing in the next
> version of SQL. We have heard the cries of pain and are also looking at the
> possibility of including it our next service pack. As of this time though we
> have made no formal announcement on what will or won't be included in the
> next SP.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "PLSH" <PLSH@.discussions.microsoft.com> wrote in message
> news:FE9846D1-B924-4FEB-97B2-28C7D720D3AE@.microsoft.com...
> > Hi there,
> >
> > I know there has been a lot of discussions and irritations that RS does
> not
> > offer direct printing, instead the user has to export to pdf(or another
> > format) and then open that and print the report from there, but I would
> like
> > to know if it something that Microsoft is working on and if so when it may
> be
> > available.
> >
> > Surely with the amount of interest shown in the printing it will be soon?
> >
> > Thanks
>
>

Direct Print using URL in 2k5

In SRS 00 sp2 we were able to call the printer direct by using the following
URL
http://xxx.xxx.xxx.xxx/ReportServer?%2ffolder%2fReport&Parameter=LAPTOP&rs%3aCommand=Get&rc%3aGetImage=8.00.1038.00RSClientPrint.html
I saw in a previous post where GetImage is no longer available. This URL
was lifted from behind the print button on the report viewer control in SRS00
SP2. However when I grab the URL in 2k5 we have this
ReportViewerWebControl.axd?ReportSession=
Is there a way to fake this report session so I can still direct URL print?
I have seen the previous posts recomend using the report viewer control,
that works great in some cases just not this one. I dont want to show the
report to the user just promt them to print it.
ThanksHey Fred,
I have the exact same requirement to print directly via a URL. Did you
ever find an answer/solution to this issue? Any help or suggestions/links
you can provide would be most appreciated (I have looked high and lo for
answers).
Michael C
"FredG" wrote:
> In SRS 00 sp2 we were able to call the printer direct by using the following
> URL
> http://xxx.xxx.xxx.xxx/ReportServer?%2ffolder%2fReport&Parameter=LAPTOP&rs%3aCommand=Get&rc%3aGetImage=8.00.1038.00RSClientPrint.html
> I saw in a previous post where GetImage is no longer available. This URL
> was lifted from behind the print button on the report viewer control in SRS00
> SP2. However when I grab the URL in 2k5 we have this
> ReportViewerWebControl.axd?ReportSession=> Is there a way to fake this report session so I can still direct URL print?
> I have seen the previous posts recomend using the report viewer control,
> that works great in some cases just not this one. I dont want to show the
> report to the user just promt them to print it.
> Thanks
>sql

Direct print possible?

Is it possible to print a report directly without having to first preview it
using the ReportViewer control?On Apr 10, 2:28 am, georges <geor...@.discussions.microsoft.com> wrote:
> Is it possible to print a report directly without having to first preview it
> using the ReportViewer control?
What .NET language and environment are you using?
In C#, ASP.NET, this should help:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/e82168c08b00ce18/33d2f61564ce1a2a?lnk=st&q=print+reporting+services+in+asp.net&rnum=2#33d2f61564ce1a2a
Regards,
Enrique Martinez
Sr. Software Consultant

Direct print in RS 2000 no longer works in RS 2005 --what's the secret?

Hi all,
I have a Windows Forms application in VS 2005 that displays reports inside a
System.Windows.Forms.WebBrowser. The user can print using the print icon
within the browser window, but I also have a big Print button on the form
that prints directly. Now, with RS 2000, my print button worked fine, I
directed the ActiveX control to directly print like this:
rsBrowser.Navigate(ReportServicesPath & SpecifiedReportURL &
"&rs%3aCommand=Get&rc%3aGetImage=8.00.1038.00RSClientPrint.html")
But, I've now upgraded to SQL 2005 and RS 2005, and this code doesn't work,
although printing via the print icon still works fine. What is the
equivalent of the above code for RS 2005'
The above code puts an error into the browser window:
>>
Reporting Services Error
----
a.. An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help
a.. Specified argument was out of the range of valid values. Parameter
name: offset
<<
I looked at the error log, but it is impenetrable to me.
Thanks,
C17Hello C17,
I understand that you want to use the URL access to print the report.
In Reporting Services 2005, the RC parameter prefix is changed and you
could not use the GetImage now.
I would like to suggest you use the ReportViewer control.
Here is the article for your reference:
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms.report
viewer(VS.80).aspx
Hope this helps.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you. The ReportViewer control looks like a better way to display
reports anyway. I will switch over to it.
--C17|||Hello C17,
If you have any question, pleae feel free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Direct Link to reports

Hi There,

I have recently upgraded to report Server 2005. I used to have a webpage that loaded a number of reports into different frames to give real time statistics for an IT Service Desk.

In the new version if try and link directly to the report (By right clicking a report and taking the link) the report loads with out any of the toolbars etc at the top as i need it, however it does not refresh and seem to be cached data.

Has anyone got any ideas how to resolve this problem, in short all I need is a way to directly view the report losing all the toolbars etc on the top and just displaying the data.

This has been driving me mad so if anyone could help i would be really grateful!

Many thanks

Gerard

YOu can definitely do this but not "by rightclicking on a report and taking the link". That's going to get you the origin of the report invocation in report *manager* (by default, http://<yourserver>/reports) when what you want is the link to the report in the report *server* (by default, that would be http://<yourserver>/reportserver).

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1795172&SiteID=1 .

There is plenty of information on this in the helpfile -- just look for topics that mention "URL Access".

Direct link between a camera and the database.

Where to look for a direct link between
a camera, an application (to be build) and storage
directly in a database.
(Use Identification sized pictures of customers).
Thanks for any pointers.
Ben Brugman
Hi
You may want to look at http://www.aspfaq.com/show.asp?id=2149. The method
of transferring the image to the computer may be dependent on the make of the
camera.
Binary files can be loaded in to the database (if you really want to!) using
the bii example program. As this is a sample you also have the code.
This may also be useful
http://support.microsoft.com/default...b;en-us;317034
http://support.microsoft.com/default...b;en-us;316887
John
"ben brugman" wrote:

> Where to look for a direct link between
> a camera, an application (to be build) and storage
> directly in a database.
> (Use Identification sized pictures of customers).
> Thanks for any pointers.
> Ben Brugman
>
>
sql

Direct link between a camera and the database.

Where to look for a direct link between
a camera, an application (to be build) and storage
directly in a database.
(Use Identification sized pictures of customers).
Thanks for any pointers.
Ben BrugmanHi
You may want to look at http://www.aspfaq.com/show.asp?id=2149. The method
of transferring the image to the computer may be dependent on the make of th
e
camera.
Binary files can be loaded in to the database (if you really want to!) using
the bii example program. As this is a sample you also have the code.
This may also be useful
http://support.microsoft.com/defaul...kb;en-us;317034
http://support.microsoft.com/defaul...kb;en-us;316887
John
"ben brugman" wrote:

> Where to look for a direct link between
> a camera, an application (to be build) and storage
> directly in a database.
> (Use Identification sized pictures of customers).
> Thanks for any pointers.
> Ben Brugman
>
>

Direct link between a camera and the database.

Where to look for a direct link between
a camera, an application (to be build) and storage
directly in a database.
(Use Identification sized pictures of customers).
Thanks for any pointers.
Ben BrugmanHi
You may want to look at http://www.aspfaq.com/show.asp?id=2149. The method
of transferring the image to the computer may be dependent on the make of the
camera.
Binary files can be loaded in to the database (if you really want to!) using
the bii example program. As this is a sample you also have the code.
This may also be useful
http://support.microsoft.com/default.aspx?scid=kb;en-us;317034
http://support.microsoft.com/default.aspx?scid=kb;en-us;316887
John
"ben brugman" wrote:
> Where to look for a direct link between
> a camera, an application (to be build) and storage
> directly in a database.
> (Use Identification sized pictures of customers).
> Thanks for any pointers.
> Ben Brugman
>
>

Direct Interface to SQL server

I did a little bit of looking in the forums for something like this, but I wasn't able to find anything. In essence, I am looking to create a web form in ASP.NET which will emulate the SQL Server Query Analyzer Tool... eventually what I'd like to see:

- A dropdown of different connection strings, to connect to different databases

-A multi-line textbox where a user could type in a query (be it a SELECT, CREATE, UPDATE, or multiple queries at once)

-A gridview object for results

-A multiline textbox to contain server output ("the command completed successfully", "xxx rows returned", "syntax at line 3 not recognized", etc)

I can do the first 3 without any difficulty, but I have absolutely no idea where to start with the server output. Anyone have any ideas? It does not need to be secure, as the only databases they'll have access to will be "test" databases and the pages will not be publicly hosted (LAN only)

Hi,

You need to handle OnInfoMessage event for your connection object. Pleas have a look at this for more information

http://msdn2.microsoft.com/en-us/library/a0hee08w(VS.80).aspx

Regards

|||

That worked beautifully... thank you so very much.

Are there any issues with removing "Shared" from the "protected shared sub " declaration? I had to remove it in order to address the textbox which contained the server messages handled in the event handler.

Direct Display of SQL Image field

I have a SQL 2000 table in which pictures are stored as an Image column. I want to display then onto a c# aspx webpage without storing them to disk.
What is the best way to read and display the pictures?
In classic ASP I used to do this:

Response.ContentType = "image/jpeg"
Response.BinaryWrite rs.fields("ThisImage")

but I can't get this to work in c#.Kinda, you should use a <img src="http://pics.10026.com/?src=viewImage.aspx?id=RecordID"> and then use some code like this below to read the database:


using System;
using System.Collections;
using System.Configuration;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;namespace DBImages
{
 /// <summary>
 /// Summary description for ViewImage.
 /// </summary>
 public class ViewImage : System.Web.UI.Page
 {
 #region Web Form Designer generated code
 override protected void OnInit(EventArgs e)
 {
 //
 // CODEGEN: This call is required by the ASP.NET Web Form Designer.
 //
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void Page_Init(object sender, EventArgs e)
{
InitializeComponent();
}
public ViewImage()
{
Page.Init += new System.EventHandler(Page_Init);
}
private void Page_Load(object sender, System.EventArgs e)
{
if (!Page.IsPostBack)
{
//get the image id from the url
string ImageId =Request.QueryString["img"];
double adjustedSize=Convert.ToDouble(Request.QueryString["size"]);
//build our query statement
string sqlText = "SELECT img_data, img_contenttype FROM Image WHERE img_pk = " + ImageId;
SqlConnection connection = new SqlConnection(ConfigurationSettings.Appsettings["DSN"]);
SqlCommand command = new SqlCommand( sqlText, connection);
//open the database and get a datareader
connection.Open();
SqlDataReader dr;
dr = command.ExecuteReader();
if ( dr.HasRows) //yup we found our image
{
dr.Read();
Response.ContentType = dr["img_contenttype"].ToString();
System.IO.Stream fs=new System.IO.MemoryStream((byte[])dr.GetSqlBinary(0) );
System.Drawing.Image _image=System.Drawing.Image.FromStream( new System.IO.MemoryStream((byte[])dr.GetSqlBinary(0)));
int fileLength, fileWidth, fileHeight;
using(System.Drawing.Image image = System.Drawing.Image.FromStream(fs))
{
fileLength = Convert.ToInt32(fs.Length);
fileWidth = image.Width;
fileHeight = image.Height;
}
double multiplier;
if (fileHeight>fileWidth) // picture must be portrait
{
multiplier=Convert.ToDouble(adjustedSize / fileHeight);
}
else
{
multiplier=Convert.ToDouble(adjustedSize / fileWidth);
}
int newWidth, newHeight;
newWidth=(int)(fileWidth * multiplier);
newHeight=(int)(fileHeight * multiplier);
System.Drawing.Image _newimage=_image.GetThumbnailImage(newWidth,newHeight,null,new System.IntPtr());
_newimage.Save(System.Web.HttpContext.Current.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);
Response.BinaryWrite( (byte[]) dr["img_data"] );
}
connection.Close();
}
}
}
}

I do not comment code. If it was hard to write, it should be hard to read. :) I answer some questions tho.|||Thanks for that

Response.BinaryWrite( (byte[]) dr["img_data"] );

does what I want, and I really appreciate the master class on image manipulation.

Thursday, March 29, 2012

Blog Archive

About Me