Help please

From: <nujcharee_at_googlemail.com>
Date: Thu, 25 Oct 2007 12:44:23 -0700
Message-ID: <1193341463.253446.189470@o38g2000hse.googlegroups.com>

We have a product that is based on a oracle database supplied by 3rd party. With the license we are not allowed to alter the database funny
enough.

The reports produced from this product do not fit for purpose and obviously we couldnt alter it due to the additional cost. So we are thinking to find alternatives by re designing reports in MS Access using ODBC to Oracle database and give users interface where they can enter parameter to view the reports.

Now, from my reserach I dont think you can link Active Directory to MS
Access. Is this right?

So I am thinking "reporting service" within SQL server. I am thinking of having SQL Server as a shell (with no tables stored), use the linked server to connect to the Oracle database, SQL server can link with AD then finally produce a web form report.

Am I crazy? Is it possible to do so? The main thing is that whatever solution, it NEEDS to use active directory for authentication.

Anyone has better idea? Many thanks

Peppe Received on Thu Oct 25 2007 - 14:44:23 CDT