PHP oracle OCI connect to Oracle 7

[kennychw]

Hi
I'm writing a php script that connects to a Oracle 7 database using OCI.

The login is successful, the function OCIServerVersion() returns the server version text correctly

But when I perform a select statement, the data fetch is corrupted for example "¤ê¤ê<1-@¼’"

Below is my script

$conn = OCILogon("lds","lds",$db);
$stmt= ociparse($conn,"select * from tab ");
$status=OCIExecute($stmt);
$result = OCIresult($stmt,"TNAME");
print $result;

My Remote server is Oracle 7.2
PHP version 4.2.3
apache 1.3.12
I installed Oracle9 on the local server
OCI manages to login to the Oracle9 server and performs properly

What could be wrong?

[hrishy]

Hi

Try installing Oracle 7 on the local box from which ur running the php program and lets us know what happens.

regards
Hrishy

[bazza]

Sorry, are you going from oracle 7 to oracle 9 (or vice versa)? If so, its unlikely to work, there is no net compatibility between the versions.

Bazza

[kennychw]

hi Bazza
I'm connecting from Oracle 9 to 7
So I guess there is no compatibility??

[bazza]

Originally posted by kennychw
hi Bazza
I'm connecting from Oracle 9 to 7
So I guess there is no compatibility??

correct