ODBC and PHP4 nightmare

Anon

Ok so I understand ODBC support is built into PHP4. Great! Now I was running PHP306 on win32 and apache. I switched over to PHP4 and now I am getting TNS: resalution errors???? I did not change anything but the PHP version?? I made sure the functions like odbc_connect were still up to date with php4 and they are?? tnsnames.ora has not moved or been changed and when I switch back to PHP306 no problems? Any ideas! Please!

Deo

Anon

Well...I'm not alone, then !

Same prob for me... Everything works fine on ODBC Oracle side (with other apps, no prob).
Even ODBC with other database type (Access, Excel,...) works with PHP4. But when it comes to PHP<->ODBC Oracle, it's nightmare
:-(

Oracle driver responds : Cannot connect. In sql logs, the error is : ORA-12154 (TNS resolution)

Any good tip will be appreciated. Thanks.

Matt.

Anon

Matt,

SAME EXACT PROBLEM!! PHP4 bug!? I am trying the latest Oracle ODBC driver (8.1.6.1.0) now and will let you know how I made out. I am currently using Oracle ODBC driver (8.00.0400). Did not have much luck at all with The Microsoft ODBC driver for Oracle. What are you using? It would seem to me that there were a lot more people with this problem then just us!!!! Not like an Oracle8i back end is unusual. I want to run PHP4 SO BAD and this STINKS!! I developed 5 apps over the last 2 years that are totaly dependent on ODBC calls to Oracle. This really bites.

Deo

Anon

Matt,

You mentioned that your PHP4 works with other databases such as Access via ODBC. How did you get it to work? I have been running PHP3 on PWS or Apache and my applications work fine, until I upgrated to PHP4, and I keep getting error messages like "Warning: supplied argument is not a valid ODBC-Link resource in...." and I got the same thing with MySQL. Can you give me some hint how you got it to work with ODBC? My impression is that the binaries I downloaded did not compile the ODBC and MySQL in it like they had claimed.

Please help, thanks!!

Weihong Hendricks

Anon

You just have to be sure ODBC is well configured... then it will work fine with PHP ODBC functions. I did nothing special to get it work. But not with Oracle, so I had to step back to version 3...

Regards,
Matt