Me neither, 11041 is bad DSN or can't find ini file - the DSN looks fine to me ....
I think open source ODBC driver comes with a tool that can test comms from the command line, you give it the ini file path from command line
Cheers
Paul
Paul Watson
Oninit LLC
+1-913-387-7529
www.oninit.com
Oninit®️ is a registered trademark of Oninit LLC
Original Message:
Sent: 1/8/2021 11:22:00 AM
From: BRUNO ORTIZ
Subject: RE: Need help to Informix and PHP con
Hi Paul,
humm, i really don't know how to answer you, is there any way to get another return ? Because i believe it is
------------------------------
BRUNO ORTIZ
------------------------------
Original Message:
Sent: Fri January 08, 2021 11:05 AM
From: Paul Watson
Subject: Need help to Informix and PHP con
Is PHP actually finding the ini file ?
Cheers
Paul
Original Message:
Sent: 1/8/2021 10:55:00 AM
From: Art Kagel
Subject: RE: Need help to Informix and PHP con
Bruno:
I don't see anything wrong with either the connection string or the DNS definition in the odbc.ini file.
At first I thought "Maybe the 3.70 CSDK didn't support scrollable cursors, but no, I checked and that's fine.
I just don't use ODBC enough to have a quick answer for you. Anyone else?
Art
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Fri January 08, 2021 10:39 AM
From: BRUNO ORTIZ
Subject: Need help to Informix and PHP con
Hi Sheshnarayan,
My String con is:
try {
/*$db = new PDO("informix:host=172.16.18.120; service=9088;
database=bd_jpessoa_m; server=ol_matriz; protocol=onsoctcp;
EnableScrollableCursors=1;", "informix", "loooge");*/ <-- On this version i have the Error [Informix][Informix ODBC Driver]Unspecified System Error = -11005.
$db =new PDO("informix:DSN=Infdrv33", "", ""); <-- On this version i have the Error :
SQLSTATE=HY000, SQLDriverConnect: -11041 [Informix][Informix ODBC Driver]Unspecified System Error = -11041.1
with this odbc.ini
[Infdrv33]
Driver=/opt/informix/lib/cli/iclis09b.so
Description=INFORMIX 3.3 32-BIT
Database=bd_jpessoa_m
LogonID=informix
pwd=loooge
Servername=ol_matriz
DB_LOCALE=en_US.819
OPTIMIZEAUTOCOMMIT=1
ENABLESCROLLABLECURSORS=1
$stmt = $db->query("select * from cadprod");
$res = $stmt->fetch( PDO::FETCH_BOTH );
$rows = $res[0];
echo "Table contents: $rows.</br>";
} catch (PDOException $e) {
echo "ERR : " . $e->getMessage();
}
Any idea ?
thanks !
------------------------------
BRUNO ORTIZ
Original Message:
Sent: Fri January 08, 2021 01:35 AM
From: Sheshnarayan Agrawal
Subject: Need help to Informix and PHP con
Hi Bruno,
What's the version of CSDK you are using (esql -V)? Sometimes this issue comes due to 32/64-bit mismatches. The error code suggests that it has indeed connected to database, could you check the session to be available on the database side? Could you share the connection string you are using?
-11005 : Invalid connection string attribute.
For SQLDriverConnect(), the function returned SQL_SUCCESS_WITH_INFO, which means that the function completed successfully, and that a nonfatal error occurred. The nonfatal error occurred because the connection string contains an invalid attribute keyword, but Informix CLI connected to the data source anyway. For more information, call SQLError().
Thanks
-Shesh
------------------------------
Sheshnarayan Agrawal
Original Message:
Sent: Thu January 07, 2021 06:01 PM
From: BRUNO ORTIZ
Subject: Need help to Informix and PHP con
Hello there,
i had issues with php connection and Informix in OpenSuse, this is my error, when i try the connection:
SQLSTATE=HY000, SQLDriverConnect: -11005 [Informix][Informix ODBC Driver]Unspecified System Error = -11005.
Can anybody help me?
------------------------------
BRUNO ORTIZ
------------------------------
#Informix