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. |
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... Yes indeed that is the answer. I had DBN in there but I had not specified the host. Please change your comment to an answer so I can accept.
(22 Sep '11, 15:00)
Siger Matt
Replies hidden
Done! Though you should be able to do so, too, according to the docs (and your rep points)...
(22 Sep '11, 18:01)
Volker Barth
|