rsInvalidDataSourceReference-Pls help

Hello Everybody:
I have installed SQL Reporting Services for the first time using SQL Login account. After creating a Shared Data Source, and creating the report I am trying to deploy the report to the server. In the project properties I have set the TargetServerURL to http://hostweb01/ReportServer
When I try to deploy the project I get a windows pop up asking for User Name and password. I enter the username and password but the window keeps popping up. I therefore load the report from http://hostweb01/Reports
When I try to run the report I get the error.

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)
Can anyone guide me what could be wrong and what should I do to correct the problem. I have stuck on this problem for hours.

Thanks,

Kapil

For the first item, when you give it a user name and password, are you giving a Windows account known by IIS? What is the security setting on your /reportserver web site (use IIS Manager)?

If you deploy manually (through Report Manager), you will need to create a new data source item (with the correct connection string) on he server before you upload the report. Afterwards, you can go to the report properties page and link the report to the data source object.

|||

Hi rahil,

u need to point the report to the datasource to solve this issue.

The datasource is shared by different reports and u need to have dependent items pointed to the datasource.

I too struggle a lot over this issue and at last found the solution.

I am giving u step by step solution for this issue.

1. go to Report Manager(http://<servername>/reports/pages/Folder.aspx)

2. Click on the Folder in which u have reports

3. U will be directed into contents tab where u will find Show Details at the right top corner

4. Click on Show Details

5. Check in the particular report and click the edit button corresponding to it

6. Go to the properties tab and click on it

7. U will find a menu on left hand side, click on Data Sources link

8. There u will find radio button selected for A share data source(by default) and a browse button.

9. Click on the browse button u will find the tree structure of the datasource and the reports folder.

10. select the datasource in the datasource folder and select OK.

by this way u will be able to point the report to the datasource.

Regards,

Vamsi Krishna Korasiga

rsInvalidDataSourceReference-Pls help

Hello Everybody:
I have installed SQL Reporting Services for the first time using SQL Login account. After creating a Shared Data Source, and creating the report I am trying to deploy the report to the server. In the project properties I have set the TargetServerURL to http://hostweb01/ReportServer
When I try to deploy the project I get a windows pop up asking for User Name and password. I enter the username and password but the window keeps popping up. I therefore load the report from http://hostweb01/Reports
When I try to run the report I get the error.

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)
Can anyone guide me what could be wrong and what should I do to correct the problem. I have stuck on this problem for hours.

Thanks,

Kapil

For the first item, when you give it a user name and password, are you giving a Windows account known by IIS? What is the security setting on your /reportserver web site (use IIS Manager)?

If you deploy manually (through Report Manager), you will need to create a new data source item (with the correct connection string) on he server before you upload the report. Afterwards, you can go to the report properties page and link the report to the data source object.

|||

Hi rahil,

u need to point the report to the datasource to solve this issue.

The datasource is shared by different reports and u need to have dependent items pointed to the datasource.

I too struggle a lot over this issue and at last found the solution.

I am giving u step by step solution for this issue.

