Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

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

Siger%20Matt's gravatar image

Siger Matt
3.3k5672101
accept rate: 15%


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

permanent link

answered 22 Sep '11, 14:49

Volker%20Barth's gravatar image

Volker Barth
40.5k365556827
accept rate: 34%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×439
×70

question asked: 22 Sep '11, 13:44

question was seen: 2,698 times

last updated: 22 Sep '11, 18:01