显示标签为“shared”的博文。显示所有博文
显示标签为“shared”的博文。显示所有博文

2012年3月22日星期四

Anybody knows the problem of this code?

My code is this:
shared function dataFisica( byVal data as Date ) as Date
If data='01/01/1900' Then
return ' '
Else
return data
End If
end function
And the reporting services do an error in line 1.
Try using double quotes instead of single quotes

function dataFisica( byVal data as Date ) as Date
If data="01/01/1900" Then
return ""
Else
return data
End If
end function

2012年2月11日星期六

Answer: Shared Datasource

Hey ladies and gentlemen,
I am trying to create a shared data source and am getting the following error -

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Best_Data_Corp'. (rsErrorOpeningConnection)
Login failed for user 'XvTVTVTVXOP.

Background information:
- I have a sql server 2000 with sp3 on a windows 2003 server which is within a network.
- I have reportings services on a web server thats outside my network and configured through dmz so its accessible through the network and it can see within the network.
- I am using reporting services 2000...

Any one seen this error and what where your fixes if any. I have been working on this problem for about a week now...I have seen post with people with similar problems but no one has posted a resolution.

Thanks in advance...

Check if you have access to this datasource. When you added this ds as a shared datasource, did you 'test connection' ?|||Check that the views being used by your report have DBO ownerhips. VS 2005 has a habit of creating views with the developer as owner. Things then work fine on your development box but not when deployed.

Answer: Shared Datasource

Hey ladies and gentlemen,
I am trying to create a shared data source and am getting the following error -

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Best_Data_Corp'. (rsErrorOpeningConnection)
Login failed for user 'XvTVTVTVXOP.

Background information:
- I have a sql server 2000 with sp3 on a windows 2003 server which is within a network.
- I have reportings services on a web server thats outside my network and configured through dmz so its accessible through the network and it can see within the network.
- I am using reporting services 2000...

Any one seen this error and what where your fixes if any. I have been working on this problem for about a week now...I have seen post with people with similar problems but no one has posted a resolution.

Thanks in advance...

Check if you have access to this datasource. When you added this ds as a shared datasource, did you 'test connection' ?|||Check that the views being used by your report have DBO ownerhips. VS 2005 has a habit of creating views with the developer as owner. Things then work fine on your development box but not when deployed.