Informix Odbc Driver General Error
be sure to 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: [Informix ODBC Driver] General Error 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 05-22-03,12:52 #1 putrwhz View Profile View Forum Posts Registered User Join Date May 2003 Posts 1 Unanswered: [Informix ODBC Driver] General Error I have a time tested application. I was running it against Informix 3.01 for several years without failure. Now I am being forced to upgrade to Informix ODBC 3.34 and/or 3.80 When running the application I recieve error -11060 (General Error) When i turned on SQL trace I discovered it was happening whenever a "Begin Work" statement was transacted. Any prognosis? It does not appear to have any effect on my functionality, but my customer will definetly not want the product with this error in it. Thanks for any suggestions or comments. Reply With Quote 05-29-03,08:40 #2 Roelwe View Profile View Forum Posts Visit Homepage Registered User Join Date Aug 2002 Location Belgium Posts 534 Check out this link from microsoft: http://msdn.microsoft.com/library/de...odch14pr_5.asp rws Reply With Quote 04-20-09,11:13 #3 pptron View Profile View Forum Posts Registered User Join Date Apr 2009 Posts 1 error -11060 (General Error) informix Hi, I had the same trouble. Maybe the causes are diferents, but I wnat to share it with us. I have a string with polish characters. Then char by char, i review it and I do a replace. the "enter" or char(13) in hexadecimal is like: H0D H0A (togheter). In my replacement I use: HOD changed by H20 (space) and H0A changed by NULL (H00). the final string look fine, and when I test it directly on an SQL Editor, my sentences (insert into) work very well, but when it instruction (insert into) is launched from my ODBC conection, it FAIL. To correct it mistake, I has changed H0D = H20 and H0A = H20 too. and I donīt have two separators char, justo one. And now I donīt have more this
von GoogleAnmeldenAusgeblendete FelderNach Gruppen oder Nachrichten suchen
code http://newsgroups.derkeiler.com/Archive/Comp/comp.databases.informix/2007-12/msg00002.html using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required)) { Database db1 = new GenericDatabase( ConnStringBuilder.ConnString, OdbcFactory.Instance); String sql1 = http://php.net/manual/en/ref.pdo-informix.connection.php "insert into test_text values (51, 'holas1')"; db1.ExecuteNonQuery(CommandType.Text, sql1); scope.Complete(); } The ExecuteNonQuery causes this exception: No informix odbc se controló System.Data.Odbc.OdbcException Message="ERROR [HY000] [Informix][Informix ODBC Driver]General error." Source="iclit09b.dll" ErrorCode=-2146232009 StackTrace: en System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) en System.Data.Odbc.OdbcConnection.Open_EnlistTransaction(Transaction transaction) en System.Data.Odbc.OdbcConnectionOpen.EnlistTransaction(Transaction transaction) en System.Data.Odbc.OdbcConnection.EnlistTransaction(Transaction transaction) en System.Data.Odbc.OdbcConnection.Open() en Microsoft.Practices.EnterpriseLibrary.Data.Database.GetNewOpenConnection() en Microsoft.Practices.EnterpriseLibrary.Data.TransactionScopeConnections.GetConnection(Database informix odbc driver db) en Microsoft.Practices.EnterpriseLibrary.Data.Database.GetOpenConnection(Boolean disposeInnerConnection) en Microsoft.Practices.EnterpriseLibrary.Data.Database.GetOpenConnection() en Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(DbCommand command) en Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteNonQuery(CommandType commandType, String commandText) en DataAppBlock.Form1.button7_Click(Object sender, EventArgs e) en C:\Proyectos\DotNet\SandBox\DataAppBlock\DataAppBlock \Form1.cs:línea 193 en System.Windows.Forms.Control.OnClick(EventArgs e) Aby idea why o what i miss ??? Thanks Enrique . Prev by Date: Re: Check to see if column exists in table Next by Date: Re: Informix Proves its worth Previous by thread: Re: Check to see if column exists in table Next by thread: DYNAMIC HASH JOIN and SEQUENTIAL SCAN Index(es): Date Thread Flag as inappropriate (AWS) Security UNIX Linux Coding Usenet ArchiveAboutPrivacyImprint newsgroups.derkeiler.com >Archive >Comp >comp.databases.informix >2007-12
Errors Exceptions Generators References Explained Predefined Variables Predefined Exceptions Predefined Interfaces and Classes Context options and parameters Supported Protocols and Wrappers Security Introduction General considerations Installed as CGI binary Installed as an Apache module Session Security Filesystem Security Database Security Error Reporting Using Register Globals User Submitted Data Magic Quotes Hiding PHP Keeping Current Features HTTP authentication with PHP Cookies Sessions Dealing with XForms Handling file uploads Using remote files Connection handling Persistent Database Connections Safe Mode Command line usage Garbage Collection DTrace Dynamic Tracing Function Reference Affecting PHP's Behaviour Audio Formats Manipulation Authentication Services Command Line Specific Extensions Compression and Archive Extensions Credit Card Processing Cryptography Extensions Database Extensions Date and Time Related Extensions File System Related Extensions Human Language and Character Encoding Support Image Processing and Generation Mail Related Extensions Mathematical Extensions Non-Text MIME Output Process Control Extensions Other Basic Extensions Other Services Search Engine Extensions Server Specific Extensions Session Extensions Text Processing Variable and Type Related Extensions Web Services Windows Only Extensions XML Manipulation Keyboard Shortcuts? This help j Next menu item k Previous menu item g p Previous man page g n Next man page G Scroll to bottom g g Scroll to top g h Goto homepage g s Goto search(current page) / Focus search box MySQL (PDO) » « Informix (PDO) PHP Manual Function Reference Database Extensions Abstraction Layers PDO PDO Drivers Informix (PDO) Change language: English Brazilian Portuguese Chinese (Simplified) French German Japanese Korean Romanian Russian Spanish Turkish Other Edit Report a Bug PDO_INFORMIX DSN (PECL PDO_INFORMIX >= 0.1.0)PDO_INFORMIX DSN — Connecting to Informix databases Description The PDO_INFORMIX Data Source Name (DSN) is based on the Informix ODBC DSN string. Details on configuring an Informix ODBC DSN are available from the »Informix Dynamic Server Information Center. The major compon