Informix Odbc Unspecified System Error
PDO_INFORMIX; -11041; Linux; IDS; connect Technote (troubleshooting) Problem(Abstract) -11041 error "Unspecified System Error" when trying to connect to IBM Informix database using the PDO_INFORMIX php driver. Symptom SQLSTATE=HY000, SQLDriverConnect: -11041 [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -11041 Cause The reason the error occurs is that the IBM Informix Client SDK environment variables are not set properly within the profile for user "root". The Apache Web Server is started by user "root" therefore the proper environment variables need to be set in the respective user's profile. Environment Unix Diagnosing the problem To diagnose the problem, one can simply use either truss or strace to see what the Apache process is doing. For example, using strace on Linux: 1) Stop Apache. 2) Start Apache as root with strace like this: [root@dns1 root]# strace -f -o /tmp/trace.txt /etc/apache2/bin/apache2ctl start 3) Run the php program within the browser until it errors. Within the trace.txt output, you will see a line similar to this: 11689 open("/root/.odbc.ini", O_RDONLY|O_LARGEFILE) = -1 EACCES (Permission denied) Resolving the problem Add the appropriate environment variables for IBM Informix Client SDK to the profile for user "root" and then restart the Apache Web Server. For example, you could add the following to /root/.bashrc on Linux: #Adding environment variables INFORMIXDIR=/opt/IBM/informix/ export INFORMIXDIR INFORMIXSQLHOSTS=/opt/IBM/informix/etc/sqlhosts export INFORMIXSQLHOSTS INFORMIXSERVER=smokehp_tcp export INFORMIXSERVER ODBCINI=/opt/IBM/informix/etc/odbc.ini export ODBCINI LD_LIBRARY_PATH=/opt/IBM/informix/lib:/opt/IBM/informix/lib/esql:/opt/IBM/informix/lib/cli:/opt/IBM/informix/lib/c++:/opt/IBM/informix/lib/client:/opt/IBM/informix/lib/dmi export LD_LIBRARY_PATH Document information More support for: Informix Tools Informix Client Software Development Kit (CSDK) Software version: 3.5 Operating system(s): Linux Reference #: 1454845 Modified date: 2012-09-21 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
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. Results 1 to 3 of 3 Thread: ODBC connection problem Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 12-19-06,08:52 #1 torrud View Profile View Forum http://www-01.ibm.com/support/docview.wss?uid=swg21454845 Posts Registered User Join Date Oct 2004 Posts 8 Unanswered: ODBC connection problem Hi, today I am downloaded the IBM Informix clientsdk.2.90.TC6.WIN and tried to get an ODBC connection to our informix server. But it heavenly failed with this error: Unspecified System Error = -11356.[Informix][Informix ODBC Driver][Informix]Unspecified System Error = -23101 I do not know what I should doing. If http://www.dbforums.com/showthread.php?1613031-ODBC-connection-problem I try to connect to the informix server via a JDBC connector all works fine. Does anyone knowing more about that error and how to solve the problem? Reply With Quote 12-22-06,19:18 #2 gurey View Profile View Forum Posts Registered User Join Date Aug 2003 Location Argentina Posts 780 Hi, Please, check you environment variable defined LANG, LC_COLLATE, DB_LOCLAE, CLIENT_LOCAL, and so on. Gustavo. Reply With Quote 12-23-06,03:05 #3 Tyveleyn View Profile View Forum Posts Registered User Join Date Aug 2006 Location The Netherlands Posts 248 Specifically check (with Setnet32) if the INFORMIXDIR variable is set to the directory where the clientsdk is installed. All Informix client products should be installed there (with exception to the JDBC classes). Regards Reply With Quote Quick Navigation Informix Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Data Access, Manipulation & Batch Languages ASP Crystal Reports Delphi, C etc JAVA Perl and the DBI PHP ANSI SQL Unix Shell Scri
van GoogleInloggenVerborgen veldenZoeken naar groepen of berichten
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top SSRS and Informix connection up vote 0 down vote favorite I have the IBM drivers installed, created a data source that successfully tests from SSRS front end. Create a report from my machine which also has the drivers installed and the ODBC testing correctly. I get the following error ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -23101. I run Select * from sysmaster:informix.sysdbslocale which returns en_US.819 for the database i want. Run Setnet32 and set CLIENT_LOCALE and DB_LOCALE to en_US.819 The client/server vars in the ODBC setting are set the same also. I'm not sure what else to try. ssrs informix share|improve this question asked Jul 27 '15 at 19:19 Tsukasa 1829 add a comment| 1 Answer 1 active oldest votes up vote 0 down vote When I use an Informix command finderr, I get the output shown: $ finderr -23101 -23101 Unable to load locale categories. An invalid locale name was supplied for the locale initialization. The environment variable specifying the locale category has a wrong value. Check the value of the corresponding environment variable, CLIENT_LOCALE or DB_LOCALE. If this error was encountered when using the "SET COLLATION" statement, check that the value passed to the statement is a valid locale. If this error was encountered when using the "SET NO COLLATION" statement, check that the session's default locale file is still available. Also check if INFORMIXDIR points to a valid directory where IBM Informix products are installed. If a client application receives this error when it requests a data