Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
yaronPh
Starting Member
5 Posts |
 Posted - 2008-12-18 : 13:13:21
|
| Hello,I build a report that connect to access file with oledb provider and manage to see a preview of the report in the visual studio development environment.But in the report server I get error massage: "An error has occurred during report processing.An attempt has been made to use a data extension 'OLEDB' that is not registered for this report server" when I try to view the report.How can I solve this problem? Thanks in advanced, yaron. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-18 : 13:19:49
|
Install proper provider on reportserver.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
yaronPh
Starting Member
5 Posts |
Posted - 2008-12-20 : 06:55:11
|
| thanks for the answer,it seems that the oledb provider should be "built in" in the server because in the file:rsreportserver.config, oledb appears. |
|
|
|
yaronPh
Starting Member
5 Posts |
Posted - 2008-12-21 : 10:13:28
|
| Do i need to install proper provider on reportserver (when the provider is oledb that works fine in the visual studio develop environment)? if the answer is yes, is there a link that show me how to do it?any answer will be blessed. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-21 : 14:38:21
|
quote:
Originally posted by yaronPh
Do i need to install proper provider on reportserver (when the provider is oledb that works fine in the visual studio develop environment)? if the answer is yes, is there a link that show me how to do it?any answer will be blessed.
What did you find when you searched for errors in google? |
|
|
|
yaronPh
Starting Member
5 Posts |
Posted - 2008-12-21 : 15:01:01
|
| Didn't find match. I think that I missing something simple in the report server configuration but I don't no what it is. The oledb is define in the server in the file rsreportserver.config:"<Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>" so i think it got to do with security. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-22 : 02:54:38
|
Even if the OLEDB is set in an config file, doesn't mean the OLEDB provider is installed on the server.It is just text in a file.Very much like a christmas gift list.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
How can i config oledb in the report server?