From: Bauer, Alexander (alexander.bauersap.com)
Date: Tue May 25 2004 - 09:08:11 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]