Informix Odbc Error 23101
file .lco is missing Subscribe to this APAR By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product. Notify me when this APAR changes. Notify me when an APAR for this component changes. APAR status Closed as program error. Error description Environment: Informix SE 7.25.UC6R1 / Linux ILS 3.50.MC5 Error -23101 comes up when accessing a database with dbaccess with these locale settings: First create a test database with DB_LOCALE en_US.8859-1. CLIENT_LOCALE=lt_LT.8859-13 SERVER_LOCALE=lt_LT.8859-13 DB_LOCALE=lt_LT.8859-13 With DBACCESS -> Query-language -> SELECT DATABASES error -23101 "Unable to load locale categories" comes up The tool strace shows in case 2 21408 open("/opt/IBM/se-7.25.uc6r1/gls/lc11/en_us/0333.lco", O_RDONLY|O_LARGEFILE) = 6 21408 open("/opt/IBM/se-7.25.uc6r1/gls/lc11/lt_lt/0333.lco", O_RDONLY|O_LARGEFILE) = -1 ENOENT (No such file or directory) The locale file for codepage 8859-1 (0333.lco) is missing in $INFORMIXDIR/gls/lc11/lt_lt/ Lithuanian language is also affected. Local fix Problem summary **************************************************************** * USERS AFFECTED: * * lt_LT.8859-13 users of ILS 3.50 MC5 * **************************************************************** * PROBLEM DESCRIPTION: * * User unable to use databases created in different locales * * with dbaccess * **************************************************************** * RECOMMENDATION: * * Install ILS 3.50 MC6 when available * **************************************************************** Problem conclusion Could not reproduce with ILS 3.50 MC6. dbs created with different locales accessible through dbaccess when corresponding locale active in environment Temporary fix Comments For download information, go to: http://www.ibm.com/support/fixcentral APAR Information APAR numberIC78180 Reported component nameIBM IDS ENTRP E Reported component ID5724L2304 Reported releaseB15 StatusCLOSED PER PENoPE HIPERNoHIPER Special AttentionNoSpecatt Submitted date2011-08-17 Closed date2012-10-31 Last modified date2012-11-01 APAR is sysrouted FROM one or more of the following: APAR is sysrouted TO one or more of the following: Fix information Fixed component nameIBM IDS ENTRP E Fixed component ID5724L2304 Applicable component levels RB15 PSNUP RB15 PSYUP Document information More support for: Informix Servers Software version: B15 Reference #: IC78180 Modified date: 2012-11-01 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-
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 http://www-01.ibm.com/support/docview.wss?uid=swg1IC78180 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 http://www-01.ibm.com/support/docview.wss?uid=swg21454845 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 inform
från GoogleLogga inDolda fältSök efter grupper eller meddelanden
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Informix ODBC Driver 3.32 errors Want to Advertise Here? Solved Informix ODBC Driver 3.32 errors Posted on 2005-01-13 Databases 1 Verified Solution 2 Comments 12,209 Views Last Modified: 2012-08-14 This error is very confusing. I wouldn't be surprised if someone can not answer this question. I am offering 500 points. The problem is with the Informix ODBC Driver. We use Informix ODBC Driver 3.32 for Windows to connect via ODBC to an Informix server in a Windows XP environment. The client configuration will work for some time then quit working and provide an error. It is very odd. The connection may work for about 2-3 months or less and then stop. When you try to test connectivity with the ODBC it fails and provides this error code: Unspecified System Error = -11333 Unspecified System Error = -11356.[Informix][Informix ODBC Driver][Informix]Unspecified System Error = -23101 This error remains even after uninstalling, cleaning the registry of all Informix references and after reinstalling. I have compared registry entries with a working system and duplicated them. I have duplicated files and even checked the environment variable path. I have no other ideas. 0 Question by:bradylanter Facebook Twitter LinkedIn Google LVL 10 Best Solution bypeterside7 set INFORMIXDIR, PATH= $INFORMIXDIR\bin in autoexec.bat or look in autoexec.bat to delete all references Go to Solution 2 Comments LVL 10 Overall: Level 10 Databases 4 Message Accepted Solution by:peterside72005-01-13 set INFORMIXDIR, PATH= $INFORMIXDIR\bin in autoexec.bat or look in autoexec.bat to delete all references 0 Message Author Comment by:bradylanter2005-01-13 You were correct. I discovered an autoexec.bat in the C:\ of the 2 systems with the trouble. The odd thing is both systems were loaded using the same image and were both working for at least 1 mo