Hi,
I connect via ODBC to an economic system, works fine from a windows
commandline with this script:
<?
odbc_connect("name", "", "");
?>
But if I execute it in a browser via the Apache webserver (2.0.54) I get:
Warning: odbc_connect(): SQL error: [Simba][SimbaEngine ODBC Driver][DRM
File Library]General error., SQL state S1000 in SQLConnect in
C:htmltest.php on line 2
I don't understand why there is a difference, I just installed PHP and
Apache on this Windows XP workstation - any ideas? I read in the php.ini
that no dll's were required anymore for ODBC...!?
Best regards,
Christian Rasmussen
Full Version: ODBC connect possible from CLI but not web!?
| QUOTE |
| I connect via ODBC to an economic system, works fine from a windows commandline with this script: <? odbc_connect("name", "", ""); ? |
From commandline it's executed with your access rights. And uses php.exe.
| QUOTE |
| But if I execute it in a browser via the Apache webserver (2.0.54) I get: Warning: odbc_connect(): SQL error: [Simba][SimbaEngine ODBC Driver][DRM File Library]General error., SQL state S1000 in SQLConnect in C:htmltest.php on line 2 |
From browser it's executed with Apache / PHP access rights and uses
PHP module (dll) which can be configured differently than exe.
| QUOTE |
| I don't understand why there is a difference, I just installed PHP and Apache on this Windows XP workstation - any ideas? I read in the php.ini that no dll's were required anymore for ODBC...!? |
The difference is as described above and no ODBC DLLs are guilty.
Hilarion
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.