Bulk Upload

I need to upload multiple reports produced on another server. Is there a
script or utility that will allow me to do this?
Thanks!On Jul 3, 10:58 am, REI <R...@.discussions.microsoft.com> wrote:
> I need to upload multiple reports produced on another server. Is there a
> script or utility that will allow me to do this?
> Thanks!
There is not a quick way to do it; however, this link might give you
some insight.
http://technet.microsoft.com/en-us/library/ms159720.aspx
Regards,
Enrique Martinez
Sr. Software Consultantsql

Building reports ?

The databases I have in the SQL Server 2000 and i need to use
reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
want to just have connection to my databases in 2000 without restoring
the db's in the 2005. Can i build the reports using SSRS 2005? If yes
then what steps do i need to know to start building RS reports besides
connecting to SR2000 db?
Thanks.On Jun 20, 12:55 pm, GGill <G...@.discussions.microsoft.com> wrote:
> The databases I have in the SQL Server 2000 and i need to use
> reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
> want to just have connection to my databases in 2000 without restoring
> the db's in the 2005. Can i build the reports using SSRS 2005? If yes
> then what steps do i need to know to start building RS reports besides
> connecting to SR2000 db?
> Thanks.
When you make the reports, link them to the SQL Server 2000 server.
I've never had any problem pulling data from the older servers. You
would add the connection string the same way you would with the 2005
version. You can even make shared datasources. I just tested it, yep
it works. Just make a shared datasource and use that for all your
reports. It will link to the specified server/database as needed.
Hope that helps.|||Thank you.
"Ayman" wrote:
> On Jun 20, 12:55 pm, GGill <G...@.discussions.microsoft.com> wrote:
> > The databases I have in the SQL Server 2000 and i need to use
> > reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
> > want to just have connection to my databases in 2000 without restoring
> > the db's in the 2005. Can i build the reports using SSRS 2005? If yes
> > then what steps do i need to know to start building RS reports besides
> > connecting to SR2000 db?
> >
> > Thanks.
> When you make the reports, link them to the SQL Server 2000 server.
> I've never had any problem pulling data from the older servers. You
> would add the connection string the same way you would with the 2005
> version. You can even make shared datasources. I just tested it, yep
> it works. Just make a shared datasource and use that for all your
> reports. It will link to the specified server/database as needed.
> Hope that helps.
>|||When i linked from SSRS2005 to SS2000 .
Should i go first to the Reporting Services Configuration? If yes then
when i go to Reporting Services Configuration it is asking me to select from
drop-down box instance name but my instance name is disabled. How can i
enable that?
If i do not need to do that then after conecting to server should i just
start creating project and designing the new reports from Visual Studio 2005?
"GGill" wrote:
> Thank you.
> "Ayman" wrote:
> > On Jun 20, 12:55 pm, GGill <G...@.discussions.microsoft.com> wrote:
> > > The databases I have in the SQL Server 2000 and i need to use
> > > reporting services in the SQL Server 2005. If i am in SQL Server 2005 and i
> > > want to just have connection to my databases in 2000 without restoring
> > > the db's in the 2005. Can i build the reports using SSRS 2005? If yes
> > > then what steps do i need to know to start building RS reports besides
> > > connecting to SR2000 db?
> > >
> > > Thanks.
> >
> > When you make the reports, link them to the SQL Server 2000 server.
> > I've never had any problem pulling data from the older servers. You
> > would add the connection string the same way you would with the 2005
> > version. You can even make shared datasources. I just tested it, yep
> > it works. Just make a shared datasource and use that for all your
> > reports. It will link to the specified server/database as needed.
> > Hope that helps.
> >
> >

Building out sums inside of a table (SSRS 2000)

