Reports based off MDB

i have set up a report package that unfortunately uses an MDB as the
datasource (it will be upsized to SQL server soon); however, when any user
attempts to view/generate the reports they get the following error:
Reporting Services Error
An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'Accreditations_DB'.
(rsErrorOpeningConnection) Get Online Help
Unspecified error
The report(s) run fine off my test machine (i am the admin for the report
server).
any suggestions?
thanks,
benYou could put the MDB on a share and set that path in your connection
string. Or every user can have the MDB in the same path on each of their
local machines.
--
| Thread-Topic: Reports based off MDB
| thread-index: AcWXcPgArs6cX3IkSE6p/O0qCf3ZDQ==| X-WBNR-Posting-Host: 205.210.222.129
| From: =?Utf-8?B?QmVu?= <ben_1_ AT hotmail DOT com>
| Subject: Reports based off MDB
| Date: Tue, 2 Aug 2005 07:46:30 -0700
| Lines: 17
| Message-ID: <2C049966-34CD-4AEC-98D8-F24B6FB91CDD@.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:49442
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| i have set up a report package that unfortunately uses an MDB as the
| datasource (it will be upsized to SQL server soon); however, when any
user
| attempts to view/generate the reports they get the following error:
|
| Reporting Services Error
| An error has occurred during report processing. (rsProcessingAborted) Get
| Online Help
| Cannot create a connection to data source 'Accreditations_DB'.
| (rsErrorOpeningConnection) Get Online Help
| Unspecified error
|
| The report(s) run fine off my test machine (i am the admin for the report
| server).
|
| any suggestions?
| thanks,
| ben
||||Both those options are options that we are trying to avoid. I think it has
something to do with credentials because i stored my login and pass in the
datasource and checked the "impersonate" option and that seemed to work.
""Brad Syputa - MS"" wrote:
> You could put the MDB on a share and set that path in your connection
> string. Or every user can have the MDB in the same path on each of their
> local machines.
> --
> | Thread-Topic: Reports based off MDB
> | thread-index: AcWXcPgArs6cX3IkSE6p/O0qCf3ZDQ==> | X-WBNR-Posting-Host: 205.210.222.129
> | From: =?Utf-8?B?QmVu?= <ben_1_ AT hotmail DOT com>
> | Subject: Reports based off MDB
> | Date: Tue, 2 Aug 2005 07:46:30 -0700
> | Lines: 17
> | Message-ID: <2C049966-34CD-4AEC-98D8-F24B6FB91CDD@.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:49442
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | i have set up a report package that unfortunately uses an MDB as the
> | datasource (it will be upsized to SQL server soon); however, when any
> user
> | attempts to view/generate the reports they get the following error:
> |
> | Reporting Services Error
> | An error has occurred during report processing. (rsProcessingAborted) Get
> | Online Help
> | Cannot create a connection to data source 'Accreditations_DB'.
> | (rsErrorOpeningConnection) Get Online Help
> | Unspecified error
> |
> | The report(s) run fine off my test machine (i am the admin for the report
> | server).
> |
> | any suggestions?
> | thanks,
> | ben
> |
>