Connect to DB2 database

Swordm

Hello , ı can connect DB2 database with system dsn and this syntax ;

$server="systemdnsfile1"; #the name of the iSeries
$user="user"; 
$pass="pass"; 
$conn=odbc_connect($server,$user,$pass); 

but ı can not establish a PDO connection,
is datatables support connect to different databases ?

, tried this but not works ;

try {
  $connection = new PDO("ibm:YOUR_DSN_NAME", $user, $password, array(
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION)
  );
}
catch (Exception $e) {
  echo($e->getMessage());
}

allan

Hi,

I'm afraid that while Editor's PHP libraries do now have db2 support, they use the db2 _* functions in PHP (e.g. db2_connect()) rather than PDO.

Does your PHP install have the db2 functions available?

Allan

Swordm

Hello Allan I can install i think. But main issue is i can only use odbc system dsn to connect database.
With creating a system dsn at my computer windows then using above connection string i can connect to db2. Is it possible to use it or I have to use db2 functions?

allan

If you have to use the odbc functions in PHP you'd need to create another driver for the PHP libraries. Its not really as bad as it sounds though - the DB2 driver could act as a base line - duplicate it and update the methods as needed.

I've got a few things already going on at the moment, but if I get a chance I'll try setting up a suitable server to test with here.

Allan

Swordm

Thanks allan instead of that i ll try to get data with odbc process with json and try client side type.
If any update on db2 support with odbc I ll follow you