Hi all,
I am converting some Crystal reports... and replacing formulas which
are automatically grouped in Crystal. Essentially, I am comparing two
different date ranges, and need to be able to know how many items were
shipped for each customer/item combination within each date range.
I have created calculated fields to hold the quantity shipped if that
row falls in the appropriate date range... this just adds the quantity
shipped in the field if it falls within the appropriate date range.
Qty2ShipPD1=IIF(( Parameters!startInvoicePD1.Value< Fields!
inv_dt.Value AND Parameters!EndInvoicePD1.Value> Fields!inv_dt.Value),
Fields!qty_to_ship.Value,0.0)
and
Qty2ShipPD2=IIF(( Parameters!startInvoicePD2.Value< Fields!
inv_dt.Value AND Parameters!EndInvoicePD2.Value> Fields!inv_dt.Value),
Fields!qty_to_ship.Value,0.0)
I need to build out a table that looks close to the following example:
Cust No
Item No Total for the Period
{need total quantity here}
PD1 {Qty2ShipPD1}
PD2 {Qty2ShipPD2}
I created a matrix control and dragged cus_no, item_no into the rows,
with item_no in the columns, and then summed the Qty2ShipPD1 in the
Details...
This works, in the sense that I am actually getting grouped
information which is correct for the customer/item combinations...
But the format won't work, and I have no idea how to do the same thing
in a table. Every time I do it in a table, I just get the same,
entire sum for the entire query for the two calculated fields.
Help?
THANKS!
JoshAlternatively - is there a way I can use a Matrix Control with only 1
column? If so, I might be able to live with that.
Thanks,
Josh
On Apr 23, 5:57 pm, rumplyminz <squa...@.gmail.com> wrote:
> Hi all,
> I am converting some Crystal reports... and replacing formulas which
> are automatically grouped in Crystal. Essentially, I am comparing two
> different date ranges, and need to be able to know how many items were
> shipped for each customer/item combination within each date range.
> I have created calculated fields to hold the quantity shipped if that
> row falls in the appropriate date range... this just adds the quantity
> shipped in the field if it falls within the appropriate date range.
> Qty2ShipPD1=IIF(( Parameters!startInvoicePD1.Value< Fields!
> inv_dt.Value AND Parameters!EndInvoicePD1.Value> Fields!inv_dt.Value),
> Fields!qty_to_ship.Value,0.0)
> and
> Qty2ShipPD2=IIF(( Parameters!startInvoicePD2.Value< Fields!
> inv_dt.Value AND Parameters!EndInvoicePD2.Value> Fields!inv_dt.Value),
> Fields!qty_to_ship.Value,0.0)
> I need to build out a table that looks close to the following example:
> Cust No
> Item No Total for the Period
> {need total quantity here}
> PD1 {Qty2ShipPD1}
> PD2 {Qty2ShipPD2}
> I created a matrix control and dragged cus_no, item_no into the rows,
> with item_no in the columns, and then summed the Qty2ShipPD1 in the
> Details...
> This works, in the sense that I am actually getting grouped
> information which is correct for the customer/item combinations...
> But the format won't work, and I have no idea how to do the same thing
> in a table. Every time I do it in a table, I just get the same,
> entire sum for the entire query for the two calculated fields.
> Help?
> THANKS!
> Josh|||Doh! Got it.
In my
Sum statement, I was referencing the entire dataset, and not just the
group. I just didn't know I could reference the group.
*This* works...
=Sum(Fields!qty_to_ship.Value, "table1_Group1")
*This does not (well, it gives me values for the entire dataset)
=Sum(Fields!qty_to_ship.Value, "devdbds")
FYI. Hopefully this will help someone else.
THANKS
On Apr 24, 9:44 am, rumplyminz <squa...@.gmail.com> wrote:
> Alternatively - is there a way I can use a Matrix Control with only 1
> column? If so, I might be able to live with that.
> Thanks,
> Josh
> On Apr 23, 5:57 pm, rumplyminz <squa...@.gmail.com> wrote:
> > Hi all,
> > I am converting some Crystal reports... and replacing formulas which
> > are automatically grouped in Crystal. Essentially, I am comparing two
> > different date ranges, and need to be able to know how many items were
> > shipped for each customer/item combination within each date range.
> > I have created calculated fields to hold the quantity shipped if that
> > row falls in the appropriate date range... this just adds the quantity
> > shipped in the field if it falls within the appropriate date range.
> > Qty2ShipPD1=IIF(( Parameters!startInvoicePD1.Value< Fields!
> > inv_dt.Value AND Parameters!EndInvoicePD1.Value> Fields!inv_dt.Value),
> > Fields!qty_to_ship.Value,0.0)
> > and
> > Qty2ShipPD2=IIF(( Parameters!startInvoicePD2.Value< Fields!
> > inv_dt.Value AND Parameters!EndInvoicePD2.Value> Fields!inv_dt.Value),
> > Fields!qty_to_ship.Value,0.0)
> > I need to build out a table that looks close to the following example:
> > Cust No
> > Item No Total for the Period
> > {need total quantity here}
> > PD1 {Qty2ShipPD1}
> > PD2 {Qty2ShipPD2}
> > I created a matrix control and dragged cus_no, item_no into the rows,
> > with item_no in the columns, and then summed the Qty2ShipPD1 in the
> > Details...
> > This works, in the sense that I am actually getting grouped
> > information which is correct for the customer/item combinations...
> > But the format won't work, and I have no idea how to do the same thing
> > in a table. Every time I do it in a table, I just get the same,
> > entire sum for the entire query for the two calculated fields.
> > Help?
> > THANKS!
> > Josh

