« Giant Danish mystery egg #1 | Main | Plum blossom »
May 07, 2005
Borland BDP, IIS and Oracle : more questions than answers?
It's not so straightforward to access Oracle using the Borland Data Provider (BDP) through IIS ... I kept getting "BdpException: Connection open failed". Turns out it's a permissioning problem, and it's far from resolved in my mind. I've currently granted full access to the entire Oracle hierarchy to the local ASPNET, IUSR... and IWAM... users (the Oracle DB is running on the same box as IIS). That works. This is actually a general problem relating to Oracle access through IIS (I googled up lots of articles on ADO.NET, ODBC, OleDB etc etc, all tackling the same problem).
But hmmm.
I think only the ASPNET user needs access, and read only (maybe execute?) permissions at that. I will try to remove access to the other accounts and see what happens. I also want to get ECO II working - I believe it should be fairly plain sailing now my ASP.NET app can see the database.
But, how, then, do you get access to an Oracle DB on another Windows box? Or, for that matter, one running on a Linux box?
Questions, questions ...
Links and a definitive resolution to these puzzles will follow ... I hope.
Posted by daen at May 7, 2005 03:51 PM