Is there a quick way to convert Xml into a Table?

Hello,

I have an Xml column containing some Xml downloaded off the web (which comes from a Sql Server 2000 FOR XML query). I want to quickly convert the Xml back into a table with the relevant columns. Is there a quick way to do this?

Many thanks!

Ben S.

SELECT ncol.value('@.someAttrib')

,ncol.value('../@.AttribOfParent')

FROM yourtable

CROSS APPLY yourtable.yourxmlcolumn.nodes('/xPathThatLeads/toWhatYouWant/') AS T(ncol)

This is the a quick way to shred your xml data back to relational data

|||

I did it this way in the end (using SQL Server 2005):

DECLARE @.xmlDoc XML, @.xmlDocHandle INT

--Get xml off the web and put it into the @.xmlDoc variable here

EXEC sp_xml_preparedocument @.xmlDocHandle OUTPUT, @.xmlDoc;

SELECT * INTO #temp_table FROM OPENXML(@.xmlDocHandle, N'/root/element', 2) WITH myTable;

EXEC sp_xml_removedocument @.xmlDocHandle;

This will put the contents of the @.xmlDoc variable into the #temp_table provided the xml matches the structure of the existing myTable table. The '/root/element' bit discribes the xml elements you want to put into the table. Eg.

<root>
<element>
<id>1</id>
<name>Fred Smith</name>
</element>
<element>
<id>2</id>
<name>Joe Bloggs</name>
</element>
</root>

The above example will return two records assuming myTable has id and name columns.

Hope this helps other people.

Is there a quick way to convert Xml into a Table?

Hello,

I have an Xml column containing some Xml downloaded off the web (which comes from a Sql Server 2000 FOR XML query). I want to quickly convert the Xml back into a table with the relevant columns. Is there a quick way to do this?

Many thanks!

Ben S.

SELECT ncol.value('@.someAttrib')

,ncol.value('../@.AttribOfParent')

FROM yourtable

CROSS APPLY yourtable.yourxmlcolumn.nodes('/xPathThatLeads/toWhatYouWant/') AS T(ncol)

This is the a quick way to shred your xml data back to relational data

|||

I did it this way in the end (using SQL Server 2005):

DECLARE @.xmlDoc XML, @.xmlDocHandle INT

--Get xml off the web and put it into the @.xmlDoc variable here

EXEC sp_xml_preparedocument @.xmlDocHandle OUTPUT, @.xmlDoc;

SELECT * INTO #temp_table FROM OPENXML(@.xmlDocHandle, N'/root/element', 2) WITH myTable;

EXEC sp_xml_removedocument @.xmlDocHandle;

This will put the contents of the @.xmlDoc variable into the #temp_table provided the xml matches the structure of the existing myTable table. The '/root/element' bit discribes the xml elements you want to put into the table. Eg.

<root>
<element>
<id>1</id>
<name>Fred Smith</name>
</element>
<element>
<id>2</id>
<name>Joe Bloggs</name>
</element>
</root>

The above example will return two records assuming myTable has id and name columns.

Hope this helps other people.

sql

Is there a limit to # of databases I can run on MSDE?

Hi,
We want to host several web sites that use MSDE as backend. I have two
questions:
1. Is there a limit to # of databases we can have in one instance of MSDE?
2. The # of simultaneous connections limit applies to an instance of MSDE
not a database in it. Is this correct?
Some web hosters provide MSDE as standard DB option. Do they run one MSDE on
the server and have multiple databases in it or do they run multiple
instances of MSDE?
We will run a full blown SQL Server but in phase 1, we want to start w/ MSDE
for obvious reasons -- cost.
Thanks,
Sam
SQL Server and MSDE have a limit of 32767 databases per server instance.
There is no limit on the number of connections to MSDE, but there is a
governor on the number of simultaneous batch threads. You'll run out of
physical memory resources long before you reach these limits.
Jim
"Sam" <sam@.globalwebcentral.com> wrote in message
news:%23XsTl5vAFHA.3616@.TK2MSFTNGP11.phx.gbl...
> Hi,
> We want to host several web sites that use MSDE as backend. I have two
> questions:
> 1. Is there a limit to # of databases we can have in one instance of MSDE?
> 2. The # of simultaneous connections limit applies to an instance of MSDE
> not a database in it. Is this correct?
> Some web hosters provide MSDE as standard DB option. Do they run one MSDE
> on the server and have multiple databases in it or do they run multiple
> instances of MSDE?
> We will run a full blown SQL Server but in phase 1, we want to start w/
> MSDE for obvious reasons -- cost.
> Thanks,
> Sam
>
|||hi Sam,
Sam wrote:
> Hi,
> We want to host several web sites that use MSDE as backend. I have two
> questions:
> 1. Is there a limit to # of databases we can have in one instance of
> MSDE?
MSDE, as long as SQL Server, has a limit 32767 of databases per
instance...