Building custom Reporting Services Toolbar

We have an ASP.Net web app that uses RS for reporting. We can't use the RS
toolbar since we will be generating reports using the SOAP API. Does
anybody have any ideas/suggestions/examples on building a custom toolbar for
RS? Any input will be greatly appreciated. TIA.You just need to create a user control that calls the RS SOAP API for the
functionality you need, e.g. Parameters, etc. The AwReporterWeb project
included in my book source code
(http://www.manning-sandbox.com/thread.jspa?threadID=10394&tstart=45)
demonstrates how you can get a list of reports and parameters. More involved
scenarios are implemented in the AwReporterWin WinForm demo (e.g. obtaining
the parameters values, multi-value parameters, etc.).
As a side note, you may find my AwReportViewer control useful
(http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=45) to
handle images, dataset binding (using my custom dataset extension) and more
:-)
Finally, please note that by going SOAP you are losing not only the report
toolbar but also report interactive features (at least in version 1.0 of
RS), as well as simplicity.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:OX8WEX0yEHA.2600@.TK2MSFTNGP09.phx.gbl...
> We have an ASP.Net web app that uses RS for reporting. We can't use the
RS
> toolbar since we will be generating reports using the SOAP API. Does
> anybody have any ideas/suggestions/examples on building a custom toolbar
for
> RS? Any input will be greatly appreciated. TIA.
>
>|||One more thing... you can save yourself quite a bit of development time if
you could postpone the toolbar implementation until the RS 2005 controls are
out. They will include a custom toolbar, events, and will support both
connected and disconnected mode. The first public drop of the controls will
be in Yukon Beta 3 which is just a few months away.
"Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
news:OJs1PZ4yEHA.2196@.TK2MSFTNGP14.phx.gbl...
> You just need to create a user control that calls the RS SOAP API for the
> functionality you need, e.g. Parameters, etc. The AwReporterWeb project
> included in my book source code
> (http://www.manning-sandbox.com/thread.jspa?threadID=10394&tstart=45)
> demonstrates how you can get a list of reports and parameters. More
involved
> scenarios are implemented in the AwReporterWin WinForm demo (e.g.
obtaining
> the parameters values, multi-value parameters, etc.).
> As a side note, you may find my AwReportViewer control useful
> (http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=45) to
> handle images, dataset binding (using my custom dataset extension) and
more
> :-)
> Finally, please note that by going SOAP you are losing not only the report
> toolbar but also report interactive features (at least in version 1.0 of
> RS), as well as simplicity.
> --
> Hope this helps.
> ---
> Teo Lachev, MVP [SQL Server], MCSD, MCT
> Author: "Microsoft Reporting Services in Action"
> Publisher website: http://www.manning.com/lachev
> Buy it from Amazon.com: http://shrinkster.com/eq
> Home page and blog: http://www.prologika.com/
> ---
> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
> news:OX8WEX0yEHA.2600@.TK2MSFTNGP09.phx.gbl...
> > We have an ASP.Net web app that uses RS for reporting. We can't use the
> RS
> > toolbar since we will be generating reports using the SOAP API. Does
> > anybody have any ideas/suggestions/examples on building a custom toolbar
> for
> > RS? Any input will be greatly appreciated. TIA.
> >
> >
> >
>|||Thanks Leo. I've been planning on getting your book for some time now, but
haven't gotten around to it... yet. Now I will have to :-)
I would have prefered to use URL access, and custom authentication, but we
need to upgrade to Enterprise Edition to do that, and the cost is a bit too
much. I understand that the reports will lose some of its interactive
features if I use SOAP API.
"Teo Lachev" <teo@.prologika.com> wrote in message
news:uSDp6g4yEHA.1196@.TK2MSFTNGP15.phx.gbl...
> One more thing... you can save yourself quite a bit of development time if
> you could postpone the toolbar implementation until the RS 2005 controls
> are
> out. They will include a custom toolbar, events, and will support both
> connected and disconnected mode. The first public drop of the controls
> will
> be in Yukon Beta 3 which is just a few months away.
> "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> news:OJs1PZ4yEHA.2196@.TK2MSFTNGP14.phx.gbl...
>> You just need to create a user control that calls the RS SOAP API for the
>> functionality you need, e.g. Parameters, etc. The AwReporterWeb project
>> included in my book source code
>> (http://www.manning-sandbox.com/thread.jspa?threadID=10394&tstart=45)
>> demonstrates how you can get a list of reports and parameters. More
> involved
>> scenarios are implemented in the AwReporterWin WinForm demo (e.g.
> obtaining
>> the parameters values, multi-value parameters, etc.).
>> As a side note, you may find my AwReportViewer control useful
>> (http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=45) to
>> handle images, dataset binding (using my custom dataset extension) and
> more
>> :-)
>> Finally, please note that by going SOAP you are losing not only the
>> report
>> toolbar but also report interactive features (at least in version 1.0 of
>> RS), as well as simplicity.
>> --
>> Hope this helps.
>> ---
>> Teo Lachev, MVP [SQL Server], MCSD, MCT
>> Author: "Microsoft Reporting Services in Action"
>> Publisher website: http://www.manning.com/lachev
>> Buy it from Amazon.com: http://shrinkster.com/eq
>> Home page and blog: http://www.prologika.com/
>> ---
>> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
>> news:OX8WEX0yEHA.2600@.TK2MSFTNGP09.phx.gbl...
>> > We have an ASP.Net web app that uses RS for reporting. We can't use
>> > the
>> RS
>> > toolbar since we will be generating reports using the SOAP API. Does
>> > anybody have any ideas/suggestions/examples on building a custom
>> > toolbar
>> for
>> > RS? Any input will be greatly appreciated. TIA.
>> >
>> >
>> >
>>
>|||You don't have to :-)
I guess at the end you would you need to determine if the money you will
save by using Standard justifies the development effort getting around SOAP
addressability limitations. On the upside, it looks like the 2005 controls
will support drilldown with SOAP.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"TechnoSpyke" <technospyke@.yahoo.com> wrote in message
news:ej40s59yEHA.3548@.TK2MSFTNGP09.phx.gbl...
> Thanks Leo. I've been planning on getting your book for some time now,
but
> haven't gotten around to it... yet. Now I will have to :-)
> I would have prefered to use URL access, and custom authentication, but we
> need to upgrade to Enterprise Edition to do that, and the cost is a bit
too
> much. I understand that the reports will lose some of its interactive
> features if I use SOAP API.
> "Teo Lachev" <teo@.prologika.com> wrote in message
> news:uSDp6g4yEHA.1196@.TK2MSFTNGP15.phx.gbl...
> > One more thing... you can save yourself quite a bit of development time
if
> > you could postpone the toolbar implementation until the RS 2005 controls
> > are
> > out. They will include a custom toolbar, events, and will support both
> > connected and disconnected mode. The first public drop of the controls
> > will
> > be in Yukon Beta 3 which is just a few months away.
> >
> > "Teo Lachev [MVP]" <teo.lachev@.nospam.prologika.com> wrote in message
> > news:OJs1PZ4yEHA.2196@.TK2MSFTNGP14.phx.gbl...
> >> You just need to create a user control that calls the RS SOAP API for
the
> >> functionality you need, e.g. Parameters, etc. The AwReporterWeb project
> >> included in my book source code
> >> (http://www.manning-sandbox.com/thread.jspa?threadID=10394&tstart=45)
> >> demonstrates how you can get a list of reports and parameters. More
> > involved
> >> scenarios are implemented in the AwReporterWin WinForm demo (e.g.
> > obtaining
> >> the parameters values, multi-value parameters, etc.).
> >>
> >> As a side note, you may find my AwReportViewer control useful
> >> (http://www.manning-sandbox.com/thread.jspa?threadID=10392&tstart=45)
to
> >> handle images, dataset binding (using my custom dataset extension) and
> > more
> >> :-)
> >>
> >> Finally, please note that by going SOAP you are losing not only the
> >> report
> >> toolbar but also report interactive features (at least in version 1.0
of
> >> RS), as well as simplicity.
> >>
> >> --
> >> Hope this helps.
> >>
> >> ---
> >> Teo Lachev, MVP [SQL Server], MCSD, MCT
> >> Author: "Microsoft Reporting Services in Action"
> >> Publisher website: http://www.manning.com/lachev
> >> Buy it from Amazon.com: http://shrinkster.com/eq
> >> Home page and blog: http://www.prologika.com/
> >> ---
> >>
> >> "TechnoSpyke" <technospyke@.yahoo.com> wrote in message
> >> news:OX8WEX0yEHA.2600@.TK2MSFTNGP09.phx.gbl...
> >> > We have an ASP.Net web app that uses RS for reporting. We can't use
> >> > the
> >> RS
> >> > toolbar since we will be generating reports using the SOAP API. Does
> >> > anybody have any ideas/suggestions/examples on building a custom
> >> > toolbar
> >> for
> >> > RS? Any input will be greatly appreciated. TIA.
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
>

Building a Generic Report Viewer

I am just learning SSRS. I am coming from a Crystal Reports background. In
the app that I am upgrading to SSRS, I had a generic report viewer that I
fed the name of the report. The viewer than opened the report pulled out
the data source and set it and passed through any selection criteria from
the app and then ran the report in the viewer.
Is this possible with SSRS?
Will the report viewer sit in the client side app and I set the processing
mode to remote? I am doing a remote app connecting through a VPN to a SQL
Server 2005 database.
Thanks
BillGWhat you want is the report viewer control (winform or webform) that ships
with VS 2005. There is no viewer control that ships with RS. You have to get
the control via VS 2005 (or VS 2008). It does exactly as you describe.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"BillG" <billgower@.charter.net> wrote in message
news:DC9683FB-6354-44AD-89C9-B1A577541939@.microsoft.com...
>I am just learning SSRS. I am coming from a Crystal Reports background.
>In the app that I am upgrading to SSRS, I had a generic report viewer that
>I fed the name of the report. The viewer than opened the report pulled out
>the data source and set it and passed through any selection criteria from
>the app and then ran the report in the viewer.
> Is this possible with SSRS?
> Will the report viewer sit in the client side app and I set the processing
> mode to remote? I am doing a remote app connecting through a VPN to a SQL
> Server 2005 database.
>
> Thanks
> BillG
>

Build reports using Report Designer using Models

Once a Model is created, is ther query builder the only tool that can be used
to create a report from the Model or can we use Report Designer to build
reports off a Model?
Thanks in advance!I guess I should have clarified I am work with the 2005 Beta version of
Reporting Services. If anyone has any idea, please let me know.
Thanks!
"clutch" wrote:
> Once a Model is created, is ther query builder the only tool that can be used
> to create a report from the Model or can we use Report Designer to build
> reports off a Model?
> Thanks in advance!

build error, MDX reports

I get this error for some of my reports, it only happens for my MDX reports
and even then it is not all of them. They have all worked at some point or
another but recently this has started to happen
The expression for the query 'DataSet1' contains an error: [BC306481] String
constants must end with a double quote.
here's the code from dataSet1 of one of my reports
= "WITH" & " MEMBER [Measures].[Percentage Pref]" & "
AS"&" 'iif(isempty([Measures].[Number]),CDBl(0),"&" iif( sum(
{Ancestor([Preference Status].CurrentMember,1) } , [Measures].[Number]) = 0, 0,"&" cdbl(cdbl( [Measures].[Number]) / sum( {Ancestor([Preference
Status].CurrentMember,1) }, [Measures].[Number]) )))' " &
"select " &
"{[Measures].[Number],[Measures].[Percentage Pref]} on columns, " &
"{[Preference Status].[Preference Status].Members} on rows, " &
"{[Preference School].[Preference School LEA].[" & Parameters!LEA.Value &
"]} on pages, " &
"{[Round].[Round].[" & Parameters!Round.Value & "]} on AXIS(3) " &
"from [admissions]"
has the right number of quotes and i know this because they have worked
before, which leads me to believe there is an underlying error somewhere
else.
Any ideas' MSFT guys, this sounds like your area'
thanks
GregFixed this myself, for some unknonw reason you need to put quoates at the
beginning and end of every single line..... any of the MSFT guys wanna
explain why?
This was a very strange error as it has worked before without quotes on
every line.
Greg
"Greg" <Greg.conn@.nospam.nospam> wrote in message
news:epwa4TB$FHA.1548@.TK2MSFTNGP10.phx.gbl...
>I get this error for some of my reports, it only happens for my MDX reports
>and even then it is not all of them. They have all worked at some point or
>another but recently this has started to happen
> The expression for the query 'DataSet1' contains an error: [BC306481]
> String constants must end with a double quote.
> here's the code from dataSet1 of one of my reports
> = "WITH" & " MEMBER [Measures].[Percentage Pref]" & "
> AS"&" 'iif(isempty([Measures].[Number]),CDBl(0),"&" iif( sum(
> {Ancestor([Preference Status].CurrentMember,1) } , [Measures].[Number])
> = 0, 0,"&" cdbl(cdbl( [Measures].[Number]) / sum( {Ancestor([Preference
> Status].CurrentMember,1) }, [Measures].[Number]) )))' " &
> "select " &
> "{[Measures].[Number],[Measures].[Percentage Pref]} on columns, " &
> "{[Preference Status].[Preference Status].Members} on rows, " &
> "{[Preference School].[Preference School LEA].[" & Parameters!LEA.Value &
> "]} on pages, " &
> "{[Round].[Round].[" & Parameters!Round.Value & "]} on AXIS(3) " &
> "from [admissions]"
> has the right number of quotes and i know this because they have worked
> before, which leads me to believe there is an underlying error somewhere
> else.
> Any ideas' MSFT guys, this sounds like your area'
> thanks
> Greg
>
>