1. go to Report Manager(http://<servername>/reports/pages/Folder.aspx)

2. Click on the Folder in which u have reports

3. U will be directed into contents tab where u will find Show Details at the right top corner

4. Click on Show Details

5. Check in the particular report and click the edit button corresponding to it

6. Go to the properties tab and click on it

7. U will find a menu on left hand side, click on Data Sources link

8. There u will find radio button selected for A share data source(by default) and a browse button.

9. Click on the browse button u will find the tree structure of the datasource and the reports folder.

10. select the datasource in the datasource folder and select OK.

by this way u will be able to point the report to the datasource.

Regards,

Vamsi Krishna Korasiga

rsInvalidDataSourceReference Error

Hi,

I have published the data source and the report on the report server programmatically. When i open the report either using URL redirection (programmatically) or from the Report Manager screen, the following error message is displayed.

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

If I change the report properties manually using Report Manager screen and bind the data source to the report, it works fine.

Is there any solution to bind it programmatically ?

Thanks in advance.It sounds like the RDL is not set correctly to point to where the datasource is being deployed. You can either change the RDL or call SetItemDatasources (RS 2005) or SetReportDatasources (RS 2000) to set the data source to point to the shared data source.|||Thanks, I also had got a solution last week, though was work-around, was still useful.|||

I am having the same problem.

Would you give me the work around to the problem.

|||

Hi All,

I also got this error today for the very first time and I was wondering how it is created.

I have been using RS for nearly 2 years and never seen this message before. When I go into Report->Data Sources it tells me "The shared Data Source Reference is no longer valid" and all I need to do is to reconnect the data source.

Also, if I delete a report and redeploy it then it will also connect to the data source correctly even though it is the same data source....but if I redeploy a report without deleting it the message is issued.

This seems like a really strange one...I would like to know if anyone knows how this happens...I have two other report projects which are functioning just fine and after I reconnect the data source all is fine... ?

Thanks In Advance

Peter

sql

rsInvalidDataSourceReference Error

Hi,

I have published the data source and the report on the report server programmatically. When i open the report either using URL redirection (programmatically) or from the Report Manager screen, the following error message is displayed.

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

If I change the report properties manually using Report Manager screen and bind the data source to the report, it works fine.

Is there any solution to bind it programmatically ?

Thanks in advance.It sounds like the RDL is not set correctly to point to where the datasource is being deployed. You can either change the RDL or call SetItemDatasources (RS 2005) or SetReportDatasources (RS 2000) to set the data source to point to the shared data source.|||Thanks, I also had got a solution last week, though was work-around, was still useful.|||

I am having the same problem.

Would you give me the work around to the problem.

|||

Hi All,

I also got this error today for the very first time and I was wondering how it is created.

I have been using RS for nearly 2 years and never seen this message before. When I go into Report->Data Sources it tells me "The shared Data Source Reference is no longer valid" and all I need to do is to reconnect the data source.

Also, if I delete a report and redeploy it then it will also connect to the data source correctly even though it is the same data source....but if I redeploy a report without deleting it the message is issued.

This seems like a really strange one...I would like to know if anyone knows how this happens...I have two other report projects which are functioning just fine and after I reconnect the data source all is fine... ?

Thanks In Advance

Peter

rsInvalidDataSourceReference Error

Hi,

I have published the data source and the report on the report server programmatically. When i open the report either using URL redirection (programmatically) or from the Report Manager screen, the following error message is displayed.

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

If I change the report properties manually using Report Manager screen and bind the data source to the report, it works fine.

Is there any solution to bind it programmatically ?

Thanks in advance.It sounds like the RDL is not set correctly to point to where the datasource is being deployed. You can either change the RDL or call SetItemDatasources (RS 2005) or SetReportDatasources (RS 2000) to set the data source to point to the shared data source.|||Thanks, I also had got a solution last week, though was work-around, was still useful.|||

I am having the same problem.

Would you give me the work around to the problem.

|||

Hi All,

I also got this error today for the very first time and I was wondering how it is created.

I have been using RS for nearly 2 years and never seen this message before. When I go into Report->Data Sources it tells me "The shared Data Source Reference is no longer valid" and all I need to do is to reconnect the data source.

Also, if I delete a report and redeploy it then it will also connect to the data source correctly even though it is the same data source....but if I redeploy a report without deleting it the message is issued.

This seems like a really strange one...I would like to know if anyone knows how this happens...I have two other report projects which are functioning just fine and after I reconnect the data source all is fine... ?

Thanks In Advance

Peter

rsInvalidDataSourceReference Error

Hi,

I have published the data source and the report on the report server programmatically. When i open the report either using URL redirection (programmatically) or from the Report Manager screen, the following error message is displayed.

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

If I change the report properties manually using Report Manager screen and bind the data source to the report, it works fine.

Is there any solution to bind it programmatically ?

Thanks in advance.It sounds like the RDL is not set correctly to point to where the datasource is being deployed. You can either change the RDL or call SetItemDatasources (RS 2005) or SetReportDatasources (RS 2000) to set the data source to point to the shared data source.|||Thanks, I also had got a solution last week, though was work-around, was still useful.|||

I am having the same problem.

Would you give me the work around to the problem.

|||

Hi All,

I also got this error today for the very first time and I was wondering how it is created.

I have been using RS for nearly 2 years and never seen this message before. When I go into Report->Data Sources it tells me "The shared Data Source Reference is no longer valid" and all I need to do is to reconnect the data source.

Also, if I delete a report and redeploy it then it will also connect to the data source correctly even though it is the same data source....but if I redeploy a report without deleting it the message is issued.

This seems like a really strange one...I would like to know if anyone knows how this happens...I have two other report projects which are functioning just fine and after I reconnect the data source all is fine... ?

Thanks In Advance

Peter

rsInvalidDataSourceReference

I am getting the following error:

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

All i did is created the datasource in the same location where my report files .rdl files are. instead of datasource folder on the report server.

everything works fine from my project vs2005, but if i run the report via localhost/reports, it gives the above error:

please help, i created this method since i have 5 different sites on the same server, all of the sites has reports with same datasource name many of them are common for that reason.

Thank you very much for the informartion.

Try this:

Open up Report Manager, and drill down to open your report. Click on the Properties tab, then select 'Data Sources' from the left pane. Click the Browse button next to 'Select a shared data source'. From here, navigate to the folder where your report is, and select the data source that is in there (since this is where you deployed to). Click OK, then Apply your changes.

Hope this helps.

Jarret

|||Wow.. Jarret Thank you very much. you gave me two tips since yesterday. thks....|||

Hi,

I am using a rss script to deploy reports and data sources. All my datasources lie in the shared location "Data Sources". With the script the data source and reports are deployed but the it gives the same error as posted by cplusplus1.

Here is the rss script to deploy report and data source that I used. Please help.

'To deploy Data Source

Public Sub CreateDataSource(ByVal name As String, ByVal extension As String, ByVal connectionString As String)
'Define the data source definition.
Dim definition As New DataSourceDefinition()
definition.Extension = extension
definition.ConnectString = connectionString
definition.Enabled = True
definition.EnabledSpecified = True
definition.CredentialRetrieval = CredentialRetrievalEnum.Integrated
definition.WindowsCredentials = True
definition.Prompt = Nothing
definition.ImpersonateUserSpecified = True
Try
rs.CreateDataSource(name, dataSourcePath, overWriteExistingDataSource, definition, Nothing)
Console.WriteLine("Data source {0} created successfully", name)

Catch e As Exception
Console.WriteLine(e.Message)
End Try

End Sub

' TO DEPLOY Report

Public Sub PublishReport(ByVal reportName As String)
Try
Dim stream As FileStream = File.OpenRead(filePath + reportName + ".rdl")
definition = New [Byte](stream.Length) {}
stream.Read(definition, 0, CInt(stream.Length))
stream.Close()

Catch e As IOException
Console.WriteLine(e.Message)
End Try

Try
warnings = rs.CreateReport(reportName, parentPath, False, definition, Nothing)

Dim dataSources() As DataSource = rs.GetItemDataSources(parentPath + "/" + reportName)

Dim ds As DataSource
For Each ds In dataSources
If (ds.Item.GetType() Is Type.GetType("InvalidDataSourceReference")) Then
Dim NewDS As DataSource = New DataSource()
Dim dsRef As DataSourceReference = New DataSourceReference()

dsRef.Reference = dataSourcePath + "/" + dataSourceName
NewDS.Item = dsRef
NewDS.Name = ds.Name
Dim NewDataSources() As DataSource = New DataSource() {NewDS}

rs.SetItemDataSources(parentPath + "/" + reportName, NewDataSources)
End If
Next

If Not (warnings Is Nothing) Then
Dim warning As Warning
For Each warning In warnings
Console.WriteLine(warning.Message)
Next warning
Else
Console.WriteLine("Report: {0} published successfully with no warnings", reportName)
End If
Catch e As Exception
Console.WriteLine(e.Message)
End Try
End Sub

rsInvalidDataSourceReference

I am getting the following error:

The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)

