Hi all,
Strange problem here. I'm using the CGI install of php (4.1.something) on Win2k.
When I run my script from a command line, it connects fine to filemaker (I'm using odbc_connect).
When I run my script as a web page, It seems to connect to filemaker:
$pp_db = odbc_pconnect("fmSys","","password");
print ("pp_db = " . $pp_db . "<BR>"); // returns "Resource ID #1"
However, my queries are returning warning messages and are not processed:
PHP Warning: SQL error: [FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed, SQL state S1000 in SQLExecDirect in c:\inetpub\wwwroot\Integration\include\lib.odbc.php
Like I said, everything works fine when I use the command line. Also I can connect to a mysql database just fine with command line and through a web page.
Any clues?
Thanks,
Matt
