Problem with PHP and SQL Anywhere Connectivity

[Former Member]

Hi,

We are trying connect sqlanywhere-16 to PHP 5.4.12 on both IIS and Apache server.

For that we have done below process as per the documentation provided by SQL Anywhere.

1. We have set the "C:\Program Files\SQL Anywhere 16\Bin32" folder path in environment variable.
2. Copy "php-5.4.12_sqlanywhere.dll" file from above directory into php extension folder.
3. Set extension_dir path to "ext" folder in php.ini.
4. Put "extension=php-5.4.12_sqlanywhere.dll" statement in php.ini
5. Restart All services "Apache/Mysql".

Still we got error "Unable to load dynamic library "C:/PHP/ext/php-5.4.12_sqlanywhere.dll"-%1 is not a valid Win32 application,

That’s why we could not execute the functions of sql Anywhere Connectivity. We have search most of the forums as well as SAP help sites.

So please guide us for the above issue.

[jeff_albion · Accepted solution]

Hi Vishal,

You will get the error "%1 is not a valid Win32 application," when you are mixing 32-bit and 64-bit libraries.

Is Apache / PHP 32-bit or 64-bit?

Regards,

Jeff Albion

SAP Active Global Support

[Former Member · Accepted solution]

Hi Jeff ,

Thank you so much for the reply.

I have used 32 bit PHP.

But now we have resolved above mentioned issue. Now we can connect PHP with SQL Anywhere successfully.

Regards,

Vishal Chikhalikar

PHP Programmer