Hi,
i can't connect to a MaxDB database (server installed on my local machine) with PHP
4.*.
Code on my page:
<?
$db = odbc_connect("Driver={MaxDB};Server=p52600;Database=CRM_AUTO","WEBCLIENT",
"webclient")
or die('Unable to connect to MAXDB server!<br>' . odbc_error() .'<br>' .
odbc_errormsg());
?>
I get the following error msg:
Warning: odbc_connect(): SQL error: [MySQL MaxDB][SQLOD32 DLL][MaxDB] Invalid
authorization specification;-4008 POS(1) Unknown user
name/password combination, SQL state 28000 in SQLConnect in c:\programfiles\apache
group\apache\htdocs\phpinfo.php on line 16
Unable to connect to MAXDB server!
28000
[MySQL MaxDB][SQLOD32 DLL][MaxDB] Invalid authorization specification;-4008 POS(1)
Unknown user name/password combination
My configuration is: Win2000 + Apache 1.3 + PHP 4 + MaxDB 7.5
I've created a test database and some SQL users with the database manager. I also
created a user with 'Create user BLA password BLUP
resource' in SQL studio. If i run from the command shell 'dbmcli -d CRM_AUTO -u
dbm,dbm db_state i can see the state of the db.
But if try to connect with odbc from the web page with php, i get the error msg
mentioned above. Do i have to set a special operating system user for the local
machine from which php is executed? I also have the latest ODBC driver included in the
MaxDB installation.
Thanks for your help and regards,
Alex
