Can anyone help with MSSQL or Oracle installation on PHP?

Need help installing PHP, configuring a script, or configuring a server? Then come on in and post your questions! We'll try to help the best we can!

Moderator: General Moderators

Post Reply
User avatar
kaisellgren
DevNet Resident
Posts: 1675
Joined: Sat Jan 07, 2006 5:52 am
Location: Lahti, Finland.

Can anyone help with MSSQL or Oracle installation on PHP?

Post 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.
Geteburg
Forum Commoner
Posts: 25
Joined: Tue Aug 12, 2008 1:57 pm

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

Post 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.
User avatar
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?

Post by kaisellgren »

Update: I got Oracle to work. I had to insert one Environment Variable and that did it :)

But what about MSSQL... :/
Geteburg
Forum Commoner
Posts: 25
Joined: Tue Aug 12, 2008 1:57 pm

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

Post 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.
Post Reply