hard time makeing SQL Anywhere extension work

604 views
Skip to first unread message

domnuprofesor

unread,
Aug 20, 2009, 6:46:05 AM8/20/09
to SQL Anywhere Web Development
Hello,

I have such a hard time making the PHP SQL Anywhere extension work.
I use xin xp, with the wamp distribution. I use php 5.2.8 and apache
2.

I have successfully installed SQL Anywhere version 11 on my system, I
did everything in "Getting Started with SQL Anywhere and PHP" white
paper. Still I get this very annoying error:

Warning: sasql_connect() [function.sasql-connect]: The SQLAnywhere
client libraries could not be loaded. Please ensure that dbcapi.dll
can be found in your PATH environment variable. in E:\eclipse-
workspace-PHP\sybase\apps\frontend\modules\home\actions
\actions.class.php on line 13

I checked and the file dbcapi.dll exists in the PATH environment
variable. I also tried to copy it in the php extension folder and to
the root of php installation BUT with no success.

PLEASE tell me what I am doing wrong, or what am I missing.
It is very frustrating for me.

Thank you,
Francisc Nopcea

Jim Graham

unread,
Aug 20, 2009, 12:15:10 PM8/20/09
to SQL Anywhere Web Development
Here are some things to try.

From the WAMP home page, click on the phpinfo() link. Search to the
"Environment" section and check the "Path". The directory "c:\Program
Files\SQL Anywhere 11\bin32" should be in the Path. This is the Path
being used by PHP, picked up from the PATH environment variable from
the WAMP environment.

From a command prompt, run "php -i >out" and open the file "out" in an
editor. Search to the "Environment" section and check the "Path".

As an experiment, change your PATH to have the SQL Anywhere directory
at the beginning. Perhaps there is a conflict with other software in
your PATH.

If this doesn't shed some light, please post the version number for
the SQL Anywhere PHP extension. You can find this in the "sqlanywhere"
section of the phpinfo() output. It would also be useful to have the
SQL Anywhere version you are using. You can find this by running Start
- All Programs - SQL Anywhere 11 - SQL Anywhere - Personal Server
Sample and cutting and pasting the first two lines of the output.

Copying the dbcapi.dll file to other locations will not help because
it depends on other files in the same directory. Make sure you clean
up the other files.
Reply all
Reply to author
Forward
0 new messages