sasql_connect(): SQLAnywhere: [-100] Database server not found

[former_member926775]

hello dear friends

it's about more than one full day that i started sqlanywhere and i'm so interested to use it,

i worked before with sqlsrv for ms sql server and connection via php ,

but i have problem for connecting php to sqlanywhere

here is the warning message when i try to run test.php

-------------------------------------------------------------------------------------------------------------

Installation successful Using php-5.6.0_sqlanywhere.dll
Warning: sasql_connect(): SQLAnywhere: [-100] Database server not found in C:\xampp\htdocs\test.php on line 44
Connection failed

-------------------------------------------------------------------------------------------------------------

I'm using xampp server php 5.6 and sqlanywhere 17 developer edition

already i downloaded the php extension and copied on ext

demo database i ran it with cmd : dbeng17 "%SQLANYSAMP17%\demo.db"

please someone tell me what is problem ?

[former_member186998]

Hi,

I understood that you used 32 bit.
Did you compare the php.ini and odbc.ini with the PC which worked normally and the PC which did not work?
> Make sure that the proper files are being referenced in the php.ini and odbc.ini files.

You should compare the PC which does not work and the PC working normally.

Thanks,
Atsushi

[former_member186998]

Hi,

The cause to fail in the connection to a database has the following possibilities.
The php.ini file used references a different php sqlanywhere dll from the one that is being used. Or the odbc.ini file used references a different odbc connection from the one that made a successful connection.

You should confirm the following.
Make sure that the proper files are being referenced in the php.ini and odbc.ini files. And make sure that you are using the correct php driver (64 bit/32 bit).

Thanks,
Atsushi

[former_member926775]

Salam Alaikum Dear Mr. Atsushi

I installed sql anywhere 17 developer edition on 5 PCs , on first three system i couldn't connect but when i tried on my laptop and another PC it worked easily (i was so happy after 5 days trying i got simple connection 🙂 ).

all of my systems are 32bit, i have the correct driver php extension and also im running sql anywhere 32 bit but unfortunately it gives the same error and not recognize the database, i checked my systems but i really confused what's going on these systems? (all are same with same hardware/ software 32 bit)

* another thing MR. atsushi when i make new table in database via php there is no option like "refresh" to refresh table list and i should disconnect and connect again the table to show my new made table, in SQL server we have option by just simple click on table and refreshes all table.

thanks a million for your replies.

have a great day and i wish you a beautiful Year 2019 for you and your family

[former_member186998]

Hi,

2282305 - Not able to connect with to SQL Anywhere Database using PHP
2334453 - Where to find the current SAP SQL anywhere PHP extension and documentation?

In this case, can you confirm these pages?
These is pages of a SAP Knowledge Base Article. Login required to access the full version on SAP ONE Support launchpad.

Thanks,
Atsushi

[former_member926775]

hell dear atsushi ,

unfortunately i don't have s-user account, i just made and account to download trial version of sql anywhere

i only want to solve a very simple php connection to sql anywhere , i did all in tutorial and finaly i got this error when i use test.php

Installation successful Using php-5.6.0_sqlanywhere.dll
Warning: sasql_connect(): SQLAnywhere: [-100] Database server not found

any help will appreciate brother

[former_member186998]

Hi,

Can you confirm the following documents?

2282305 - Not able to connect with to SQL Anywhere Database using PHP
2334453 - Where to find the current SAP SQL anywhere PHP extension and documentation?

Thanks,
Atsushi

[former_member926775]

Hello Mr. Atsushi

thank you for your answer but unfortunately i late and the session seems to be expired

would you please help me again?

i'm waiting for you , thanks a million