odbc_connect fails to work with a remote dsn

[handro1104]

This is my code:

Code: Select all

$DBNAME = "sluggo";
$DBUSER = "xxxx";
$DBPASSWD = "xxxxx";
$CONNECTION = odbc_connect ($DBNAME, $DBUSER, $DBPASSWD);


The database is a DB2 database in a Linux server. Connecting from the ODBC screen "CLI/ODBC Setting - sluggo" works fine, but I am getting a FALSE value for $CONNECTION.

Locally I am using Wamp; I put "php_ibm_db2.dll" in the ext folder of php and in the php.ini file I set "extension=php_ibm_db2.dll".

Your help will be greatly appreciated.

[johnj]

are you sure that the database name, user name and password is correct?

[johnj]

Please read about odbc_error() and trap that error.