Question about SQL

Hi all,

I have created a photo album in my local computer with [Microsoft Visual Web Developer 2005 Express Edition] my data base is SQL I built it with the same program. Also, I used the ASP.net Configuration to setup the user's account, every thing working 100% in my local computer.

I have an account with www. Hostonce .com they offer and support MS SQL 2005 and ASP.net, and they gave me an IP number to access to my MSSQL server with [SQL Server Management Studio Express], I do access when I put the IP address and the password, but I have no idea how to move the entire project with the SQL files to my server. I tried to transfer all my files with FTP, but it didn't work, they told me I have to transfer my SQL to the same IP address and then I have to do the connection things in my pages.

Please Help.

Thank You

Ok, you'll need to migrate the database from Express Edition to the MS SQL 2005 if they don't provide the Express Edition.|||

I think they support only MS SQL 2005 , but would you mind to tell me how i can solve this problem and how i can migrate the database from Express Edition to the MS SQL 2005 ?

Thank You,

|||If you don't have Studio to connect to both databases to do the migration. You can ask your hosting company to do the migration for you. Some hosting companies will do that for you

Question about Reporting Services...

I used Visual Studio 2003 to create several reports and those reports are
saved to a virtual directory at the IIS server. At present I can only open
those reports using the Report Manager came with the Reporting Services. I
wonder if I can open those reports straight from the web site with a
hyperlink and without opening the Report ManagerUI. If it is the case how
dose it work to connect to the SQL database? My understanding is the
connection/other information associated with the report is saved in a table
"Report Server" at the SQL database. Can I attach this connection string
information in a file at IIS or can it be attached right to the report
itself? Also how will it work in printing those reports in different file
formats as shown in the Reporting Manager if I allow to by-pass using the
Report Manager UI? Thank you for your infor.Hi Paul,
I assume when you mean "open" reports, you mean you want to retrieve a rendered
copy of the report (not retrieve the report definition, etc).
You can access the reports by URL quite easily. If say you have a report
"Purchase Order" in the folder "Demos" (/Demos/Purchase Order). Use this
URL:
http://<yourServer>/ReportServer/?/Demos/Purchase+Order
Then you can attach various URL parameters to control what happens. To render
the report in PDF, use this URL:
http://<yourServer>/ReportServer/?/Demos/Purchase+Order&rs:Command=Render&rs:Format=PDF
All of the database connection information is either stored in the RDL file
on the server, or as part of a Shared Data Source. So, there's no need to
send that info through the URL. If you have additional report parameters,
append them like you would any other URL querystring value. For example,
if you have a parameter "SalesYear":
http://<yourServer>/ReportServer/?/Demos/Purchase+Order&rs:Command=Render&rs:Format=PDF&SalesYear=2005
You can also use the RS web-services API:
http://support.microsoft.com/?kbid=875447
I've always thought that this was the way MSFT intended for users to get
to reports... built seamlessly into web applications, while Report Manager
was for report management/administration.
-Chris @. SoftArtisans
> I used Visual Studio 2003 to create several reports and those reports
> are saved to a virtual directory at the IIS server. At present I can
> only open those reports using the Report Manager came with the
> Reporting Services. I wonder if I can open those reports straight from
> the web site with a hyperlink and without opening the Report
> ManagerUI. If it is the case how dose it work to connect to the SQL
> database? My understanding is the connection/other information
> associated with the report is saved in a table "Report Server" at the
> SQL database. Can I attach this connection string information in a
> file at IIS or can it be attached right to the report itself? Also how
> will it work in printing those reports in different file formats as
> shown in the Reporting Manager if I allow to by-pass using the Report
> Manager UI? Thank you for your infor.
>

Question about database

I have a database that I created in visual web developer 2005 express edition. I have sql server 2005 express edition on my computer, but the databases don't seem to be stored there. The only place that I can find the databases are in the App_Data folder. When I try to copy the database into sql server from the App_Data folder it tells me there is no editor available and make sure the application for file .mdf is installed. I am not sure what to do here.

Can I take the database that I created in visual web developer and move it into sql server, or do I have to recreate the database in sql server?

If I can just copy or move the database how do I accomplish this?

Thanks for the help

I'm not sure what you are trying to achieve. Are you trying to move the database to another SQL Server instance (that is, not the SQL Server Express instance you have?). With SQL Server you 'attach' databases. In SQL Server Express an attach can be done with a connection string setting (AttachDBFileName). The UI tools of the non-express version have an interface to do attach:http://msdn2.microsoft.com/ms190209.aspx

Question - I think it has got to do with grouping (although not su

Hello,
I have created a list in visual studio reporting services with all
outstanding invoices for a range of customers (where customer number between
'From' and 'To' parameter). I have also created a statement in the reporting
layout, but now I would like to know I can make sure that the statement for
every customer appears on a new page?
Statement looks as follows:
---
Customer number: XXXXXXXXXX
Customer name: John Doe
Adress: Test street 23
...
======= Invoice details (this is a table which contains all outstanding invoices for
this customer including the open amounts).
Please help.
Thanks!
CheersOn Jan 10, 3:19 am, DHL <D...@.discussions.microsoft.com> wrote:
> Hello,
> I have created a list in visual studio reporting services with all
> outstanding invoices for a range of customers (where customer number between
> 'From' and 'To' parameter). I have also created a statement in the reporting
> layout, but now I would like to know I can make sure that the statement for
> every customer appears on a new page?
> Statement looks as follows:
> ---
> Customer number: XXXXXXXXXX
> Customer name: John Doe
> Adress: Test street 23
> ...
> =======> Invoice details (this is a table which contains all outstanding invoices for
> this customer including the open amounts).
> Please help.
> Thanks!
> Cheers
You would set your Group properties to 'Page break at end.' You would
do this via: right-clicking the table/matrix control >> select
Properties >> select Groups tab >> select the Edit... button >> then
select 'Page break at end.' Hope this helps.
Regards,
Enrique Martinez
Sr Software Consultant