MDAC 2.6?

From: Date: Fri, 20 Jul 2001 15:44:06 +0000
Subject: MDAC 2.6?
Groups: php.windows 
Request: Send a blank email to php-windows+get-8419@lists.php.net to get a copy of this message
Hi Folks! It's been awhile since I've been on this list. So, of course, now that I'm back I've got a real good one for you. (Note: I did search the list archives. No real explanation or answers were found.) MDAC 2.6...has anyone else experienced serious problems with it? In order to make my NT4 server development box match a client's environment, I installed MDAC sp1. As soon as I did so, all ODBC calls from both PHP3 and PHP4 went haywire. Essentially, I cannot even call a odbc_connect(). I get the following errors from the following ODBC drivers: ---------- Example 1: Driver...Microsoft Access Driver. Specifics: Generic .mdb file, NTFS security set to "Everyone - Full Control" (just to rule out NTFS bullsh!t), no password set. ODBC connection tested via Oracle's ODBC utility with no problems. Error message: S1000 [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data. ---------- Example 2: Driver...Microsoft Oracle Driver. Specifics: Oracle8i server on running on the same machine as IIS. ODBC connection tested via Oracle's ODBC utility with no problems. Error message: IM004 [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed ---------- Example 3: Driver...Oracle ODBC Driver. Specifics: Oracle8i server on running on the same machine as IIS. ODBC connection tested via Oracle's ODBC utility with no problems. Error message: IM003 Specified driver could not be loaded due to system error 5 (Oracle ODBC Driver). ---------- I get these messages no matter which version of PHP (4.0.6 and 3.0.11) I run. I had no issues hitting these datasources with MDAC 2.5. I can also connect to them via other means than PHP. Thoughts? - Erik

« previous php.windows (#8419) next »