Ok, I now have a success story to tell. So Nick pointed me in the right direction with the OS 126 error. I went to try to create an odbc connection and got the same exception. My 3rd Google search resulted in http://forums.oracle.com/forums/thread.jspa?threadID=527220&tstart=0 this forum which lead me to copy mfc71.dll and msvcr71.dll into my Oracle Client installation. I could then create an odbc connection. But when I tried to use the odbc connection in apache I got a strange TNS Listener error (ORA-12154). I started to get suspicious so I restarted my computer (yes I too can't believe after installing oracle client that I didn't restart immediately). After the restart odbc magically worked and so did straight oracle.
So the high-level installation instructions for using mod_dbd with oracle on Windows are: 1. Install Apache 2.2.9 or later (I was successful with 2.2.11) 2. Install Oracle Client (I did full with sqlplus support but the docs say Oracle Instant Client is enough) 3. RESTART 3. Configure mod_dbd as follows (which is basically the example from http://httpd.apache.org/docs/2.2/mod/mod_authn_dbd.html the docs ): # mod_dbd configuration DBDriver oracle DBDParams "server=<tnsnames entry> user=<user> pass=<password>" DBDMin 4 DBDKeep 8 DBDMax 20 DBDExptime 300 <Directory "C:/Apache/Apache2.2/htdocs/private"> # core authentication and mod_auth_basic configuration # for mod_authn_dbd AuthType Basic AuthName "My Server" AuthBasicProvider dbd # core authorization configuration Require valid-user # mod_authn_dbd SQL query to authenticate a user AuthDBDUserPWQuery / "SELECT password FROM acl_users WHERE username = %s" </Directory> Randy -- View this message in context: http://www.nabble.com/mod_authn_dbd-mod_dbd-problem-with-oracle-tp21419910p21427309.html Sent from the Apache HTTP Server - Users mailing list archive at Nabble.com. --------------------------------------------------------------------- The official User-To-User support forum of the Apache HTTP Server Project. See <URL:http://httpd.apache.org/userslist.html> for more info. To unsubscribe, e-mail: users-unsubscr...@httpd.apache.org " from the digest: users-digest-unsubscr...@httpd.apache.org For additional commands, e-mail: users-h...@httpd.apache.org
