Re: Help with: System.ArgumentException in IBM.Data.Informix.TypeMap.FromSqlType(SQL_TYPE sqlType)

Posted in 2012

Rajendra H Kamath — Tue, 3 Jan 2012 21:45:45 +0530 — source: Usenet: comp.databases.informix

The DRDA driver suite infact has two drivers underneath, the recommendation is to use the DB2.NET driver (supports Informix as well as DB2). Ref: http://www.ibm.com/developerworks/data/library/techarticle/dm-1007dsnetids/index.html Regards, Raj "Setting an example is not the main means of influencing another, it is the only means." --Albert Einstein From: Art Kagel <art.kagel@gmail.com> To: eferreyra <eferreyra@gmail.com> Cc: informix-list@iiug.org Date: 01/03/2012 09:13 PM Subject: Re: Help with: System.ArgumentException in IBM.Data.Informix.TypeMap.FromSqlType(SQL_TYPE sqlType) Sent by: informix-list-bounces@iiug.org Try the DRDA driver, it tends to be faster for .NET and the .NET feature support is a bit better also. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Tue, Jan 3, 2012 at 10:19 AM, eferreyra <eferreyra@gmail.com> wrote: Hi Art. Informix SQLI driver IBM Informix Client SDK 3.50.TC4DE (same problem with 3.70.TC3.WIN) On 3 ene, 11:39, Art Kagel <art.ka...@gmail.com> wrote: > Is this the Informix SQLI driver or the "Universal" DRDA driver? > > Art > > Art S. Kagel > Advanced DataTools (www.advancedatatools.com) > Blog:http://informix-myview.blogspot.com/ > > Disclaimer: Please keep in mind that my own opinions are my own opinions > and do not reflect on my employer, Advanced DataTools, the IIUG, nor any > other organization with which I am associated either explicitly, > implicitly, or by inference. Neither do those opinions reflect those of > other individuals affiliated with any entity with which I am affiliated nor > those of the entities themselves. > > > > > > > > On Tue, Jan 3, 2012 at 9:00 AM, eferreyra <eferre...@gmail.com> wrote: > > Have found that the problem is to determine the TYPE of the first > > DbCommand parameter, the first ?, if i use a constant value > > concatenated in the string problem goes away. > > > Still my workaround is to create a stored procedure that receives the > > varchars and return varchar so i can keep using parameters. > > > Yet, ugly bug. isnt there in ODBC provider. > > > > string sql = "SELECT DECRYPT_CHAR(field_encrypted, ?) <-- this ? > > apparently cant be resolved as SQL_TYPE and .Bind method fails. > > > AS field_decrypted" + > > > " FROM some_table WHERE id = 48084"; > > > snip. > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list