All i did is created the datasource in the same location where my report files .rdl files are. instead of datasource folder on the report server.

everything works fine from my project vs2005, but if i run the report via localhost/reports, it gives the above error:

please help, i created this method since i have 5 different sites on the same server, all of the sites has reports with same datasource name many of them are common for that reason.

Thank you very much for the informartion.

Try this:

Open up Report Manager, and drill down to open your report. Click on the Properties tab, then select 'Data Sources' from the left pane. Click the Browse button next to 'Select a shared data source'. From here, navigate to the folder where your report is, and select the data source that is in there (since this is where you deployed to). Click OK, then Apply your changes.

Hope this helps.

Jarret

|||Wow.. Jarret Thank you very much. you gave me two tips since yesterday. thks....|||

Hi,

I am using a rss script to deploy reports and data sources. All my datasources lie in the shared location "Data Sources". With the script the data source and reports are deployed but the it gives the same error as posted by cplusplus1.

Here is the rss script to deploy report and data source that I used. Please help.

'To deploy Data Source

Public Sub CreateDataSource(ByVal name As String, ByVal extension As String, ByVal connectionString As String)
'Define the data source definition.
Dim definition As New DataSourceDefinition()
definition.Extension = extension
definition.ConnectString = connectionString
definition.Enabled = True
definition.EnabledSpecified = True
definition.CredentialRetrieval = CredentialRetrievalEnum.Integrated
definition.WindowsCredentials = True
definition.Prompt = Nothing
definition.ImpersonateUserSpecified = True
Try
rs.CreateDataSource(name, dataSourcePath, overWriteExistingDataSource, definition, Nothing)
Console.WriteLine("Data source {0} created successfully", name)

