DataSource uploads as text file type

Hi,
I have a new installation of SQLExpress ADV with RS installed on XP Pro.
When I try to upload an rds file (which has already been running
successfully on a w2k3 server), it uploads as a text file and NOT as a
Datasource.
The associated report does of course not work.
Anyone seen this before - or know how to fix it please '.
Thanks
Regards
GrahamHi Oxns,
Thank you for your posting!
From your description, my understanding of this issue is: you want to
upload the report data source file as a shared data source in the report
manager. If I misunderstood your concern, please feel free to let me know.
You cannot upload a report data source (.rds) file to create a shared data
source. An .rds file is used only in Report Designer. It cannot provide the
content for a shared data source item that you define and manage through
Report Manager or Management Studio. As an alternative to uploading, you
can write a script that creates a shared data source based on a .rds file.
Please refer to the sample script PublishSamplReports.rss file in the
Samples. By default, scripting samples are located in C:\Program
Files\Microsoft SQL Server\90\Samples\Reporting Services\Script Samples.
Here are the articles for your reference:
Script Samples (Reporting Services)
http://msdn2.microsoft.com/en-us/library/ms160854(d=ide).aspx
Uploading Files to a Folder
http://msdn2.microsoft.com/en-us/library/ms156300(d=ide).aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Oxns,
How are you doing on this issue? Have you got any progress or does Wei's
last reply help you some on this? If the problem is not resolved or there
is anything else we can help, please feel free to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

Database won't update. Just Installed SQL Server. Please Help

I just installed SQL Server 2005 Express Edition to allow me to create databases in VB Express. The installation went fine (or so it seemed). When I complete the example to create a database and try to save the changes in the file, they are not retained.

I use the following statement to verify the changes have been made, but when I exit and return to the database, the changes are not made. If I make changes, the If statement correctly indicates the number of changes, but the are not saved. Any suggestions?

Dim RowsAffected As Integer = 0

RowsAffected = Me.CustomerTableAdapter1.Update(Me.MyCompanyDataSet1.Customer)

If RowsAffected > 0 Then

MessageBox.Show("Your updates were successful." & vbCrLf & _
RowsAffected.ToString & " row(s) were updated")

Else

MessageBox.Show("No changes were made.")

End If

Thanks...

Hi Patrick,

Check out my answer in this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=331048&SiteID=1.

You're hitting a common question related to running your application in Debug (F5) mode.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

Database Transfermation from SQL 2000 to SQL 2005

Hello
We have two SQL server installation. SQL server 2000 with sp4 and SQL server
2005 sp2. We want tp transfer 2 data bases from SQL 2000 to SQL 2005. how can
we update or transfer Databse from one old version to new version?
best regards,
Thor
Thor
I'd go with BACKUP/RESTORE , however you are able to detach/attach those
databases as well. See the explanation in the BOL
"Thor" <Thor@.discussions.microsoft.com> wrote in message
news:DEE2E28A-2EA8-4532-A2B2-E8F31CB85B3B@.microsoft.com...
> Hello
> We have two SQL server installation. SQL server 2000 with sp4 and SQL
> server
> 2005 sp2. We want tp transfer 2 data bases from SQL 2000 to SQL 2005. how
> can
> we update or transfer Databse from one old version to new version?
> best regards,
> Thor

Database Transfermation from SQL 2000 to SQL 2005

Hello
We have two SQL server installation. SQL server 2000 with sp4 and SQL server
2005 sp2. We want tp transfer 2 data bases from SQL 2000 to SQL 2005. how can
we update or transfer Databse from one old version to new version?
best regards,
ThorThor
I'd go with BACKUP/RESTORE , however you are able to detach/attach those
databases as well. See the explanation in the BOL
"Thor" <Thor@.discussions.microsoft.com> wrote in message
news:DEE2E28A-2EA8-4532-A2B2-E8F31CB85B3B@.microsoft.com...
> Hello
> We have two SQL server installation. SQL server 2000 with sp4 and SQL
> server
> 2005 sp2. We want tp transfer 2 data bases from SQL 2000 to SQL 2005. how
> can
> we update or transfer Databse from one old version to new version?
> best regards,
> Thor|||"Thor" <Thor@.discussions.microsoft.com> wrote in message
news:DEE2E28A-2EA8-4532-A2B2-E8F31CB85B3B@.microsoft.com...
> Hello
> We have two SQL server installation. SQL server 2000 with sp4 and SQL
> server
> 2005 sp2. We want tp transfer 2 data bases from SQL 2000 to SQL 2005. how
> can
> we update or transfer Databse from one old version to new version?
> best regards,
> Thor
Hi Thor
If you are wanting to upgrade check out other posts regarding this such as
http://tinyurl.com/4uzmyl, running the upgrade advisor will show up most of
the potential problems, rebuilding indexes, stats and usage will reduce the
risk of poorly performing queries. If you do have performance issues check
the query plan.
John