Informix Odbc Unspecified Error
Contents |
check out the FAQ by clicking the link above. You may have to register before you informix unspecified system error can post: click the register link above to proceed. To start
Code-set Conversion Function Failed Due To Illegal Sequence Or Invalid Value
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 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 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
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 http://www.dbforums.com/showthread.php?1613031-ODBC-connection-problem 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) http://www-01.ibm.com/support/docview.wss?uid=swg21454845 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
från GoogleLogga inDolda fältSök efter grupper eller meddelanden
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 Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Informix connection works through Windows, but not through Cygwin up vote 1 down vote favorite Not really sure where to go with this one. I have a PHP script that invokes a PERL script that connects to an Informix database. This setup works just fine when I run the script to the Windows cmd prompt, but when I attempt to run it through cron in cygwin it fails on [Informix][Informix ODBC Driver]Unable to load translation shared library (DLL). (SQL-IM009) I have tried adding the Informix bin directory (/cygdrive/c/Program\ Files\ (x86)/IBM/Informix/Client-SDK/bin) to the PATH variable in the crontab file but there were no changes. I also tried adding that same directory to the INFORMIXDIR variable in the crontab file, but then I got the following error message [Informix][Informix ODBC Driver][Informix]Unspecified System Error = -23101. (SQL-HY000) If I look that error in finderr.exe (supplied by the driver) I see that it means that it is Unable to load locale categories or my INFORMIXDIR is incorrect, but I am not sure how to set the CLIENT_LOCALE or DB_LOCALE. Then I think I fixed this by using the correct directory separators and I dropped the bin subdirectory for the INFORMIXDIR variable in crontab, because I got the SQL-IM009 error again. I am using the Windows PHP and PERL executables in cygwin, so I am not really sure why it wouldn't work as it does if I run it through the cmd prompt. Would anybody know why this is? I am running this on a Windows Server 2008 R2 cloud instance, and I am attempting to copy a working setup that so that we can move it to an offsite location. cron odbc cygwin informix share|improve this question asked Dec 13 '12 at 17:17 danclark 5118 add a comment| 2 Answers 2 active oldest votes up vote 1 down vote It turns out that cygwin didn't like the directory that the Client-SDK was in. Once I reinstalled it to C:/IBM/Informix/Cl