Catch e As Exception
Console.WriteLine(e.Message)
End Try

End Sub

' TO DEPLOY Report

Public Sub PublishReport(ByVal reportName As String)
Try
Dim stream As FileStream = File.OpenRead(filePath + reportName + ".rdl")
definition = New [Byte](stream.Length) {}
stream.Read(definition, 0, CInt(stream.Length))
stream.Close()

Catch e As IOException
Console.WriteLine(e.Message)
End Try

Try
warnings = rs.CreateReport(reportName, parentPath, False, definition, Nothing)

Dim dataSources() As DataSource = rs.GetItemDataSources(parentPath + "/" + reportName)

Dim ds As DataSource
For Each ds In dataSources
If (ds.Item.GetType() Is Type.GetType("InvalidDataSourceReference")) Then
Dim NewDS As DataSource = New DataSource()
Dim dsRef As DataSourceReference = New DataSourceReference()

dsRef.Reference = dataSourcePath + "/" + dataSourceName
NewDS.Item = dsRef
NewDS.Name = ds.Name
Dim NewDataSources() As DataSource = New DataSource() {NewDS}

rs.SetItemDataSources(parentPath + "/" + reportName, NewDataSources)
End If
Next

If Not (warnings Is Nothing) Then
Dim warning As Warning
For Each warning In warnings
Console.WriteLine(warning.Message)
Next warning
Else
Console.WriteLine("Report: {0} published successfully with no warnings", reportName)
End If
Catch e As Exception
Console.WriteLine(e.Message)
End Try
End Sub

sql

rsInternalError General network error for new report

