Showing posts with label page. Show all posts
Showing posts with label page. Show all posts

Friday, March 23, 2012

Is the SP1 multilingual?

Hi,

Unlike the SQL Server 2005 SP1 download page, the SQL Server 2005 Express SP1 download page (http://msdn.microsoft.com/vstudio/express/sql/download/) and the pages it references don't mention whether the download is english only or multilingual. Since there's no language selection possibility on these pages, I'm assuming it's multilingual. Am I right?

Thanks in advance.

--
Patrick Philippot - Microsoft MVP
MainSoft Consulting Services
www.mainsoft.fr

Hi,

There is a dropdown to choose from:

http://www.microsoft.com/downloads/details.aspx?FamilyID=11350b1f-8f44-4db6-b542-4a4b869c2ff1&DisplayLang=en

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

Thanks very much.

So there are pages where there's a selection dropdown and other pages for teh same download where no selection is possible. Strange.

--
Patrick

Wednesday, March 21, 2012

Is that possible with RS?

Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web application.
The way I'd like it to work is to click a button and launch a page with the
report. I have stored procedures that the reports would use and I'd like to
manually fill a dataset and assign it to the report.
Is that possible?
All examples I see create a report project, a datasource, and the report.
If I do that, first I have to use a dataset for each report, and I can't use
that reports in the web project.
--
Regards,
Diego F.VS 2005 has report controls for both win and web forms. You can use them in
local mode where you give it a report and the dataset. However it is
definitely more work to use them in local mode. If you already have stored
procedure then create a report that uses the stored procedures. Test and
make sure you like it. Then if possible (VB.Net pro is the cheapest version
that has the controls I believe) get the new controls for your app. With the
new controls it is very easy to embed in your application, set the
parameters and away you go.
Otherwise, look at URL integration to call the report from your app.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diego F." <diegofrNO@.terra.es> wrote in message
news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web application.
> The way I'd like it to work is to click a button and launch a page with
> the report. I have stored procedures that the reports would use and I'd
> like to manually fill a dataset and assign it to the report.
> Is that possible?
> All examples I see create a report project, a datasource, and the report.
> If I do that, first I have to use a dataset for each report, and I can't
> use that reports in the web project.
> --
> Regards,
> Diego F.
>
>|||I tried creating a report in a report project, with my stored procedures.
But then, I have problems with deployment; it's unable to connect with the
server. I created a site in the server, but if I put
http://server:port/reportserver/reports in the report project properties,
and the conexion isn't possible.
--
Regards,
Diego F.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
> VS 2005 has report controls for both win and web forms. You can use them
> in local mode where you give it a report and the dataset. However it is
> definitely more work to use them in local mode. If you already have stored
> procedure then create a report that uses the stored procedures. Test and
> make sure you like it. Then if possible (VB.Net pro is the cheapest
> version that has the controls I believe) get the new controls for your
> app. With the new controls it is very easy to embed in your application,
> set the parameters and away you go.
> Otherwise, look at URL integration to call the report from your app.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page with
>> the report. I have stored procedures that the reports would use and I'd
>> like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the report.
>> If I do that, first I have to use a dataset for each report, and I can't
>> use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>|||I'm confused. Have your successfully deployed the report? Can you view the
report with Report Manager? Those two things need to happen before you try
to integrate with your app.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>I tried creating a report in a report project, with my stored procedures.
>But then, I have problems with deployment; it's unable to connect with the
>server. I created a site in the server, but if I put
>http://server:port/reportserver/reports in the report project properties,
>and the conexion isn't possible.
> --
> Regards,
> Diego F.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use them
>> in local mode where you give it a report and the dataset. However it is
>> definitely more work to use them in local mode. If you already have
>> stored procedure then create a report that uses the stored procedures.
>> Test and make sure you like it. Then if possible (VB.Net pro is the
>> cheapest version that has the controls I believe) get the new controls
>> for your app. With the new controls it is very easy to embed in your
>> application, set the parameters and away you go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page with
>> the report. I have stored procedures that the reports would use and I'd
>> like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the
>> report.
>> If I do that, first I have to use a dataset for each report, and I can't
>> use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>>
>|||You don't have to deploy the report from your dev box. Just copy the RDL
file to somewhere where you can add it to your Report Manager site, and add
it to Report Manager by clicking the Upload file button.
You might have to create data sources manually, just click on New Data
Source button. Connect the report to the datasource and test it.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>I tried creating a report in a report project, with my stored procedures.
>But then, I have problems with deployment; it's unable to connect with the
>server. I created a site in the server, but if I put
>http://server:port/reportserver/reports in the report project properties,
>and the conexion isn't possible.
> --
> Regards,
> Diego F.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use them
>> in local mode where you give it a report and the dataset. However it is
>> definitely more work to use them in local mode. If you already have
>> stored procedure then create a report that uses the stored procedures.
>> Test and make sure you like it. Then if possible (VB.Net pro is the
>> cheapest version that has the controls I believe) get the new controls
>> for your app. With the new controls it is very easy to embed in your
>> application, set the parameters and away you go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page with
>> the report. I have stored procedures that the reports would use and I'd
>> like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the
>> report.
>> If I do that, first I have to use a dataset for each report, and I can't
>> use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>>
>|||I'm starting to understand it. My first problem is that I can't see the
Report Manager. Where should I configure it?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:uS55OarEGHA.3820@.TK2MSFTNGP12.phx.gbl...
> You don't have to deploy the report from your dev box. Just copy the RDL
> file to somewhere where you can add it to your Report Manager site, and
> add it to Report Manager by clicking the Upload file button.
> You might have to create data sources manually, just click on New Data
> Source button. Connect the report to the datasource and test it.
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>>I tried creating a report in a report project, with my stored procedures.
>>But then, I have problems with deployment; it's unable to connect with the
>>server. I created a site in the server, but if I put
>>http://server:port/reportserver/reports in the report project properties,
>>and the conexion isn't possible.
>> --
>> Regards,
>> Diego F.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
>> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use them
>> in local mode where you give it a report and the dataset. However it is
>> definitely more work to use them in local mode. If you already have
>> stored procedure then create a report that uses the stored procedures.
>> Test and make sure you like it. Then if possible (VB.Net pro is the
>> cheapest version that has the controls I believe) get the new controls
>> for your app. With the new controls it is very easy to embed in your
>> application, set the parameters and away you go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page with
>> the report. I have stored procedures that the reports would use and I'd
>> like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the
>> report.
>> If I do that, first I have to use a dataset for each report, and I
>> can't use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>|||Assuming it has been installed correctly on a web server, you should be able
to access Report manager at
http://yourwebserver/reports
Also, check for http://yourwebserver/reportserver/
If these websites are unavailable, you need to check what actually got
installed on the server.
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:eTsTb6PFGHA.2444@.TK2MSFTNGP11.phx.gbl...
> I'm starting to understand it. My first problem is that I can't see the
> Report Manager. Where should I configure it?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:uS55OarEGHA.3820@.TK2MSFTNGP12.phx.gbl...
>> You don't have to deploy the report from your dev box. Just copy the RDL
>> file to somewhere where you can add it to your Report Manager site, and
>> add it to Report Manager by clicking the Upload file button.
>> You might have to create data sources manually, just click on New Data
>> Source button. Connect the report to the datasource and test it.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>>I tried creating a report in a report project, with my stored procedures.
>>But then, I have problems with deployment; it's unable to connect with
>>the server. I created a site in the server, but if I put
>>http://server:port/reportserver/reports in the report project properties,
>>and the conexion isn't possible.
>> --
>> Regards,
>> Diego F.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
>> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use
>> them in local mode where you give it a report and the dataset. However
>> it is definitely more work to use them in local mode. If you already
>> have stored procedure then create a report that uses the stored
>> procedures. Test and make sure you like it. Then if possible (VB.Net
>> pro is the cheapest version that has the controls I believe) get the
>> new controls for your app. With the new controls it is very easy to
>> embed in your application, set the parameters and away you go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page
>> with the report. I have stored procedures that the reports would use
>> and I'd like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the
>> report.
>> If I do that, first I have to use a dataset for each report, and I
>> can't use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>|||The problem is that if I write that URL, what I see is the list of
directories in both cases. Shouldn't I see an application?
--
Regards,
Diego F.
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
news:O5VnV9QFGHA.1124@.TK2MSFTNGP10.phx.gbl...
> Assuming it has been installed correctly on a web server, you should be
> able to access Report manager at
> http://yourwebserver/reports
> Also, check for http://yourwebserver/reportserver/
> If these websites are unavailable, you need to check what actually got
> installed on the server.
> Kaisa M. Lindahl
>
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:eTsTb6PFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>> I'm starting to understand it. My first problem is that I can't see the
>> Report Manager. Where should I configure it?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:uS55OarEGHA.3820@.TK2MSFTNGP12.phx.gbl...
>> You don't have to deploy the report from your dev box. Just copy the RDL
>> file to somewhere where you can add it to your Report Manager site, and
>> add it to Report Manager by clicking the Upload file button.
>> You might have to create data sources manually, just click on New Data
>> Source button. Connect the report to the datasource and test it.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>>I tried creating a report in a report project, with my stored
>>procedures. But then, I have problems with deployment; it's unable to
>>connect with the server. I created a site in the server, but if I put
>>http://server:port/reportserver/reports in the report project
>>properties, and the conexion isn't possible.
>> --
>> Regards,
>> Diego F.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
>> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use
>> them in local mode where you give it a report and the dataset. However
>> it is definitely more work to use them in local mode. If you already
>> have stored procedure then create a report that uses the stored
>> procedures. Test and make sure you like it. Then if possible (VB.Net
>> pro is the cheapest version that has the controls I believe) get the
>> new controls for your app. With the new controls it is very easy to
>> embed in your application, set the parameters and away you go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>> application.
>> The way I'd like it to work is to click a button and launch a page
>> with the report. I have stored procedures that the reports would use
>> and I'd like to manually fill a dataset and assign it to the report.
>> Is that possible?
>> All examples I see create a report project, a datasource, and the
>> report.
>> If I do that, first I have to use a dataset for each report, and I
>> can't use that reports in the web project.
>> --
>> Regards,
>> Diego F.
>>
>>
>>
>>
>>
>|||No, the Report Manager is an application, but you won't see it as a sort of
program. Report Manager displays reports with descriptions and some details
in a nice user interface, the ReportServer displays some details in plain
text.
If you do get to see the directories, try uploading a report by pressing the
Upload file button in http://yourserver/reports/
Kaisa M. Lindahl
"Diego F." <diegofrNO@.terra.es> wrote in message
news:%23lUPWAcFGHA.3900@.TK2MSFTNGP10.phx.gbl...
> The problem is that if I write that URL, what I see is the list of
> directories in both cases. Shouldn't I see an application?
> --
> Regards,
> Diego F.
>
> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> news:O5VnV9QFGHA.1124@.TK2MSFTNGP10.phx.gbl...
>> Assuming it has been installed correctly on a web server, you should be
>> able to access Report manager at
>> http://yourwebserver/reports
>> Also, check for http://yourwebserver/reportserver/
>> If these websites are unavailable, you need to check what actually got
>> installed on the server.
>> Kaisa M. Lindahl
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:eTsTb6PFGHA.2444@.TK2MSFTNGP11.phx.gbl...
>> I'm starting to understand it. My first problem is that I can't see the
>> Report Manager. Where should I configure it?
>> --
>> Regards,
>> Diego F.
>>
>> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
>> news:uS55OarEGHA.3820@.TK2MSFTNGP12.phx.gbl...
>> You don't have to deploy the report from your dev box. Just copy the
>> RDL file to somewhere where you can add it to your Report Manager site,
>> and add it to Report Manager by clicking the Upload file button.
>> You might have to create data sources manually, just click on New Data
>> Source button. Connect the report to the datasource and test it.
>> Kaisa M. Lindahl
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>>I tried creating a report in a report project, with my stored
>>procedures. But then, I have problems with deployment; it's unable to
>>connect with the server. I created a site in the server, but if I put
>>http://server:port/reportserver/reports in the report project
>>properties, and the conexion isn't possible.
>> --
>> Regards,
>> Diego F.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
>> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
>> VS 2005 has report controls for both win and web forms. You can use
>> them in local mode where you give it a report and the dataset.
>> However it is definitely more work to use them in local mode. If you
>> already have stored procedure then create a report that uses the
>> stored procedures. Test and make sure you like it. Then if possible
>> (VB.Net pro is the cheapest version that has the controls I believe)
>> get the new controls for your app. With the new controls it is very
>> easy to embed in your application, set the parameters and away you
>> go.
>> Otherwise, look at URL integration to call the report from your app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Diego F." <diegofrNO@.terra.es> wrote in message
>> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
>>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
>>> application.
>>>
>>> The way I'd like it to work is to click a button and launch a page
>>> with the report. I have stored procedures that the reports would use
>>> and I'd like to manually fill a dataset and assign it to the report.
>>>
>>> Is that possible?
>>>
>>> All examples I see create a report project, a datasource, and the
>>> report.
>>>
>>> If I do that, first I have to use a dataset for each report, and I
>>> can't use that reports in the web project.
>>>
>>> --
>>> Regards,
>>>
>>> Diego F.
>>>
>>>
>>>
>>
>>
>>
>>
>>
>|||I thought that I would interject here a little.
We are using SQL Server 2000 / Reporting Services 2000 both on 1.1
framework. Our web server and web development platform is 2.0 framwork with
the web dev being done on vs 2005.
By far the easiest setup we've had so far is to setup the reports on report
server, publish a url. Then populate a table with two fields; report
discritpion and url field.
From that we have setup a navigation component from the web server and
linked it to the url table.
What this does is break the dev of reports and the web interface apart so
that they can be managed more effectively. As soon as the SQL dev produces a
new report or a change he populates the table with the new info and it is
immediately on the web site for consumers to view.
Ken...
"Kaisa M. Lindahl" wrote:
> No, the Report Manager is an application, but you won't see it as a sort of
> program. Report Manager displays reports with descriptions and some details
> in a nice user interface, the ReportServer displays some details in plain
> text.
> If you do get to see the directories, try uploading a report by pressing the
> Upload file button in http://yourserver/reports/
> Kaisa M. Lindahl
> "Diego F." <diegofrNO@.terra.es> wrote in message
> news:%23lUPWAcFGHA.3900@.TK2MSFTNGP10.phx.gbl...
> > The problem is that if I write that URL, what I see is the list of
> > directories in both cases. Shouldn't I see an application?
> >
> > --
> > Regards,
> >
> > Diego F.
> >
> >
> > "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> > news:O5VnV9QFGHA.1124@.TK2MSFTNGP10.phx.gbl...
> >> Assuming it has been installed correctly on a web server, you should be
> >> able to access Report manager at
> >>
> >> http://yourwebserver/reports
> >>
> >> Also, check for http://yourwebserver/reportserver/
> >>
> >> If these websites are unavailable, you need to check what actually got
> >> installed on the server.
> >>
> >> Kaisa M. Lindahl
> >>
> >>
> >> "Diego F." <diegofrNO@.terra.es> wrote in message
> >> news:eTsTb6PFGHA.2444@.TK2MSFTNGP11.phx.gbl...
> >> I'm starting to understand it. My first problem is that I can't see the
> >> Report Manager. Where should I configure it?
> >>
> >> --
> >> Regards,
> >>
> >> Diego F.
> >>
> >>
> >> "Kaisa M. Lindahl" <kaisaml@.hotmail.com> escribió en el mensaje
> >> news:uS55OarEGHA.3820@.TK2MSFTNGP12.phx.gbl...
> >> You don't have to deploy the report from your dev box. Just copy the
> >> RDL file to somewhere where you can add it to your Report Manager site,
> >> and add it to Report Manager by clicking the Upload file button.
> >> You might have to create data sources manually, just click on New Data
> >> Source button. Connect the report to the datasource and test it.
> >>
> >> Kaisa M. Lindahl
> >>
> >> "Diego F." <diegofrNO@.terra.es> wrote in message
> >> news:%23I0rHJhEGHA.1736@.TK2MSFTNGP14.phx.gbl...
> >>I tried creating a report in a report project, with my stored
> >>procedures. But then, I have problems with deployment; it's unable to
> >>connect with the server. I created a site in the server, but if I put
> >>http://server:port/reportserver/reports in the report project
> >>properties, and the conexion isn't possible.
> >>
> >> --
> >> Regards,
> >>
> >> Diego F.
> >>
> >>
> >> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> escribió en el mensaje
> >> news:uvfMW$gEGHA.2072@.TK2MSFTNGP10.phx.gbl...
> >> VS 2005 has report controls for both win and web forms. You can use
> >> them in local mode where you give it a report and the dataset.
> >> However it is definitely more work to use them in local mode. If you
> >> already have stored procedure then create a report that uses the
> >> stored procedures. Test and make sure you like it. Then if possible
> >> (VB.Net pro is the cheapest version that has the controls I believe)
> >> get the new controls for your app. With the new controls it is very
> >> easy to embed in your application, set the parameters and away you
> >> go.
> >>
> >> Otherwise, look at URL integration to call the report from your app.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Diego F." <diegofrNO@.terra.es> wrote in message
> >> news:OPy%23rueEGHA.1736@.TK2MSFTNGP14.phx.gbl...
> >>> Hi. I need to integrate RS2005 in an existing ASP.NET 2.0 web
> >>> application.
> >>>
> >>> The way I'd like it to work is to click a button and launch a page
> >>> with the report. I have stored procedures that the reports would use
> >>> and I'd like to manually fill a dataset and assign it to the report.
> >>>
> >>> Is that possible?
> >>>
> >>> All examples I see create a report project, a datasource, and the
> >>> report.
> >>>
> >>> If I do that, first I have to use a dataset for each report, and I
> >>> can't use that reports in the web project.
> >>>
> >>> --
> >>> Regards,
> >>>
> >>> Diego F.
> >>>
> >>>
> >>>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
>
>sql

Friday, March 9, 2012

is sql 2005 based on imdb (in-memory database)?

Hi guys, i need a page at microsoft that says it, it's for a technical
proposal, until now i've just found oracle's timesten, i've searched at
google and microsoft but i have not results about.
Also i need to know if it supports journaling.
Regards.
I guess we would need to see the definitions of "in memory database" (that can mean a lot of things)
and journaling. If you mean what I think you mean, then the answer is no on both questions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
> Hi guys, i need a page at microsoft that says it, it's for a technical proposal, until now i've
> just found oracle's timesten, i've searched at google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
>
|||Rick wrote:
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
What feature are you looking for? SQL Server does cache data
"in-memory" but if you are looking for a deployable database engine or
one for embeddable systems then look at SQL Server Express or Mobile
Edition
"Journaling" could mean Differential or Transaction Log backups or
Versioning or Snapshots in SQL Server - depends on what your definition
of Journaling is.
SQL Server 2005 Features Comparison:
http://www.microsoft.com/sql/prodinf...-features.mspx
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||ok, well journaling is logging all transactions, and if SQL has it then is
ok
Definition of: in-memory database
A database that keeps all active records in main memory rather than on disk.
Accessing in-memory records is considerably faster than retrieving them from
the disk.
"Rick" <elmargaro@.hotmail.com> escribi en el mensaje
news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
>
|||Yes, SQL Server logs all modifications in the transaction log.
SQL Server has a fairly sophisticated cache handling mechanism, but it essentially means that hot
pages will be cached (in memory).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl...
> ok, well journaling is logging all transactions, and if SQL has it then is ok
> Definition of: in-memory database
> A database that keeps all active records in main memory rather than on disk. Accessing in-memory
> records is considerably faster than retrieving them from the disk.
>
> "Rick" <elmargaro@.hotmail.com> escribi en el mensaje
> news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
>
|||Thanks a lot!!!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribi
en el mensaje news:%235f7kPLTGHA.1572@.tk2msftngp13.phx.gbl...
> Yes, SQL Server logs all modifications in the transaction log.
> SQL Server has a fairly sophisticated cache handling mechanism, but it
> essentially means that hot pages will be cached (in memory).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Rick" <elmargaro@.hotmail.com> wrote in message
> news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl...
>

is sql 2005 based on imdb (in-memory database)?

Hi guys, i need a page at microsoft that says it, it's for a technical
proposal, until now i've just found oracle's timesten, i've searched at
google and microsoft but i have not results about.
Also i need to know if it supports journaling.
Regards.I guess we would need to see the definitions of "in memory database" (that c
an mean a lot of things)
and journaling. If you mean what I think you mean, then the answer is no on
both questions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl..
.
> Hi guys, i need a page at microsoft that says it, it's for a technical pro
posal, until now i've
> just found oracle's timesten, i've searched at google and microsoft but i
have not results about.
> Also i need to know if it supports journaling.
> Regards.
>|||Rick wrote:
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
What feature are you looking for? SQL Server does cache data
"in-memory" but if you are looking for a deployable database engine or
one for embeddable systems then look at SQL Server Express or Mobile
Edition
"Journaling" could mean Differential or Transaction Log backups or
Versioning or Snapshots in SQL Server - depends on what your definition
of Journaling is.
SQL Server 2005 Features Comparison:
http://www.microsoft.com/sql/prodin...e-features.mspx
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||ok, well journaling is logging all transactions, and if SQL has it then is
ok
Definition of: in-memory database
A database that keeps all active records in main memory rather than on disk.
Accessing in-memory records is considerably faster than retrieving them from
the disk.
"Rick" <elmargaro@.hotmail.com> escribi en el mensaje
news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
>|||Yes, SQL Server logs all modifications in the transaction log.
SQL Server has a fairly sophisticated cache handling mechanism, but it essen
tially means that hot
pages will be cached (in memory).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl..
.
> ok, well journaling is logging all transactions, and if SQL has it then is
ok
> Definition of: in-memory database
> A database that keeps all active records in main memory rather than on dis
k. Accessing in-memory
> records is considerably faster than retrieving them from the disk.
>
> "Rick" <elmargaro@.hotmail.com> escribi en el mensaje
> news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
>|||Thanks a lot!!!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribi
en el mensaje news:%235f7kPLTGHA.1572@.tk2msftngp13.phx.gbl...
> Yes, SQL Server logs all modifications in the transaction log.
> SQL Server has a fairly sophisticated cache handling mechanism, but it
> essentially means that hot pages will be cached (in memory).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Rick" <elmargaro@.hotmail.com> wrote in message
> news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl...
>

is sql 2005 based on imdb (in-memory database)?

Hi guys, i need a page at microsoft that says it, it's for a technical
proposal, until now i've just found oracle's timesten, i've searched at
google and microsoft but i have not results about.
Also i need to know if it supports journaling.
Regards.I guess we would need to see the definitions of "in memory database" (that can mean a lot of things)
and journaling. If you mean what I think you mean, then the answer is no on both questions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
> Hi guys, i need a page at microsoft that says it, it's for a technical proposal, until now i've
> just found oracle's timesten, i've searched at google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
>|||Rick wrote:
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
What feature are you looking for? SQL Server does cache data
"in-memory" but if you are looking for a deployable database engine or
one for embeddable systems then look at SQL Server Express or Mobile
Edition
"Journaling" could mean Differential or Transaction Log backups or
Versioning or Snapshots in SQL Server - depends on what your definition
of Journaling is.
SQL Server 2005 Features Comparison:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||ok, well journaling is logging all transactions, and if SQL has it then is
ok
Definition of: in-memory database
A database that keeps all active records in main memory rather than on disk.
Accessing in-memory records is considerably faster than retrieving them from
the disk.
"Rick" <elmargaro@.hotmail.com> escribió en el mensaje
news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
> Hi guys, i need a page at microsoft that says it, it's for a technical
> proposal, until now i've just found oracle's timesten, i've searched at
> google and microsoft but i have not results about.
> Also i need to know if it supports journaling.
> Regards.
>|||Yes, SQL Server logs all modifications in the transaction log.
SQL Server has a fairly sophisticated cache handling mechanism, but it essentially means that hot
pages will be cached (in memory).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Rick" <elmargaro@.hotmail.com> wrote in message news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl...
> ok, well journaling is logging all transactions, and if SQL has it then is ok
> Definition of: in-memory database
> A database that keeps all active records in main memory rather than on disk. Accessing in-memory
> records is considerably faster than retrieving them from the disk.
>
> "Rick" <elmargaro@.hotmail.com> escribió en el mensaje
> news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
>> Hi guys, i need a page at microsoft that says it, it's for a technical proposal, until now i've
>> just found oracle's timesten, i've searched at google and microsoft but i have not results about.
>> Also i need to know if it supports journaling.
>> Regards.
>|||Thanks a lot!!!
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> escribió
en el mensaje news:%235f7kPLTGHA.1572@.tk2msftngp13.phx.gbl...
> Yes, SQL Server logs all modifications in the transaction log.
> SQL Server has a fairly sophisticated cache handling mechanism, but it
> essentially means that hot pages will be cached (in memory).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "Rick" <elmargaro@.hotmail.com> wrote in message
> news:uURgArGTGHA.4920@.tk2msftngp13.phx.gbl...
>> ok, well journaling is logging all transactions, and if SQL has it then
>> is ok
>> Definition of: in-memory database
>> A database that keeps all active records in main memory rather than on
>> disk. Accessing in-memory records is considerably faster than retrieving
>> them from the disk.
>>
>> "Rick" <elmargaro@.hotmail.com> escribió en el mensaje
>> news:uJsRs1ETGHA.5156@.TK2MSFTNGP10.phx.gbl...
>> Hi guys, i need a page at microsoft that says it, it's for a technical
>> proposal, until now i've just found oracle's timesten, i've searched at
>> google and microsoft but i have not results about.
>> Also i need to know if it supports journaling.
>> Regards.
>>
>