Hi,
Any samples on PHP connectivity to Oracle 9i on windows.
I am pulling data from my MS Access database and it gives me errror in inserting the date into the new Oracle database.
The actual error I am getting is:Warning: ocilogon(): _oci_open_server: OCI_INVALID_HANDLE in
At line number:
if ($c=OCILogon("scott", "tiger", "myDB")) {
//myDB is my database table name
The whole script is as follows:
<?
putenv('ORACLE_HOME=C:\oracle\ora92');
putenv('ORACLE_SID=myD😎;
putenv('TNS_ADMIN=C:\oracle\ora92\network\admin');
putenv("TWO_TASK=myDB");
$db = "(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = iabetaweb)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myD😎
)
)";
//$conn = ocilogon("scott", "tiger", $db);
if ($c=OCILogon("scott", "tiger", "myDB")) {
//show connectivity succeeded.
//select rows from database
Thanks in advance!