> 2. The # of simultaneous connections limit applies to an instance of
> MSDE not a database in it. Is this correct?
there's no connections limits directly related to MSDE, as it shares the
same max value as SQL Server, 32767 connections (but this value is
symbolic, as each connection requires some memory and, counting the 2gb of
RAM limitation of MSDE, you will get memory troubles long before that; but a
built-in Workloads Governor will kick in at 8 concurrent defined batches
(you can inspect them and have an idea about it at
http://msdn.microsoft.com/library/?u...asp?frame=true )
...
the Workloads Governor is per instance and not per database..

> Some web hosters provide MSDE as standard DB option. Do they run one
> MSDE on the server and have multiple databases in it or do they run
> multiple instances of MSDE?
you have to ask them for that answer..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Jim,
Thanks for your response. I'm a little confused so I'd appreciate further
clarification. You tell me that I'll run out of memory long before I reach
these limits.
If I have one instance of MSDE running on our web application server that
will host 27 ASP.NET applications which will require 27 databases in MSDE,
wouldn't I run into issues if I have moderate traffic on these sites.
Obviously, moderate traffic is a pretty subjective term. But everything
these applications do require a database read and/or write.
So if I understand you correctly, the limitation is not for the number of
connections but number of batch threads. From the other post, I understand
that the number is actually 8 batch threads. In simplistic terms, wouldn't
that mean, 8 simultaneous users who require database read/write? In our
case, I know that everytime the user hits the site, it triggers multiple
database lookups. So that number could even be less than 8 simultaneous
users.
I know about caching and everything else. But I'm trying to keep it at a
basic level which is number of simulatenous database read/writes.
I'd appreciate your feedback. Thanks.
Sam
"Jim Young" <thorium48@.hotmail.com> wrote in message
news:O964HTwAFHA.1188@.tk2msftngp13.phx.gbl...
> SQL Server and MSDE have a limit of 32767 databases per server instance.
> There is no limit on the number of connections to MSDE, but there is a
> governor on the number of simultaneous batch threads. You'll run out of
> physical memory resources long before you reach these limits.
> Jim
> "Sam" <sam@.globalwebcentral.com> wrote in message
> news:%23XsTl5vAFHA.3616@.TK2MSFTNGP11.phx.gbl...
>
|||On Tue, 25 Jan 2005 14:50:57 -0500, Sam wrote:

>Jim,
>Thanks for your response. I'm a little confused so I'd appreciate further
>clarification. You tell me that I'll run out of memory long before I reach
>these limits.
>If I have one instance of MSDE running on our web application server that
>will host 27 ASP.NET applications which will require 27 databases in MSDE,
>wouldn't I run into issues if I have moderate traffic on these sites.
Hi Sam,
That depends. What is the running time of a typical query? What is the
typical running time of a "long" running query and how often will these
queries be carried out? Is access to the various databases spread over the
day, or do you have notable peaks?
As an example: let's say that typical database use consists of simple,
fast running queries, taking 0.2 seconds to execute on average. If each of
the 27 databases gets to execute 1500 of these queries per hour, the total
execution time needed is 1500 * 27 * 0.2 seconds = 8100 seconds. Since
there are 3600 seconds per hour, the average number of workloads (active
connections) will be 2.25. This is within the limits of MSDE - but only if
all queries are spread evenly over the day. If all your customers decide
that right after lunch is the perfect moment to catch up with a whole
day's worth of business, you'll have no workloads from 2PM to 1PM the next
day, and 27 workloads on average from 1PM to 2PM - now, you'll see the
workload governor kicking in.
Let's take it one step further. Suppose each database also has some
reporting procedure that runs 4 minutes, and is executed once per hour.
The total processing time for 27 of these reports is 27 * 4 = 108 minutes,
causing (if spread evenly over the day) an average number of 1.8
workloads. Add those to the 2.25 workloads for regular use and we're at a
total of 4 workloads constantly active - very near the workload governor
threshold. Every time a few customer happen to submit the reporting
procedure at the same time, that activity plus the regular short-running
queries will surpass the limit. The workload governor will kick in,
causing things to slow down. The procedures will start to take longer (6
minutes - 8 minutes - maybe even 12) and since they are active longer,
there's a good chance that yet more customers will sybmit the reporting
procedure before the others are finished, causing the number of workloads
to exceed the limit even more, so that the workload governor will throttle
performance even further. And you'll see the whole thing coming spiralling
down.
In short: try to get good estimates about running times of queries, the
number of times queries are executed and make sure that you know when to
expect peaks and how high these peaks get. Base your calculation on the
workload during peaks. If you're not sure that MSDE can handle the load,
better get the full product. I know it's not cheap - but in the long run,
losing business as a result of workload governor induced delays will cost
you more.

>Obviously, moderate traffic is a pretty subjective term. But everything
>these applications do require a database read and/or write.
>So if I understand you correctly, the limitation is not for the number of
>connections but number of batch threads. From the other post, I understand
>that the number is actually 8 batch threads.
The correct term is "workloads". The maximum number of workloads allowed
before the workload governor interferes is 8, but you'll often see the
number 5 as well. That's because MSDE requires a total of three workloads
for it's housekeeping - these are always active, completely beyond your
control. This reduces the total of 8 workloads to 5 that are actuially
available for you to use.

> In simplistic terms, wouldn't
>that mean, 8 simultaneous users who require database read/write?
No. It's not that simple (as you can see above). The typical user of a
database spends much of his/her time reading information from the screen
or typing information onto the screen. The connection to the database
usually remains active, but the connection is in a sleeping mode - this is
not a workload. It becomes a workload from the moment the user clicks
"Save", "Search" or "Show" - until the moment the found rows are listed,
the changes have been committed or the details are displayed.

> In our
>case, I know that everytime the user hits the site, it triggers multiple
>database lookups. So that number could even be less than 8 simultaneous
>users.
Does your ASP.NET application use asynchronous execution to submit several
queries at the same time? If so, then you are right, that one user's
action can cause more than one simlutaneous workload. On the other hand,
if execution is synchronous, than 1 user will not cause more than 1
workload.

>I know about caching and everything else. But I'm trying to keep it at a
>basic level which is number of simulatenous database read/writes.
Caching is irrelevant here. The only effect of caching is to speed up
queries. And since MSDE automatically manages it's cache, you don't need
to worry about this.
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)
|||Hugo,
Thank you very much for your explanation. I really appreciate people like
yourself who are thorough in everything they do. That's a wonderful quality.
Again, thank you very much for your help.
Sam
"Hugo Kornelis" <hugo@.pe_NO_rFact.in_SPAM_fo> wrote in message
news:nchdv09g2gfu5hiqd9ev8miraqpeacc11f@.4ax.com...
> On Tue, 25 Jan 2005 14:50:57 -0500, Sam wrote:
>
> Hi Sam,
> That depends. What is the running time of a typical query? What is the
> typical running time of a "long" running query and how often will these
> queries be carried out? Is access to the various databases spread over the
> day, or do you have notable peaks?
> As an example: let's say that typical database use consists of simple,
> fast running queries, taking 0.2 seconds to execute on average. If each of
> the 27 databases gets to execute 1500 of these queries per hour, the total
> execution time needed is 1500 * 27 * 0.2 seconds = 8100 seconds. Since
> there are 3600 seconds per hour, the average number of workloads (active
> connections) will be 2.25. This is within the limits of MSDE - but only if
> all queries are spread evenly over the day. If all your customers decide
> that right after lunch is the perfect moment to catch up with a whole
> day's worth of business, you'll have no workloads from 2PM to 1PM the next
> day, and 27 workloads on average from 1PM to 2PM - now, you'll see the
> workload governor kicking in.
> Let's take it one step further. Suppose each database also has some
> reporting procedure that runs 4 minutes, and is executed once per hour.
> The total processing time for 27 of these reports is 27 * 4 = 108 minutes,
> causing (if spread evenly over the day) an average number of 1.8
> workloads. Add those to the 2.25 workloads for regular use and we're at a
> total of 4 workloads constantly active - very near the workload governor
> threshold. Every time a few customer happen to submit the reporting
> procedure at the same time, that activity plus the regular short-running
> queries will surpass the limit. The workload governor will kick in,
> causing things to slow down. The procedures will start to take longer (6
> minutes - 8 minutes - maybe even 12) and since they are active longer,
> there's a good chance that yet more customers will sybmit the reporting
> procedure before the others are finished, causing the number of workloads
> to exceed the limit even more, so that the workload governor will throttle
> performance even further. And you'll see the whole thing coming spiralling
> down.
> In short: try to get good estimates about running times of queries, the
> number of times queries are executed and make sure that you know when to
> expect peaks and how high these peaks get. Base your calculation on the
> workload during peaks. If you're not sure that MSDE can handle the load,
> better get the full product. I know it's not cheap - but in the long run,
> losing business as a result of workload governor induced delays will cost
> you more.
>
> The correct term is "workloads". The maximum number of workloads allowed
> before the workload governor interferes is 8, but you'll often see the
> number 5 as well. That's because MSDE requires a total of three workloads
> for it's housekeeping - these are always active, completely beyond your
> control. This reduces the total of 8 workloads to 5 that are actuially
> available for you to use.
>
> No. It's not that simple (as you can see above). The typical user of a
> database spends much of his/her time reading information from the screen
> or typing information onto the screen. The connection to the database
> usually remains active, but the connection is in a sleeping mode - this is
> not a workload. It becomes a workload from the moment the user clicks
> "Save", "Search" or "Show" - until the moment the found rows are listed,
> the changes have been committed or the details are displayed.
>
> Does your ASP.NET application use asynchronous execution to submit several
> queries at the same time? If so, then you are right, that one user's
> action can cause more than one simlutaneous workload. On the other hand,
> if execution is synchronous, than 1 user will not cause more than 1
> workload.
>
> Caching is irrelevant here. The only effect of caching is to speed up
> queries. And since MSDE automatically manages it's cache, you don't need
> to worry about this.
> Best, Hugo
> --
> (Remove _NO_ and _SPAM_ to get my e-mail address)

Is there a free Web Service for the weather, and/or mapping

I'm looking to embed the weather report or mapping into a RS report.
First of all, is this possible? Secondly, do you know of any free web
services for travelers - weather, mapping, anything else of interest to
travelers?
Also, these reports are being stored on the client, not a report server.
I appreciate your response!
Shane
--
Thank You!On Sat, 8 Oct 2005 11:25:29 -0700, "Shane Eckel"
<ShaneEckel@.discussions.microsoft.com> wrote:
>I'm looking to embed the weather report or mapping into a RS report.
>First of all, is this possible? Secondly, do you know of any free web
>services for travelers - weather, mapping, anything else of interest to
>travelers?
>Also, these reports are being stored on the client, not a report server.
>I appreciate your response!
>Shane
Shane,
I don't know the answer to your question but it might help you to get
an answer if you provide an indication of the geographical area you
are interested in.
Global weather? Some specific locality or localities?
Andrew Watt
MVP - InfoPath|||Sorry, I need it for the US and Canada. If I could get the weather for major
cities or for the airports, that would be great.
The second part, mapping, would be great for the US and Canada to be able to
place multiple plotting points on a map within a report.
Thanks again.
Shane
Seattle, WA
--
Thank You!
"Andrew Watt [MVP - InfoPath]" wrote:
> On Sat, 8 Oct 2005 11:25:29 -0700, "Shane Eckel"
> <ShaneEckel@.discussions.microsoft.com> wrote:
> >I'm looking to embed the weather report or mapping into a RS report.
> >
> >First of all, is this possible? Secondly, do you know of any free web
> >services for travelers - weather, mapping, anything else of interest to
> >travelers?
> >
> >Also, these reports are being stored on the client, not a report server.
> >
> >I appreciate your response!
> >
> >Shane
> Shane,
> I don't know the answer to your question but it might help you to get
> an answer if you provide an indication of the geographical area you
> are interested in.
> Global weather? Some specific locality or localities?
> Andrew Watt
> MVP - InfoPath
>sql

Is there a free ms sql host?

I am looking for a free ms sql database for my programs, but i don't want to host it on my computer, because my web host does not allow servers to be run and people connecting to thme.

SQL Express is free to download and use...but you would have to find your own host for it...

http://msdn2.microsoft.com/en-us/sql/aa336346.aspx

Is there a equivalent tool to Oracle HTML DB for SQL Server

Oracle have released a free download to enable non-developers without
application development experience to quickly build professional web
enabled applications.
The tool oracle as released for download at this URL:
http://www.oracle.com/technology/products/database/application_express/index.html
is there a similar tool for SQL Server from Microsoft. Apparently,
Oracle features even case studies where customers have rapidly built
even planning and budgetting applications with the Oracle HTML DB.
I know a much primitive tool to Oracle HTML DB was available a while
ago for SQL Server called web matrix but now that as disappeared. I am
keen to see a similar tool for SQL Server to rapidly build web
applications.
Thanks
KarenHi,
I used before CodeCharge (www.yessoftware.com) and now Adenin Solutions
(www.adenin.com).
Regards, Marco
KarenM schreef:
> Oracle have released a free download to enable non-developers without
> application development experience to quickly build professional web
> enabled applications.
> The tool oracle as released for download at this URL:
> http://www.oracle.com/technology/products/database/application_express/index.html
>
> is there a similar tool for SQL Server from Microsoft. Apparently,
> Oracle features even case studies where customers have rapidly built
> even planning and budgetting applications with the Oracle HTML DB.
> I know a much primitive tool to Oracle HTML DB was available a while
> ago for SQL Server called web matrix but now that as disappeared. I am
> keen to see a similar tool for SQL Server to rapidly build web
> applications.
> Thanks
> Karen|||Thanks for the pointers I have already looked at the Visual web express
but still it needs coding. If you look at the Oracle Express I got a
evaluation userid and uploaded some of my spreadsheet databases I
maintain my catalog of DVDs, Music CDs and books into the Oracle
database without one line of coding and now I can securely sign on to
this web site and maintain all my information not only that it as all
fancy reporting components built in like gauge, charts,etc all from a
web browser user interface. All this does not need even one line of
coding. I tried it myself.
The development tools themselves are all web based. Oracle is pitching
it at companies to get rid of Access and Excel databases and store data
in a central & secure location with the Oracle Application Express. I
want to do the same with SQL Server provide tools that empower the end
users to setup their own applications all based on the web. This will
make it attractive for users maintaining Access databases and
spreadsheets causing all kinds of chaos to move into a centralised
managed environment but still have all the flexibility they wanted.
Cheers
Karen|||Hi,
I know Oracle is pushing Portals and use it as one frontend for all
your business needs.
But if you are using Word, Excel you want one platform where you can
store all your information structured and non structured. With WebDav
this nis very easy just save your word doc and it is automatic in the
folder in your portal. Can this be more easy no upload just works as
you used before and look at the great Application Builder. It is even
easier than Access to make solution and automatic webbased, incl.
reporting!
Demo:
http://demo.dynamicintranet.com/adenin/diHome.asp
Register for your free trial:
http://demo.dynamicintranet.com/adenin/diHome.asp
Regards, Marco
www.gmsbv.nl - your information worker company !
KarenM schreef:
> Thanks for the pointers I have already looked at the Visual web express
> but still it needs coding. If you look at the Oracle Express I got a
> evaluation userid and uploaded some of my spreadsheet databases I
> maintain my catalog of DVDs, Music CDs and books into the Oracle
> database without one line of coding and now I can securely sign on to
> this web site and maintain all my information not only that it as all
> fancy reporting components built in like gauge, charts,etc all from a
> web browser user interface. All this does not need even one line of
> coding. I tried it myself.
> The development tools themselves are all web based. Oracle is pitching
> it at companies to get rid of Access and Excel databases and store data
> in a central & secure location with the Oracle Application Express. I
> want to do the same with SQL Server provide tools that empower the end
> users to setup their own applications all based on the web. This will
> make it attractive for users maintaining Access databases and
> spreadsheets causing all kinds of chaos to move into a centralised
> managed environment but still have all the flexibility they wanted.
> Cheers
> Karen|||Marco
Today IT managers are trying to reduce the number of vendors Microsoft,
Oracle
and IBM are the shortlist of the software vendors. We want a solution
for
SQL from Microsoft besides we do not want to use Access and Excel to
store data
if it is structured data it must reside in SQL and have a good web
based
tool to build data capture and reporting on it which end users can do
it. I
would say Microsoft must even extend this to Analysis Services to be
able to
store data into Analysis Services and do reporting of analysis Services
all from a web frontend. To me it does not sound rocket science Oracle
have
already built the web application express which end users or business
analysts
can customise and deploy a enterprise wide solution.
What I am referring to in the Oracle Application Express is a great
simple
and very effective web enablement solution for the relational database
it almost
does the same thing what Access provides a simple mechanim to capture
and report
on data except unlike Access it does not have scalability, security &
deployment
issues. With companies running SQL Server extensively I was wondering
if there is
a similar tool like Oracle application express for SQL Server the
Oracle app express
as everything to build small or large transaction/data capture systems
and report
on the data and secure the application and still leave the data on a
secure
backend systems than having spreadsheets and access databases all over
the place.
Appears so far I have not heard that such a similar tool exists for SQL
Server
perhaps we will wait until Microsoft builds a similar SQL Server Web
Application
Express or something like that :)-
Thanks
Karen
Marco wrote:
> Hi,
> I know Oracle is pushing Portals and use it as one frontend for all
> your business needs.
> But if you are using Word, Excel you want one platform where you can
> store all your information structured and non structured. With WebDav
> this nis very easy just save your word doc and it is automatic in the
> folder in your portal. Can this be more easy no upload just works as
> you used before and look at the great Application Builder. It is even
> easier than Access to make solution and automatic webbased, incl.
> reporting!
> Demo:
> http://demo.dynamicintranet.com/adenin/diHome.asp
> Register for your free trial:
> http://demo.dynamicintranet.com/adenin/diHome.asp
> Regards, Marco
> www.gmsbv.nl - your information worker company !
> KarenM schreef:
> > Thanks for the pointers I have already looked at the Visual web express
> > but still it needs coding. If you look at the Oracle Express I got a
> > evaluation userid and uploaded some of my spreadsheet databases I
> > maintain my catalog of DVDs, Music CDs and books into the Oracle
> > database without one line of coding and now I can securely sign on to
> > this web site and maintain all my information not only that it as all
> > fancy reporting components built in like gauge, charts,etc all from a
> > web browser user interface. All this does not need even one line of
> > coding. I tried it myself.
> >
> > The development tools themselves are all web based. Oracle is pitching
> > it at companies to get rid of Access and Excel databases and store data
> > in a central & secure location with the Oracle Application Express. I
> > want to do the same with SQL Server provide tools that empower the end
> > users to setup their own applications all based on the web. This will
> > make it attractive for users maintaining Access databases and
> > spreadsheets causing all kinds of chaos to move into a centralised
> > managed environment but still have all the flexibility they wanted.
> >
> > Cheers
> > Karensql

