I have the SQL Anywhere module loaded on a web server running IIS 7 on Windows 2008. The PHP version is 5.2.9 and the module matches that version for windows (only one option available for download so hopefully it's not a thread/threadsafe issue).
The database runs on another server on the same network running SQL 12 EBF 3324.
I had the sample page HITS.php running correctly on a local install for testing, but when I am testing it between servers, the PHP error log shows this message:
[22-Sep-2011 12:02:00] PHP Warning: sasql_connect() [<a href='function.sasql-connect'> function.sasql-connect</a>]: SQLAnywhere: [-100] Database server not found
I thought it might be a 32/64 bit thing as the web server is 32 and the DB is 64 and is running under a 64bit engine, but I tried running it using a 32 bit engine and it does not find it then either.
Any ideas for troubleshooting or fixing would be greatly appreciated.
asked 22 Sep '11, 13:44
I would think (but have not tried myself) that sasql-connect() makes use of the common connection parameters, so I hope HOST= and DBN= will be your friend with v12...
answered 22 Sep '11, 14:49