Discussions
Categories
- 197K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.8K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 556 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.4K Development
- 17 Developer Projects
- 139 Programming Languages
- 293.1K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 161 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 475 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
Problem connecting to Oracle 9i (9.2.0.1.0) using PHP on Windows IIS & SQL Server
I'm trying to connect to our Oracle 9i (9.2.0.1.0) db using PHP run on Windows Server, IIS & SQL Server and I get the following error when using the oci_connect() command:
PHP Fatal error: Call to undefined function oci_connect() in C:\inetpub\drupal7\www\bomquery.php on line 13
It is an intranet server setup to use Drupal 7.38.
Windows Server 2008 R2 Datacenter Edition (64-bit server)
IIS 7.5 (comes with Server 2008 R2)
SQL Server 2014 Express
PHP 5.6.12
The php extension (php_oci8.dll) didn't come with PHP 5.6.12 so I added the dll manually and then added and enabled the extension to php.ini.
Downloaded and used php_oci8.dll from: http://pecl.php.net/package/oci8
Downloaded and extracted Oracle Instantclient 11.2.0.1.0 to C:\Windows\SysWOW64\instantclient_11_2
Pointed System Properties -> Environment Variables -> PATH to %windir%\SysWOW64\instantclient_11_2
Any suggestions would be grateful. If the issue is resolved, I'll post a tutorial since I've been struggling for the past while to get it to work and it's super difficult finding any resources online that can help with this.
Answers
-
Connections between 10.2 (or higher) and 9.2.0.1, 9.2.0.2 or 9.2.0.3 was never certified or supported. So connecting to DB running on 9.2.0.1 using client 11.2.0.1 could face lot of issue. Please refer support Doc 207303.1 to know the Client/Server interoperability.
-
@Sdhamoth-Oracle, I'm unable to refer to that website as I don't have a Support Identifier.
I have access to the Oracle server (Windows Server 2003) though. Would I be able to use anything from the server to replace instantclient_11_2?
-
If the DB is running on 9.2.0.4, then PHP 5.6/OCI8 2.X/InstantClient 11.2.0.1 combination may work. I haven't tried this combination before.
-
The immediate problem doesn't seem to be about Oracle version support, it is about getting the IIS environment configured to allow the OCI8 extension DLL to be loaded. Until someone who uses Windows and IIS gives me more info, everything I know is here: https://blogs.oracle.com/opal/entry/how_to_use_iis_php_and_oracle
I wouldn't try to use the OCI8 extension to connect to SQL Server, but you probably know that.