PHP Module - How does it "See" or "Find" databases?

[former_SQLA_member1694868]

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.

[VolkerBarth · Accepted solution]

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...

[former_SQLA_member1694868 · Accepted solution]

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.

[VolkerBarth · Accepted solution]

Done! Though you should be able to do so, too, according to the docs (and your rep points)...