Is the workgroup edition suitable for a web application?

Hi,
well, the title says it all already. Are there any technical
limitations that could prevent using the WG edition with asp.net?
Oh, and are there licensing limitations (is it even allowed to run the
WG edition in a web server environment) ?Hi,
Here, you can find info about SQL Server 2005 Workgroup Edition:
http://www.microsoft.com/sql/editions/workgroup/default.mspx
Here, you can find info about SQL Server 2005 Edition comparison:
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Ekrem Önsoy
<PSiegmann@.mail.nu> wrote in message
news:1188925296.970273.139890@.50g2000hsm.googlegroups.com...
> Hi,
> well, the title says it all already. Are there any technical
> limitations that could prevent using the WG edition with asp.net?
> Oh, and are there licensing limitations (is it even allowed to run the
> WG edition in a web server environment) ?
>

Is the DB ruled out?

Since late last night, the 5 web servers which are load balanced and
connected to my db have been dying. In an effort to troubleshoot, I have:
1; Verified no deadlocking/ blocking.
2; Verified no high cpu/ memory/ or disk activity.
3; Nothing in the Event View or SQL Error Logs.
4: (Already posted this one, but it may be relevant:)
Im looking at the duration in a particluar proc in profiler and Im looking
at 40 - 70 seconds. I take the line from profiler, pop it into query
analyzer, clear the cache, run it, and it returns in 0 -1 seconds. I can do
this 100% of the time.
So, how do I rule out (or in) the DB and Server?
sql2k sp3a
TIA, ChrisRare you queries running on the client side or are they in stored
procedures on the server side?|||are you queries running on the client side or are they in stored
procedures on the server side?|||The clients are calling stored procs.
"GlennThomas5" <glennthomas5@.gmail.com> wrote in message
news:1123256866.604632.142880@.o13g2000cwo.googlegroups.com...
> are you queries running on the client side or are they in stored
> procedures on the server side?
>|||sounds like it could be the page or app that is receiving the data
then. what kinda app are you populating?

