If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Connection problem using PDO php class (pdo_ibm driver)

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-24-11, 05:05
matteom matteom is offline
Registered User
 
Join Date: Jan 2011
Posts: 1
Connection problem using PDO php class (pdo_ibm driver)

Hi,

First of all, excuse me for my bad english...

i'm trying to connect my php webserver to an ids v.11.5 informix server.

I already configured DRDA connection and db2 runtime client because i'd to use pdo_ibm adapter.

From onmonitor i have these databases
When Log
Database Name Owner In Dbspace Created Status

sysmaster informix rootdbs 01/14/2011 U
sysutils informix rootdbs 01/14/2011 U
sysuser informix rootdbs 01/14/2011 U
sysadmin informix rootdbs 01/14/2011 U
test01 informix test01 01/14/2011 N
test02 informix test02 01/14/2011 U


If i try to connect to database test01 with following php instruction:
$sb = new PDO("ibm:hostname=192.168.10.60;database=test01;po rt=1527", "informix", "********");
or
$db = new PDO("ibmRIVER={IBM DB2 ODBC DRIVER};DATABASE=test01;HOSTNAME=192.168.10.60;POR T=1527;PROTOCOL=TCPIP;", "informix", "*******");

i receive:
SQLSTATE=HY011, SQLSetConnectAttr: -99999 [IBM][CLI Driver] CLI0126E Operation invalid at this time. SQLSTATE=HY011

the same instruction works correctly with the other database

$db = new PDO("ibm:hostname=192.168.10.60;database=test02;po rt=1527", "informix", "********");
or
$db = new PDO("ibmRIVER={IBM DB2 ODBC DRIVER};DATABASE=test02;HOSTNAME=192.168.10.60;POR T=1527;PROTOCOL=TCPIP;", "informix", "*******");

If i enable transaction (ontape -s -L 0) on test01 database i can connect correctly.

Why can't i connect to an informix database configured without transaction?

i don't understand if it's a problem of informix configuration or db2 client configuration or what else...

Thank you,

Last edited by matteom; 01-24-11 at 06:59.
Reply With Quote
Reply

Tags
informix pdo_ibm drda php

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On