Build database application on Internet with ISP?

I have been building ASP, ASP.NET and Crystal Reports on SQL server
for a few years now.

I have build them mostly on an Intranet or with companies that have
their own web servers.

I now need to build an application for a company that doesn't not have
a web server. Just a small shop that wants an internet application.
How do I build an database application when the site will be host by
an ISP? The database will be SQL Server 2000, but located locally.
The site will be maintained by the ISP? How does the an application
hosted by an ISP interact with a database located locally (client's
site)?

If someone could point me toward some tutorial or tell me how to do
this, I would appreciate it."CrystalDBA" <tturner6@.hotmail.com> wrote in message
news:b0fe186f.0406030344.5e22f306@.posting.google.c om...
> I have been building ASP, ASP.NET and Crystal Reports on SQL server
> for a few years now.
> I have build them mostly on an Intranet or with companies that have
> their own web servers.
> I now need to build an application for a company that doesn't not have
> a web server. Just a small shop that wants an internet application.
> How do I build an database application when the site will be host by
> an ISP? The database will be SQL Server 2000, but located locally.
> The site will be maintained by the ISP? How does the an application
> hosted by an ISP interact with a database located locally (client's
> site)?
> If someone could point me toward some tutorial or tell me how to do
> this, I would appreciate it.

You may want to consider looking for an ISP who can host MSSQL for you, as
that would help to avoid the security issues of exposing a database server
to the internet. Otherwise, if you can set up a VPN from the ISP's web
server to your MSSQL server, that might be a possible alternative. The web
server would need to have the MSSQL client tools, and it would connect like
any other client.

Simon