Informix Odbc Unspecified System Error 23101
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 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 Home Forums Non-SQL Forums MongoDB Database Server Software Adabas DB2 Informix Microsoft SQL Server MySQL Oracle Pervasive.SQL PostgreSQL Sybase Other Dat
with a mandatory word, e.g. keyword2 keyword1 +keyword2 Questions excluding a word, e.g. keyword2 keyword1 -keyword2 Questions with a specific tag and keyword(s) +[tag1] keyword1 Questions with two or more specific tags and keyword(s) +[tag1] +[tag2] keyword1 To search for all posts by a user or all posts with a specific tag, start typing and choose from the suggestion list. Tags Spaces API Connect Appsecdev BPM Blockchain Bluemix CICS Cloud Analytics Cloud marketplace http://www.dbforums.com/showthread.php?1613031-ODBC-connection-problem Content Services (ECM) Continuous Testing Courses DB2 LUW DataPower Decision Optimization DevOps Services Digital Experience Hadoop IBM Design IIDR ITOA InformationServer Integration Bus Internet of Things LinuxONE MDM Mainframe Messaging Node.js ODM Open Predictive Analytics PureData for Analytics Push Run Book Automation Storage Streamsdev Swift UrbanCode WASdev WSRR Watson dW Answers Help dW https://developer.ibm.com/answers/questions/205240/cant-access-informix-database-using-32-bit-driver.html Premium developerWorks Team Watson Health More Users Badges Ask a question Can't access Informix database using 32 bit driver from Windows 8.1 OS, while from Windows 7 64 bit OS works. Question by locarvey ( 1) | Jul 30, 2015 at 12:55 PM installationlocaleinformixregistry32 bit I have developed a VB .NET app using Informix Client SDK 4.10 32 bit. The client installed and the app works fine on Windows 7 64 bit OS. I am Admin of my Windows 8.1 32 bit OS. I installed the clientsdk.4.10.TC5DE.WIN.zip file. The install completes successfully. The ConnectTest.exe connects to Informix DB fine. However, the SETNET32.exe app fails because it 'could not open the registry'. The app fails with 'ERROR [HY000] [Informix .NET provider][Informix]Unspecified System Error = -23101' This error tells me 'Unable to load locale categories.' I have checked the values stored in the registry and even though I cannot edit them with SETNET32 they seem to be saved in registry
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 http://stackoverflow.com/questions/13865042/informix-connection-works-through-windows-but-not-through-cygwin 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 informix odbc 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 informix odbc unspecified 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/Client-SDK everything started working. I am not sure if the problem was the parentheses or the spaces, but getting them out of the path seemed to do the trick. share|impro