Running RS2000 on Windows 2003
I published a new report today (copied from an existing report, used same
data source calling different stored procedure, changed parameters, etc.).
It worked fine when run locally.
However, when published and run within Report Manager I get the following
error -
Reporting Services Error
----
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
General network error. Check your network documentation.
I'm not sure I've seen this error before. I've had errors before but they
usually occurred because I forgot to give adequate permissions to the stored
procedure or something like that.
I've search around but haven't figured out how to troubleshoot this problem.
I have looked at the trace logs but I'm still learning how to read them.
Here is what appear to be the relevant portion found in them -
In ReportServer__08_17_2007_06_42_51.log
w3wp!library!1058!08/17/2007-10:54:06:: i INFO: Call to RenderFirst(
'/Development/Ref Des Term Count' )
w3wp!library!1058!08/17/2007-10:54:07:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., ;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Data.SqlClient.SqlException: A severe error occurred on
the current command. The results, if any, should be discarded.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.CancelableSqlCommand.ExecuteNonQuery()
at
Microsoft.ReportingServices.Library.ChunkStorage.WriteNewSnapshotToDB(String
effectiveParams, Int32 paramsHash, DateTime createdDate, String description,
Guid snapshotDataID, Boolean isPermanentSnapshot)
at
Microsoft.ReportingServices.Library.ReportSnapshot.WriteNewSnapshotToDB(String effectiveParams, Int32 paramsHash, DateTime createdDate, String description)
at
Microsoft.ReportingServices.Library.RSService.AllocateNewSnapshot(Boolean
isPermanentSnapshot, String effectiveParams, Int32 paramsHash, DateTime
createdDate, String description)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
-- End of inner exception stack trace --
w3wp!library!1058!08/17/2007-10:54:07:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
w3wp!webserver!1058!08/17/2007-10:54:08:: e ERROR: Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal
error occurred on the report server. See the error log for more details. -->
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details. --> System.Data.SqlClient.SqlException: A severe error occurred on
the current command. The results, if any, should be discarded.
In ReportServerService__main_08_17_2007_05_10_24.log
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__main_08_17_2007_05_10_24.log</Path>
<SystemName>IW-SQL</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
ReportingServicesService!servicecontroller!11dc!8/17/2007-05:10:24:: i INFO:
Recycling the service from default domain
ReportingServicesService!servicecontroller!11dc!8/17/2007-05:10:27:: i INFO:
New app domain started
Other existing reports seem to be working with no problem.
Any help troubleshooting this would be greatly appreciated.
KevinWell I've found a solution. Instead of copying an existing report I just
started from scratch. I built a new one from the ground up and it worked
fine.
Apparently there was something in the report I made from the copy that it
didn't like. I thought I went through it pretty thoroughly to make sure
nothing referred to fields, parameters, etc. that didn't apply but I guess I
missed something.
For future reference I would appreciate any recommendations for catching
problems when copying a report. Maybe copying isn't recommended? It usually
seems to save time (except in this case!).
Kevin|||Rats!!! I thought I had it fixed. My report and stored procedure both have
just one parameter. I just made a simple report (data is listed in a table)
and set a default value for the report parameter and it worked.
Thinking that it was fixed, I removed the default and re-published. Now
when I select a value from the list in the prompt and run the report I get
the error.
So, is the problem something to do with my prompt? Any ideas on
troubleshooting would be appreciated. The prompt is just a simple query from
one table -
SELECT DISTINCT r.item AS PromptValue
,r.item AS PromptLabel
FROM dbname.dbo.tablename r
WHERE r.item <> ''
ORDER BY r.item
The stored procedure queries the same table and is as follows -
CREATE PROCEDURE rpt_Ref_DesTermCount
(
@.StockCode VARCHAR(30) = '%'
)
AS
SELECT r.item
,r.ref_des
,r.TermCount
FROM dbname.dbo.tablename r
WHERE r.item LIKE @.StockCode
ORDER BY r.ref_des
GO
Thanks in advance,
Kevin

rserroropeningconnection SQL RS 2000

I have configured a user as content manager in security settings for a data source and trying to execute the report under his credentials, but i keep getting the error

RSErrorOpeningConnection login failed for user <domain>\<username>

I have set windows authentication for the data source

Can anyone please help...

have u selected the checkbox in your datasource like this....

Use as Windows credentials when connecting to the data source..

|||

I selected the last but one option --

Windows NT Integrated Security

RS: Cannot create a connection to data source

Hi!

I've created a project includen 3 reports based on following code on 3 server. The report includes 3 different datasources an 3 different report. All 3 reports are grouped on Database and summerizad zise.

SELECT

SD.name [Database],

SMF.name [File],

SMF.size [Size]

FROM

sys.master_files SMF INNER JOIN sys.databases SD

ON SD.database_id = SMF.database_id

I can run all reports in Visual Studio (preview). But I can only run one the reports after depolying the project! I get this message when I raun the other 2 reports:

An error has occurred during report processing.

Cannot create a connection to data source 'uasql02_datasource'.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

I tried running the report from an server (where reportingservices is installed) finding that all the reports works as they should. I logged in another server with the same credentials. I got same message on the server as I get on my own camputer, "Cannot create a connection to data source ..."

Is there anybody out there having same problem as I, or someone who has any suggestion?

Thanks for any suggestion!

/*

Fari Sah

*/

Hello, Fari-- I am also getting the "Cannot create a connection to data source..." message, but the rest says "Login failed for user..."

Everything works fine on my production server, but I'm having trouble getting the same reports to work on my development PC and my test server. I'm going to keep hunting, so please post any new information!

RS.exe Scripter DataSource error

Is it possible within an .rss script to set the data source of a report?
In other words I created an .rss script that generates all the folders and creates and uploads all the reports and data sources to Reporting Services. The problem is that I have to then go in and manually point each report to the right data source. I would like to automate this task too within the .rss script.

Learnthis is the sample i used to attach the datasource but it still does not work:

