Hello,
I need to support either Oracle or MSSQL (MS SQL Server) on my PHP script. So, I need to get either of those to work (or preferabely BOTH!) on my home PC.
I'm running on Vista Ultimate x64 and I have so far done:
SQL Server
- Downloaded & Installed Microsoft SQL Server 2005 Express (version 2008 requires a SP1 for .NET Framework 3.5, but the patch does not work under x64, so I had to use v2005).
- Changed the PHP to load extension=mssql.dll or something like that, and copied the DLL to system32 too.
- I have started the SQL Server service.
- I have restarted Apache.
Result: No MSSQL extension found in phpinfo(), and can not use related functions. Why?
Oracle
- Downloaded and installed Oracle Database 10g Express Edition
- Changed the PHP to load extension=oci8.dll or somethingl ike that, and copied the DLL to system32 too.
- I have started the Oracle service.
- I have restarted Apache.
Result: No Oracle extension (oci) found in phpinfo(), and can not use related functions. Why?
Can anyone help me? MySQL and PostgreSQL are running fine...
EDIT: I do not see any startup errors upon Apache restart even though I have the startup_errors = On in PHP.ini.
Can anyone help with MSSQL or Oracle installation on PHP?
Moderator: General Moderators
- kaisellgren
- DevNet Resident
- Posts: 1675
- Joined: Sat Jan 07, 2006 5:52 am
- Location: Lahti, Finland.
Re: Can anyone help with MSSQL or Oracle installation on PHP?
I would start here for MSSQL: http://www.php.net/manual/en/mssql.setup.php
http://docs.moodle.org/en/Installing_MSSQL_for_PHP
Oracle: http://www.php.net/manual/en/oci8.setup.php
By looking at things, you probably need some more DLL files.
http://docs.moodle.org/en/Installing_MSSQL_for_PHP
Oracle: http://www.php.net/manual/en/oci8.setup.php
By looking at things, you probably need some more DLL files.
- kaisellgren
- DevNet Resident
- Posts: 1675
- Joined: Sat Jan 07, 2006 5:52 am
- Location: Lahti, Finland.
Re: Can anyone help with MSSQL or Oracle installation on PHP?
Update: I got Oracle to work. I had to insert one Environment Variable and that did it 
But what about MSSQL... :/
But what about MSSQL... :/
Re: Can anyone help with MSSQL or Oracle installation on PHP?
From http://www.php.net/manual/en/mssql.setup.phpkaisellgren wrote:Hello,
SQL Server
- Downloaded & Installed Microsoft SQL Server 2005 Express (version 2008 requires a SP1 for .NET Framework 3.5, but the patch does not work under x64, so I had to use v2005).
Note: In Windows, the MSSQL extension does not support SQL Server 2005 or greater because the internal API from ntwdblib.dll no longer is supported from SQL Server 2005. to use SQL Server 2005+, then use you must the ODBC extension.