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 |
|
billietm
Starting Member
4 Posts |
 Posted - 2007-06-20 : 13:14:31
|
| I'm fairly new to Reporting Services and would like to know if the following is possible...I currently have several MS Access 2000 database that connect through an ODBC connection to Oracle 9.x databases. These Access databse are exactly the same aside from what database environment they connect too. Is there a way to merge all these access databases into reporting services and just pass a variable to indicate which database environment I want to connect to? Also can I use database links like I can within an Oracle environment while using a named variable (ie.SELECT * FROM mytable@DBNAMEwhere DBNAME is a named variable like @DBNAME (when I try SELECT * FROM mytable@@DBNAME I get the following error: ORA-02019: Connection description for remote database not found)Thanks! |
|
|
|
|
|
Moving MS Access reports to Reporting Service