Dim fullpath As String = SubFolderPath + "/Report.rdl"
Dim dataSources(0) As DataSource
Dim dsr0 As New DataSourceReference
dsr0.Reference = "/Mydir/Test/mydatasourcename"
Dim ds0 As New DataSource
ds0.Item = CType(dsr0, DataSourceDefinitionOrReference)
ds0.Name="mydatasourcename"
dataSources(0) = ds0
rs.SetItemDataSources(fullpath, dataSources)i

The error I keep getting when i click the report I just published is:

"The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)"

And the error I get from the cmd is :

"Unhandled exception:
The data source 'cdo_suite_5_qa' cannot be found."


Any advice would be very helpful.
Steve

The fullpath does not need the .rdl extension but only the path and name of the report.

You could also try rs.SetReportDataSources rather then rs.SetItemDataSources.

RS.exe Scripter DataSource error

Is it possible within an .rss script to set the data source of a report?
In other words I created an .rss script that generates all the folders and creates and uploads all the reports and data sources to Reporting Services. The problem is that I have to then go in and manually point each report to the right data source. I would like to automate this task too within the .rss script.

Learnthis is the sample i used to attach the datasource but it still does not work:

Dim fullpath As String = SubFolderPath + "/Report.rdl"
Dim dataSources(0) As DataSource
Dim dsr0 As New DataSourceReference
dsr0.Reference = "/Mydir/Test/mydatasourcename"
Dim ds0 As New DataSource
ds0.Item = CType(dsr0, DataSourceDefinitionOrReference)
ds0.Name="mydatasourcename"
dataSources(0) = ds0
rs.SetItemDataSources(fullpath, dataSources)i

The error I keep getting when i click the report I just published is:

"The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)"

And the error I get from the cmd is :

"Unhandled exception:
The data source 'cdo_suite_5_qa' cannot be found."


Any advice would be very helpful.
Steve

The fullpath does not need the .rdl extension but only the path and name of the report.

You could also try rs.SetReportDataSources rather then rs.SetItemDataSources.

RS ASP.Net code

Does anyone know if the source code for the ASP.Net application that
comes with Reporting Services is available for viewing somewhere?"no one" <noone@.yahoo.com> wrote in message
news:41F68CB5.F2E43E6F@.yahoo.com...
> Does anyone know if the source code for the ASP.Net application that
> comes with Reporting Services is available for viewing somewhere?

There are a few code samples included with RS, if that's what you're
referring to:

http://msdn.microsoft.com/library/d...sov_v1_0vub.asp

Simon

RS 2005 Testing - database connection issue

Hi,
From my own PC, I have created a report in Report Builder (RB) that has a
SQL server database as a data source, and when I go to run it (in either RB
or Report Manager), I get the following message: -
"Cannot create a connection to data source 'dataSource'.
(rsErrorOpeningConnection)
--
An error has occurred during report processing. (rsProcessingAborted)"
However, when I run the report in Report Builder directly on the test
server, the report is produced no probs!
Any ideas as to why this is happening?
Cheers
TrevorReport Builder is probable running with NT Auth. Do you have permissions to
the data source and model that may be different then when run on the local
machine?
Try to follow how the connections are working. Client machine RB -> Model
-> Data Source. Somewhere there looks like your client has no access to or
it does not exist.
--
| Thread-Topic: RS 2005 Testing - database connection issue
| thread-index: AcXEPOQcb4FfUXeUQNyO6UODzJAI5Q==| X-WBNR-Posting-Host: 195.44.12.109
| From: =?Utf-8?B?YXVsZHJlaWR5?= <auldreidy@.discussions.microsoft.com>
| Subject: RS 2005 Testing - database connection issue
| Date: Wed, 28 Sep 2005 07:57:05 -0700
| Lines: 19
| Message-ID: <5777EA31-DEBF-4071-91B3-D6CE0C7004B0@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53272
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
|
| From my own PC, I have created a report in Report Builder (RB) that has a
| SQL server database as a data source, and when I go to run it (in either
RB
| or Report Manager), I get the following message: -
|
| "Cannot create a connection to data source 'dataSource'.
| (rsErrorOpeningConnection)
| --
| An error has occurred during report processing. (rsProcessingAborted)"
|
| However, when I run the report in Report Builder directly on the test
| server, the report is produced no probs!
|
| Any ideas as to why this is happening?
|
| Cheers
| Trevor
|
|