Is the DB ruled out?

Since late last night, the 5 web servers which are load balanced and
connected to my db have been dying. In an effort to troubleshoot, I have:
1; Verified no deadlocking/ blocking.
2; Verified no high cpu/ memory/ or disk activity.
3; Nothing in the Event View or SQL Error Logs.
4: (Already posted this one, but it may be relevant
Im looking at the duration in a particluar proc in profiler and Im looking
at 40 - 70 seconds. I take the line from profiler, pop it into query
analyzer, clear the cache, run it, and it returns in 0 -1 seconds. I can do
this 100% of the time.
So, how do I rule out (or in) the DB and Server?
sql2k sp3a
TIA, ChrisR
are you queries running on the client side or are they in stored
procedures on the server side?
|||are you queries running on the client side or are they in stored
procedures on the server side?
|||The clients are calling stored procs.
"GlennThomas5" <glennthomas5@.gmail.com> wrote in message
news:1123256866.604632.142880@.o13g2000cwo.googlegr oups.com...
> are you queries running on the client side or are they in stored
> procedures on the server side?
>
|||sounds like it could be the page or app that is receiving the data
then. what kinda app are you populating?

Is the DB ruled out?

Since late last night, the 5 web servers which are load balanced and
connected to my db have been dying. In an effort to troubleshoot, I have:
1; Verified no deadlocking/ blocking.
2; Verified no high cpu/ memory/ or disk activity.
3; Nothing in the Event View or SQL Error Logs.
4: (Already posted this one, but it may be relevant
Im looking at the duration in a particluar proc in profiler and Im looking
at 40 - 70 seconds. I take the line from profiler, pop it into query
analyzer, clear the cache, run it, and it returns in 0 -1 seconds. I can do
this 100% of the time.
So, how do I rule out (or in) the DB and Server?
sql2k sp3a
TIA, ChrisRare you queries running on the client side or are they in stored
procedures on the server side?|||are you queries running on the client side or are they in stored
procedures on the server side?|||The clients are calling stored procs.
"GlennThomas5" <glennthomas5@.gmail.com> wrote in message
news:1123256866.604632.142880@.o13g2000cwo.googlegroups.com...
> are you queries running on the client side or are they in stored
> procedures on the server side?
>|||sounds like it could be the page or app that is receiving the data
then. what kinda app are you populating?

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

Is that possible from live website sql record to " intranet " database ?

hi.

I would wish to know whether it is possible for me to program the code from html or aspx ( from web hosting server ) to our office intranet database which is window server 2005?

I had tried to google for more info but there are too complicated thing for me to understand.

Actually i am doing the web form feedback form from the website for the public to fill in and submit. i am using the mysql from web server to store the records from the feedback form.

We have another database in our server, ms server 2005 to store records in the intranet office only. i need to get the records from mysql to intranet database. i don`t think there is a automated scripting which allow u to auto update the intranet database from mysql( web server )

So i thought of one thing . program html or aspx to insert records directly to our database intranet . but how ?

I appreciated that.

Regards

newbie on aspnet.

You can do it by

Add a web service to your remote server to expose your table.|||Add a web service to your remote server to expose your table.Lock the web service site to only respond to the expternal IP address of your of your office.Write an application to consume the web service and update the internal table.|||

>But i think it is better to program aspx to insert records to intranetdatabase directly. or any alternate ? All database software are alreadyfixed, no change.

For the web application to be able to write directly to the local database will require opening up your firewall - this is not a good idea as it opens up the possibility of your intranet database being hacked. The solution I suggested requires only the HTTP and HTTPS ports to be opened. As the data is being dragged in rather than being pushed in, it is much more secure.

>All database software are already fixed, no change.
If the table is a pure log (records are only added), then the required information may already be be present. You would need to provide your table creation scripts for me to comment further.

Is SP command quicker than recordset?

Hi,
I have a web site that uses ASP. I want to know if a record exists for
a specific date. I will be doing this 30 times for each refresh of the
page.
What I've setup is a simple SP that takes a date as an input and
returns a count.
CREATE PROCEDURE spGetNumber
(
@.Date smalldatetime
)
AS
SET NOCOUNT ON
DECLARE @.Count tinyint
SELECT @.Count = COUNT(ID) FROM Race WHERE Date=@.Date
RETURN @.Count
--
In my ASP, I'm calling a command object.
It seems pretty fast, but I only have 100 records in the table, 1 user
at a time. In the future I expect 100's of users and 10,000's of
records.
Is this the best method?
thx,
Bodihi bodi
u can continue using the SP. it is advisible to contact the database only
once from the ASP page instead of contacting 30 times
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"BodiKlamph@.gmail.com" wrote:

> Hi,
> I have a web site that uses ASP. I want to know if a record exists for
> a specific date. I will be doing this 30 times for each refresh of the
> page.
> What I've setup is a simple SP that takes a date as an input and
> returns a count.
> --
> CREATE PROCEDURE spGetNumber
> (
> @.Date smalldatetime
> )
> AS
> SET NOCOUNT ON
> DECLARE @.Count tinyint
> SELECT @.Count = COUNT(ID) FROM Race WHERE Date=@.Date
> RETURN @.Count
> --
> In my ASP, I'm calling a command object.
> It seems pretty fast, but I only have 100 records in the table, 1 user
> at a time. In the future I expect 100's of users and 10,000's of
> records.
> Is this the best method?
> thx,
> Bodi
>|||On 7 Aug 2005 11:18:46 -0700, BodiKlamph@.gmail.com wrote:

>Hi,
>I have a web site that uses ASP. I want to know if a record exists for
>a specific date. I will be doing this 30 times for each refresh of the
>page.
Hi Bodi,
Issuing 30 consecutive calls is not a good idea. If the sole purpose is
to find the dates for which no row exists, rewrite the stored procedure
to take two parameters (starting and ending date) and return a resultset
of all dates for which no rows exist.

>What I've setup is a simple SP that takes a date as an input and
>returns a count.
Another thing: if you only need to verify existence, use EXISTS, not
COUNT. A query with COUNT will always continue until all matching rows
are found. A query with EXISTS will stop after the first matching row.

>It seems pretty fast, but I only have 100 records in the table, 1 user
>at a time. In the future I expect 100's of users and 10,000's of
>records.
10,000's of rows is not very much for SQL Server, but still - why incur
extra overhead that can easily be avoided.

>Is this the best method?
The best method involves a calendar table. If you don't have one yet in
your database, go ahead and create it now. Instructions for making a
calendar table and many examples of how you can use one are at this
site: http://www.aspfaq.com/show.asp?id=2519.
Remember that you only need to create the calendar table once! Just
don't forget to add some new rows every year or two.
Once you have a calendar table, you can find the dates without row in
your Race table with the following stored procedure:
CREATE PROC FindDatesWithoutRowInRace
(@.StartDate datetime,
@.EndDate datetime)
AS
SELECT c.dt
FROM dbo.Calendar AS c
WHERE c.dt >= @.StartDate
AND c.dt <= @.EndDate
AND NOT EXISTS
(SELECT *
FROM Race AS r
WHERE e.[Date] = c.dt)
go
The final step would be to change the calling code to issue one call
with two parameters, then fetch and process the rows returned by the
stored procedure.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||A couple things in addition to Chandra's and Hugo's posts...
The return value from an SP is intended to be a success/failure indicator,
like a windows app - returning non-zero indicates failure, so when you get a
count > 0 and return it you're indicating that the SP failed.
If you want a count of matching records you should use an output parameter;
if you simply want to test for existance you should use EXISTS like Hugo
said, and set the output BIT to 1...
Another note, with COUNT - generally you want to use COUNT(*) not
COUNT([field_name]) because then SQL can optimize to use the best index
rather than have to use an index or constraint (assuming one exists) with th
e
specified field.
I'm going to go out on a limb and guess that you're trying to display a
calendar, hence the 30 calls per request. For this scenario you should retur
n
records that fall in a specific date range:
SELECT DISTINCT [date]
FROM [table_owner].Race
WHERE [date] BETWEEN @.lo_date AND @.hi_date
Then populate the calendar from the recordset in your ASP. Rememebr that
datetime includes time, so if you want records thru the end of the last date
specified then you'll have to be sure either all dates in the table have
00:00:00.000 for the time portion or @.lo_date has time 00:00:00.000 and
@.hi_date has time 23:59:59.997.
Be sure your command objkect's type is set to stored procedure, not text
query, for fastest execution.
Good luck, - KH
"BodiKlamph@.gmail.com" wrote:

> Hi,
> I have a web site that uses ASP. I want to know if a record exists for
> a specific date. I will be doing this 30 times for each refresh of the
> page.
> What I've setup is a simple SP that takes a date as an input and
> returns a count.
> --
> CREATE PROCEDURE spGetNumber
> (
> @.Date smalldatetime
> )
> AS
> SET NOCOUNT ON
> DECLARE @.Count tinyint
> SELECT @.Count = COUNT(ID) FROM Race WHERE Date=@.Date
> RETURN @.Count
> --
> In my ASP, I'm calling a command object.
> It seems pretty fast, but I only have 100 records in the table, 1 user
> at a time. In the future I expect 100's of users and 10,000's of
> records.
> Is this the best method?
> thx,
> Bodi
>|||As above...
But think in terms of SETS of data.
What is the ideal SET of data that the web application could get - KH has
already suggested "the set of dates where there are no races". This may not
be ideal for your real needs, but is definitely a substantial improvement on
making multiple calls that s out many times singular Yes / No answers -
which aren't sets at all, they are simple questions.
- Tim
<BodiKlamph@.gmail.com> wrote in message
news:1123438726.697862.102120@.g43g2000cwa.googlegroups.com...
> Hi,
> I have a web site that uses ASP. I want to know if a record exists for
> a specific date. I will be doing this 30 times for each refresh of the
> page.
> What I've setup is a simple SP that takes a date as an input and
> returns a count.
> --
> CREATE PROCEDURE spGetNumber
> (
> @.Date smalldatetime
> )
> AS
> SET NOCOUNT ON
> DECLARE @.Count tinyint
> SELECT @.Count = COUNT(ID) FROM Race WHERE Date=@.Date
> RETURN @.Count
> --
> In my ASP, I'm calling a command object.
> It seems pretty fast, but I only have 100 records in the table, 1 user
> at a time. In the future I expect 100's of users and 10,000's of
> records.
> Is this the best method?
> thx,
> Bodi
>|||In addition to the already mentioned ideas:
If you are always making exactly 30 calls, do the different values of date
have a relationship to one another?
For example, using a resultset instead of the return output:
SELECT sum (case when date = @.date then 1 else 0 end) as first,
sum(case when date = dateadd(minute,-1,@.date) then 1 else 0 end)
as second
...
sum(case when date = dateadd(minute,N-1,@.date) then 1 else 0 end)
as Nth
FROM race
WHERE date between @.date and dateadd(minute,N-1,@.date)
or something along these lines and it will probably be faster. Even doing
thirty parms and then putting the thirty sums would likely be better because
of networkIO type stuff.
----
Louis Davidson - http://spaces.msn.com/members/drsql/
SQL Server MVP
<BodiKlamph@.gmail.com> wrote in message
news:1123438726.697862.102120@.g43g2000cwa.googlegroups.com...
> Hi,
> I have a web site that uses ASP. I want to know if a record exists for
> a specific date. I will be doing this 30 times for each refresh of the
> page.
> What I've setup is a simple SP that takes a date as an input and
> returns a count.
> --
> CREATE PROCEDURE spGetNumber
> (
> @.Date smalldatetime
> )
> AS
> SET NOCOUNT ON
> DECLARE @.Count tinyint
> SELECT @.Count = COUNT(ID) FROM Race WHERE Date=@.Date
> RETURN @.Count
> --
> In my ASP, I'm calling a command object.
> It seems pretty fast, but I only have 100 records in the table, 1 user
> at a time. In the future I expect 100's of users and 10,000's of
> records.
> Is this the best method?
> thx,
> Bodi
>|||thx Hugo, your answer seems to best suite my needs.
Yes, 30 calls is quite bad. Returning a recordset with just hte valid
dates is a much better idea. then i can loop in my asp code and add
only the valid calendar days.
question? wut's up with the calendar table you mentioned; why would I
need that?
Can't I just do:
SELECT DISTINCT [Date] FROM myTable WHERE [Date] >= startDate and
[Date] <= endDate
that would return only the valid dates|||K, I finished making the changes.
2 questions.
I have a loop that writes out my calendar days (part of an ASP calendar
class). For each day, i want to see if there is a corresponding record
in the resultset I do this by an inefficeint (tha'ts why i'm here)
recordset.find method. I have to search from record 1 each time tho
This is probaly the wrong group now, since it's more ADO than SQL, but
I'll give it a host since you're already familiar with my question.
I was using set rs = cmd.execute, but it compalined that my recordset
was forward only. So I cahnged it form a SP to a simple recordset.open
(using dbopendynamic so i could use the .find method).
I was thinking it may be easier to use GetRows() then loop through the
much less bulky array. Not sure how I'd do this yet, but I can think
of something...unless there is already a set way of doing this?
thx,
Bodi|||lol
at this point I'm just talking to myself.
I used the GetString method, with a row deliminator of comma
then, instead of .find, I did:
if instr(rsDays, "," & DAY(DateString) & ",")
works like a charm, and i imagine it's way faster to do a string check
then it is a .find
thx everybody|||On 8 Aug 2005 21:13:48 -0700, BodiKlamph@.gmail.com wrote:

>thx Hugo, your answer seems to best suite my needs.
>Yes, 30 calls is quite bad. Returning a recordset with just hte valid
>dates is a much better idea. then i can loop in my asp code and add
>only the valid calendar days.
>question? wut's up with the calendar table you mentioned; why would I
>need that?
>Can't I just do:
>SELECT DISTINCT [Date] FROM myTable WHERE [Date] >= startDate and
>[Date] <= endDate
>that would return only the valid dates
Hi Bodi,
I must have misunderstood you earlier. I thought you wanted to find the
dates that are not yet in your table. The query above will do the
reverse: find the dates that are (at least once) in the table.
But do remember that a datetime column includes a time part as well. If
you don't ensure that the time part is the same for all entries, the
query above might return the same date several times, since the DISTINCT
will look at the time part as well.
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)

Is MSDE supported by Microsoft SQL Server 2000 driver for JDBC?

I have J2EE web application, that uses Datasources, which works fine with SQL
Server 2000 Developer Edition running on Windows 2000 Server but I am having
issues with running the same code against MSDE version of SQL Server 2000
running locally on Windows XP Professional.
Is MSDE version of SQL server supported by Microsoft SQL Server 2000 driver
forJDBC?
The release notes says:
The following versions of SQL Server will be supported for use with the SQL
Server 2000 Driver for JDBC SP2:
? SQL Server 2000 Standard and Enterprise Editions*
? SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
higher*
? SQL Server 2000 Enterprise Edition (64-bit)*
MSDE should act the same as any other flavor of SQL 2000 with the exception
of a few well documented limitations. Likely, you have not enabled Network
protocals?
Also, the docs you reference below sound very old. SQL needs to be at SP3 or
3A. Any current download of MSDE will be at the 3A SP level.
-Andrew
"Kris" <Kris@.discussions.microsoft.com> wrote in message
news:AC61CEC6-2D96-418E-810B-E59F8B87356B@.microsoft.com...
> I have J2EE web application, that uses Datasources, which works fine with
SQL
> Server 2000 Developer Edition running on Windows 2000 Server but I am
having
> issues with running the same code against MSDE version of SQL Server 2000
> running locally on Windows XP Professional.
> Is MSDE version of SQL server supported by Microsoft SQL Server 2000
driver
> forJDBC?
> The release notes says:
> The following versions of SQL Server will be supported for use with the
SQL
> Server 2000 Driver for JDBC SP2:
> . SQL Server 2000 Standard and Enterprise Editions*
> . SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
> higher*
> . SQL Server 2000 Enterprise Edition (64-bit)*

Is MSDE supported by Microsoft SQL Server 2000 driver for JDBC

I have J2EE web application, that uses Datasources, which works fine with SQL
Server 2000 Developer Edition running on Windows 2000 Server but I am having
issues with the same code running locally on Windows XP Professional against
MSDE version of SQL Server 2000.
Is MSDE version of SQL server supported by Microsoft SQL Server 2000 driver
forJDBC?
The release notes says:
The following versions of SQL Server will be supported for use with the SQL
Server 2000 Driver for JDBC SP2:
? SQL Server 2000 Standard and Enterprise Editions*
? SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
higher*
? SQL Server 2000 Enterprise Edition (64-bit)*
Do you have specifics on the issues? For instance, could it be your Windows
Firewall? If it is on, it must be configured to allow traffic (locally) on
ports 1433 (TCP) and 1434 (UDP). I don't know any specifics about the JDBC
drivers, other than make sure that you have the same SQL Server SP
(preferably SP3/SP3a) and check your MDAC version against the other
machine's.
"Kris" <Kris@.discussions.microsoft.com> wrote in message
news:A3942A4E-398A-48FA-B363-A4D392E2ECBB@.microsoft.com...
>I have J2EE web application, that uses Datasources, which works fine with
>SQL
> Server 2000 Developer Edition running on Windows 2000 Server but I am
> having
> issues with the same code running locally on Windows XP Professional
> against
> MSDE version of SQL Server 2000.
> Is MSDE version of SQL server supported by Microsoft SQL Server 2000
> driver
> forJDBC?
> The release notes says:
> The following versions of SQL Server will be supported for use with the
> SQL
> Server 2000 Driver for JDBC SP2:
> . SQL Server 2000 Standard and Enterprise Editions*
> . SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
> higher*
> . SQL Server 2000 Enterprise Edition (64-bit)*

Is MSDE supported by Microsoft SQL Server 2000 driver for JDBC

I have J2EE web application, that uses Datasources, which works fine with SQ
L
Server 2000 Developer Edition running on Windows 2000 Server but I am having
issues with the same code running locally on Windows XP Professional against
MSDE version of SQL Server 2000.
Is MSDE version of SQL server supported by Microsoft SQL Server 2000 driver
forJDBC?
The release notes says:
The following versions of SQL Server will be supported for use with the SQL
Server 2000 Driver for JDBC SP2:
? SQL Server 2000 Standard and Enterprise Editions*
? SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
higher*
? SQL Server 2000 Enterprise Edition (64-bit)*Do you have specifics on the issues? For instance, could it be your Windows
Firewall? If it is on, it must be configured to allow traffic (locally) on
ports 1433 (TCP) and 1434 (UDP). I don't know any specifics about the JDBC
drivers, other than make sure that you have the same SQL Server SP
(preferably SP3/SP3a) and check your MDAC version against the other
machine's.
"Kris" <Kris@.discussions.microsoft.com> wrote in message
news:A3942A4E-398A-48FA-B363-A4D392E2ECBB@.microsoft.com...
>I have J2EE web application, that uses Datasources, which works fine with
>SQL
> Server 2000 Developer Edition running on Windows 2000 Server but I am
> having
> issues with the same code running locally on Windows XP Professional
> against
> MSDE version of SQL Server 2000.
> Is MSDE version of SQL server supported by Microsoft SQL Server 2000
> driver
> forJDBC?
> The release notes says:
> The following versions of SQL Server will be supported for use with the
> SQL
> Server 2000 Driver for JDBC SP2:
> . SQL Server 2000 Standard and Enterprise Editions*
> . SQL Server 2000 Standard and Enterprise Editions with Service Pack 1 or
> higher*
> . SQL Server 2000 Enterprise Edition (64-bit)*