Re: Help please

On Oct 25, 2:44 pm, nujcha..._at_googlemail.com wrote:
> 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

You seriously need to examine your licensing and support agreement with this third party vendor as I suspect all of your submitted suggestions are in violation of that agreement. If you can't modify the database I doubt very seriously you can simply engineer your own solution to this reporting fiasco by using 'tools' the vendor did not supply.

Before you get yourself, and your company, into a legal fight with this vendor (or lose all application support) you need to discuss this with the vendor's representatives. Possibly they can offer another 'solution' which can make your company happier and keep you, and them, out of legal 'hot water'.

David Fitzjarrell Received on Thu Oct 25 2007 - 16:22:49 CDT