I have just started trying to get PHP to connect to an ODBC database which is on an AS/400 and I have the appropriate drivers loaded. (Running Win 2k, IIS 5
php4.3.1). I can access the database on the AS400 thru MS Access,but when trying to access it thru PHP i get:

Warning: SQL error: [IBM][Client Access ODBC Driver (32-bit)][DB2/400
SQL]Communication link failure. COMM RC=0x5, SQL state 08S01 in SQLConnect

My connection looks like this in Php.

$ODBC_DSName = "Name"
$ODBC_UserName= "User"
$ODBC_UserPass = "Pass"

$conn = odbc_connect($ODBCName,$ODBC_User,$ODBC_Pass);

Is there something I'am missing?

Thanks.

    Is your ODBC DSN set up as a user DSN or a sytem DSN? It needs to be the latter.

      Write a Reply...