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 |
|
jhermiz
3564 Posts |
 Posted - 2004-11-22 : 18:13:43
|
| I need to create a report based on the OLE db type in sql server reporting services. I have the report setup and it works fine...but I need to add some parameters. But OLE db does not support named parameters so how do I create unnamed parameters ?Jon |
|
|
jhermiz
3564 Posts |
Posted - 2004-11-22 : 18:37:26
|
| ok = ? seems to work...kinda not descriptive though but will do.Thanks,Jon |
 |
|
|
jhermiz
3564 Posts |
Posted - 2004-11-22 : 19:14:18
|
| ok you can change the name...one thing though if I open the report and run it directly its fine...but if i open it up through the report server I get:-------------------------------------------------------------------------------- An error has occurred during report processing. (rsProcessingAborted) Get Online HelpCannot create a connection to data source 'OldIMS'. (rsErrorOpeningConnection) Get Online HelpThe Microsoft Jet database engine cannot open the file '\\Predator\IMS\IMS_be.mdb'. It is already opened exclusively by another user, or you need permission to view its data. Problem is I need to be able to run this report even when users are in this old access database.Is this why the report wont run ?The access database has no credentials and does not use access security, so it cannot be this.Anyone else have any ideas ? |
|
|
|
|
|
|
access ole db source..unnamed params.