Page 1 of 1

Can anyone help with MSSQL or Oracle installation on PHP?

Posted: Thu Aug 14, 2008 6:54 am
by kaisellgren
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.

Re: Can anyone help with MSSQL or Oracle installation on PHP?

Posted: Thu Aug 14, 2008 10:11 am
by Geteburg
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.

Re: Can anyone help with MSSQL or Oracle installation on PHP?

Posted: Thu Aug 14, 2008 12:16 pm
by kaisellgren
Update: I got Oracle to work. I had to insert one Environment Variable and that did it :)

But what about MSSQL... :/

Re: Can anyone help with MSSQL or Oracle installation on PHP?

Posted: Fri Aug 15, 2008 3:34 am
by Geteburg
kaisellgren 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).
From http://www.php.net/manual/en/mssql.setup.php
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.