RE: IBM .net Driver for Informix vs MSSQL .net driver
Jose, What version of CSDK you are using on the client. .NET support was introduced in CSDK 2.81.TC3 and had some problems (according to Tech Support). Even that you are using .NET, but behind the seen, the .NET provider is using ODBC (so all problem/bugs for ODBC drivers are inherited). A lot of enhancement and fixes were added to CSDK 2.90.TC3. Basim Chafik Senior Systems Analyst IBM Certified Advanced Technical Expert (CATE) 1.800.688.4895 basim.chafik@plx.com plexus (Division of BancTec) -----Original Message----- From: Jose da Fonseca [mailto:jose@lads.co.za] Sent: Thursday, September 22, 2005 7:28 AM To: informix-list@iiug.org Subject: IBM .net Driver for Informix vs MSSQL .net driver HI All, Has anybody had any experience with porting from MSSQL to Informix? We are have successfully ported the data from MSSQL to Informix ids 10 (two attempts - data types were a bummer). We are now finding performance issues when reading the same data from the Informix database. I am not sure what Microsoft have done in there driver but the getting of data from Informix whether ODBC or .net driver is credibly slow. This is what I have seen. Doing a select statement through dbaccess matches speed of doing same query on through enterprise manager on MSSQL. The moment you do the same query through vb.net we see the following: We have set the fetchbuffersize to max +- 32767 . On single record return selects , no visible diff...

RE: IBM .net Driver for Informix vs MSSQL .net driver #5
They are still do. The product name is Sequelink. The company is now Datadrect Basim Chafik Senior Systems Analyst IBM Certified Advanced Technical Expert (CATE) 1.800.688.4895 basim.chafik@plx.com plexus (Division of BancTec) -----Original Message----- From: Everett Mills [mailto:eemills@nationalbeef.com] Sent: Thursday, September 22, 2005 1:04 PM To: informix-list@iiug.org Subject: RE: IBM .net Driver for Informix vs MSSQL .net driver Guys- Merant used to make an Informix ODBC driver that was a lot faster than the one that comes with CSDK. I think they've been bought, but the product should still be out there somewhere. --EEM > -----Original Message----- > From: scottishpoet [mailto:dryburghj@yahoo.com] > Sent: Thursday, September 22, 2005 10:00 AM > To: informix-list@iiug.org > Subject: Re: IBM .net Driver for Informix vs MSSQL .net driver > > You may already have discussed this with your support provider and they > have informed you of the timescales to resolve this. > > If this is unacceptable you will need to discuss with your account team. sending to informix-list sending to informix-list ...

RE: IBM .net Driver for Informix vs MSSQL .net driver #3
Guys- Merant used to make an Informix ODBC driver that was a lot faster than the one that comes with CSDK. I think they've been bought, but the product should still be out there somewhere. --EEM > -----Original Message----- > From: scottishpoet [mailto:dryburghj@yahoo.com] > Sent: Thursday, September 22, 2005 10:00 AM > To: informix-list@iiug.org > Subject: Re: IBM .net Driver for Informix vs MSSQL .net driver > > You may already have discussed this with your support provider and they > have informed you of the timescales to resolve this. > > If this is unacceptable you will need to discuss with your account team. sending to informix-list ...

RE: IBM .net Driver for Informix vs MSSQL .net driver #4
Datadirect Technologies bought Merant. They have ODBC driver for Informix. -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Everett Mills Sent: Thursday, September 22, 2005 10:04 AM To: informix-list@iiug.org Subject: RE: IBM .net Driver for Informix vs MSSQL .net driver Guys- Merant used to make an Informix ODBC driver that was a lot faster than the one that comes with CSDK. I think they've been bought, but the product should still be out there somewhere. --EEM > -----Original Message----- > From: scottishpoet [mailto:dryburghj@yahoo.com] > Sent: Thursday, September 22, 2005 10:00 AM > To: informix-list@iiug.org > Subject: Re: IBM .net Driver for Informix vs MSSQL .net driver > > You may already have discussed this with your support provider and they > have informed you of the timescales to resolve this. > > If this is unacceptable you will need to discuss with your account team. sending to informix-list This e-mail is confidential and may be legally privileged. If you have received this message in error, you are notified of its status. Please inform the sender immediately and delete this message from your system. State and Federal law prohibit copying, dissemination, disclosure or other use of the contents of this e-mail by anyone other than the intended recipient. sending to informix-list the issue here is that the ...

RE: IBM .net Driver for Informix vs MSSQL .net driver #6
Thank you for that. We are using 2.90 xC3. We have tested the same thing with 2.81 and older and have the same problem. It may be that Microsoft have "super-tuned" there provider and Informix have not ? -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of Chafik, Basim Sent: Thursday, September 22, 2005 3:52 PM To: informix-list@iiug.org Subject: RE: IBM .net Driver for Informix vs MSSQL .net driver Jose, What version of CSDK you are using on the client. .NET support was introduced in CSDK 2.81.TC3 and had some problems (according to Tech Support). Even that you are using .NET, but behind the seen, the .NET provider is using ODBC (so all problem/bugs for ODBC drivers are inherited). A lot of enhancement and fixes were added to CSDK 2.90.TC3. Basim Chafik Senior Systems Analyst IBM Certified Advanced Technical Expert (CATE) 1.800.688.4895 basim.chafik@plx.com plexus (Division of BancTec) -----Original Message----- From: Jose da Fonseca [mailto:jose@lads.co.za] Sent: Thursday, September 22, 2005 7:28 AM To: informix-list@iiug.org Subject: IBM .net Driver for Informix vs MSSQL .net driver HI All, Has anybody had any experience with porting from MSSQL to Informix? We are have successfully ported the data from MSSQL to Informix ids 10 (two attempts - data types were a bummer). We are now finding performance issues when reading the same data from ...

RE: IBM .net Driver for Informix vs MSSQL .net driver #7
This is IBM's response : ( Unacceptable by the way ) Subject: IBM Informix case#439472 -"Performance is slow. Select on blob, inserts on blob" Dear John, I am the new case owner of IBM Informix case#439472 -"Performance is slow. Select on blob, inserts on blob" We currently have a feature #171522 "IBM INFORMIX NEEDS TO HAVE A FULLY MANAGED .NET PROVIDER" open which matches your problem. Please see the details below: >> One of the areas where the .Net application experience higher performance concerns is while it makes interoperation of managed and unmanaged code. The problem with mixing managed and unmanaged code in an application is that the unmanaged or native code doesn't recognized in the .NET environment. Managed code components not only depend on the classes available in the .NET Framework, they also expect the other components with which they interact to depend on that framework as well. Even the most trivial calls into native code must undergo a mode transition. The mode transition, which is the physical process of moving data between the managed and unmanaged modes of operation. Typically it requires about two dozens of instructions. The other cost involved in the process is marshalling the data to move across the boundary. Marshalling is necessary because the internal representation of data structures is different between managed and unmanaged code. To pass data across the boun...

RE: IBM .net Driver for Informix vs MSSQL .net driver #8
Would the OleDb provider prove to be any better/faster at this time than the .Net provider? --- Jose da Fonseca <jose@lads.co.za> wrote: > This is IBM's response : ( Unacceptable by the way ) > > Subject: IBM Informix case#439472 -"Performance is > slow. Select on blob, > inserts on blob" > > Dear John, > I am the new case owner of IBM Informix case#439472 > -"Performance is > slow. > Select on blob, inserts on blob" > > We currently have a feature #171522 "IBM INFORMIX > NEEDS TO HAVE A FULLY > MANAGED .NET PROVIDER" open which matches your > problem. Please see the > details below: > > >> > One of the areas where the .Net application > experience higher > performance > concerns is while it makes interoperation of managed > and unmanaged code. > > The problem with mixing managed and unmanaged code > in an application is > that the unmanaged or native code doesn't recognized > in the .NET > environment. Managed code components not only depend > on the classes > available in the .NET Framework, they also expect > the other components > with > which they interact to depend on that framework as > well. > > Even the most trivial calls into native code must > undergo a mode > transition. The mode transition, which is the > physical process of moving > ...

IBM .net Driver for Informix vs MSSQL .net driver
HI All, Has anybody had any experience with porting from MSSQL to Informix? We are have successfully ported the data from MSSQL to Informix ids 10 (two attempts - data types were a bummer). We are now finding performance issues when reading the same data from the Informix database. I am not sure what Microsoft have done in there driver but the getting of data from Informix whether ODBC or .net driver is credibly slow. This is what I have seen. Doing a select statement through dbaccess matches speed of doing same query on through enterprise manager on MSSQL. The moment you do the same query through vb.net we see the following: We have set the fetchbuffersize to max +- 32767 . On single record return selects , no visible difference. (select returns 1 column of varchar (200,0) average bytes per row 20) (select suburbname from area ) On select that returns +- 11768 rows : vb from same machine to mssql db on in intel 4 processor server 2003 machine < 1second Vb from same machine to IDS 10 on pa risc 8 way hp-ux server 8 seconds On select that returns +- 60000 rows : vb from same machine to mssql db on in intel 4 processor server 2003 machine < 1second Vb from same machine to IDS 10 on pa risc 8 way hp-ux server 8 seconds On a more complex select statement : Multiple table joins with nested loops. ...

Re: Driver Informix .Net #2
--0__=09BBE45CDFC5DA7A8f9e8a93df938690918c09BBE45CDFC5DA7A Content-type: multipart/alternative; Boundary="1__=09BBE45CDFC5DA7A8f9e8a93df938690918c09BBE45CDFC5DA7A" --1__=09BBE45CDFC5DA7A8f9e8a93df938690918c09BBE45CDFC5DA7A Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable The Informix .NET provider is packaged with CSDK 2.81.TC3. It is available at http://www14.software.ibm.com/webapp/download/search.jsp?go=3Dy&rs=3Dif= xdl Regards, Kanchana Padmanabhan Software Engineer R&D - IBM Data Management Group ...

Re: Driver Informix .Net
--0__=09BBE45CDFC7FD6C8f9e8a93df938690918c09BBE45CDFC7FD6C Content-type: multipart/alternative; Boundary="1__=09BBE45CDFC7FD6C8f9e8a93df938690918c09BBE45CDFC7FD6C" --1__=09BBE45CDFC7FD6C8f9e8a93df938690918c09BBE45CDFC7FD6C Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Informix CSDK version 2.81 includes a Informix .NET driver. Details ar= e in the URL below. http://www-306.ibm.com/software/data/informix/tools/csdk Click on the "Informix CSDK downloads" link in the same page to obtain = the versio for Windows. Venkatesh. |---------+----------------------------> | | "Jose Luis Rico | | | Botella" | | | <informatica@serp| | | is.com> | | | Sent by: | | | owner-informix-li| | | st@iiug.org | | | | | | | | | 07/12/2004 05:16 | | | AM | |---------+----------------------------> >--------------------------------------------------------------------= ----------------------------------------------------------| | = | | To: <informix-...

Informix .Net 2.0 driver
Guys- I installed CSDK 3.0 with the .Net 2.0 driver on my PC (XP Service Pack = 2, M$ Visual Studio 2005) and everything seems to work fine. The = Informix native driver works and everything is happy. I installed it on = an associate's computer (also XP Service Pack 2, M$ Visual Studio 2005) = and we get an error message every time it tries to access the native = driver as in this sample program:=20 'The Informix native client (C:\Program = Files\IBM\Informix\Client-SDK\bin\netf20\IBM.Data.Informix) was added as = a reference to this project. Imports IBM.Data.Informix Module Module1 Sub Main() Dim thisIfxConn As New IfxConnection() End Sub Note that all it does is initialize the driver. No open action or = anything else. The program dies right there with this error: System.TypeInitializationException was unhandled Message=3D"The type initializer for 'IBM.Data.Informix.IfxConnection' = threw an exception." The "Inner Exception" is this: {"DELIMIDENT - no error information available"} Delimident is not set on either computer. We tried rerunning the = installation to so a "repair" of the driver with no change in outcome. = I didn't find any reference to driver errors in the .Net manual and the = installation manual only covers a failed install. I am calling support, = but I thought someone may have run into this before. TIA, EEM Everett E...

Re: Driver Informix .Net #4
Jose Luis Rico Botella said: > Hello: > > How can I obtain a Informix .Net driver for Microsoft Net Platform?. Is it > available?. I *think* it's in the latest SDK. -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien � dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list ...

Re: Driver Informix .Net #3
--0__=08BBE45CDFC4631A8f9e8a93df938690918c08BBE45CDFC4631A Content-type: multipart/alternative; Boundary="1__=08BBE45CDFC4631A8f9e8a93df938690918c08BBE45CDFC4631A" --1__=08BBE45CDFC4631A8f9e8a93df938690918c08BBE45CDFC4631A Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable Yes it is available. You should be able to download the same from http://www-306.ibm.com/software/data/informix/tools/csdk/ It is part of IBM Informix CSDK 2.81.TC3. Thanks & Regards -Shesh ...

Re: Driver Informix .Net #5
--0__=08BBE45CDFE85D878f9e8a93df938690918c08BBE45CDFE85D87 Content-type: multipart/alternative; Boundary="1__=08BBE45CDFE85D878f9e8a93df938690918c08BBE45CDFE85D87" --1__=08BBE45CDFE85D878f9e8a93df938690918c08BBE45CDFE85D87 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: quoted-printable It is available with CSDK 2.81.TC3. Contact the IBM Informix sales and support office. http://www-306.ibm.com/software/data/informix/howtobuy/ Sincerely Rajesh Nair Software Development Manager Informix Open Connectivity & Web Administratio...

RE: IBM Informix ODBC driver #2
Hi. CSDK 2.81.TC2 is newer than 2.81.TC1. 2.81.TC2 is fiexed bug until 2.81.TC1. You may better use 2.81.TC2. Defect list exists in %INFORMIXDIR%\release\en_us\04e4\Defects.txt HTH -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: junedong@mail.chimei.org.tw (?L???V) >Reply-To: junedong@mail.chimei.org.tw (?L???V) >To: informix-list@iiug.org >Subject: IBM Informix ODBC driver >Date: 9 Feb 2004 17:40:37 -0800 > >I'm looking for IBM Informix ODBC driver for windows. >There are two different package available out there: >...

RE: [Informix][Informix ODBC Driver] Database locale information mismatch
You could try issuing the following statement and see what the engine is configured for. onstat -g env This will give you the environment of the engine. I believe it is listed there what the locale is set to. David -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of bobkot@gmail.com Sent: Tuesday, May 23, 2006 7:28 AM To: informix-list@iiug.org Subject: [Informix][Informix ODBC Driver] Database locale information mismatch I have download ClientSDK 2.90.TC4 I am trying to connect to an IDS10 database. My iLogin works fine, but I cannot set up the ODBC driver, I keep getting the message "[Informix][Informix ODBC Driver] Database locale information mismatch" I cannot leave it blank, under environment, and I cannot find any matching pairs. Can somebody help. XP client and Linux server _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list Version 10.00.UC4E is what I am running. How do I determine what the database was created with ? I have no customer support - that is me - so where to for the patches ? Would that be for the IDS or the SDK This is a multipart message in MIME format. --=_alternative 0023D97D65257178_= Content-Type: text/plain; charset="US-ASCII" To find out what's the database locale in your environment go to the server in...

Driver Informix .Net
Hello: How can I obtain a Informix .Net driver for Microsoft Net Platform?. Is it available?. Thanks, Jose L. Spain Hola: �D�nde puedo descargar el driver de Informix para la plataforma .Net de Microsoft?. Saludos, Jos� Luis Espa�a sending to informix-list Jose Luis Rico Botella wrote: > Hello: > > How can I obtain a Informix .Net driver for Microsoft Net Platform?. Is it available?. > > Thanks, > Jose L. > Spain > > > Hola: > > �D�nde puedo descargar el driver de Informix para la plataforma .Net de Micros...

.NET TransactionScope -> ERROR [HY000] [Informix][Informix ODBC Driver]General error
Hi using Microsoft Enterprise Library Data access App Block i have this code using (TransactionScope scope =3D new TransactionScope(TransactionScopeOption.Required)) { Database db1 =3D new GenericDatabase( ConnStringBuilder.ConnString, OdbcFactory.Instance); String sql1 =3D "insert into test_text values (51, 'holas1')"; db1.ExecuteNonQuery(CommandType.Text, sql1); scope.Complete(); } The ExecuteNonQuery causes this exception: No se control=F3 System.Data.Odbc.OdbcException Message=3D"ERROR [HY000] [Informix][Informix ODBC Driver]General error." Source=3D"iclit09b.dll" ErrorCode=3D-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.GetCo= nnection(Database db) en Microsoft.Practices.EnterpriseLibrary.Data.Database.GetOpenConnect...

Re: ANNOUNCE: IBM Informix Database Driver for Perl DBI Version 2005.01
bottom right side, click office, followed by edit current. Click the mail tab. Go to the bottom and change mime to rich text. Thanks to June Hunt I changed mine (mime) fairly recently! peace Jonathan Leffler <jleffler@earthli nk.net> To Sent by: informix-list@iiug.org ...

ANNOUNCE: DBD::Informix
IBM Informix Database Driver for Perl DBI Version 2005.01 (2005-03-14) has been uploaded to CPAN. IBM Informix Database Driver for Perl (also known as DBD::Informix) is the driver code that enables Perl 5.6.1 or later to access Informix databases via the DBI module (but if you are not already using Perl 5.8.5, you should be planning to upgrade to it). You will need the code for DBI version 1.38 or later as well (v1.48 recommended). The code for DBD::Informix is available for download via: http://www.perl.org/CPAN/modules/by-category/07_Database_Interfaces http://dbi.perl.org/ ** When you...

RE: IBM Informix ODBC driver
Hi. CSDK 2.81.TC2 is newer than 2.81.TC1. 2.81.TC2 is fiexed bug until 2.81.TC1. You may better use 2.81.TC2. Defect list exists in %INFORMIXDIR%\release\en_us\04e4\Defects.txt HTH -- Tsutomu Ogiwara from Tokyo Japan. ICQ#:168106592 >From: junedong@mail.chimei.org.tw (?L???V) >Reply-To: junedong@mail.chimei.org.tw (?L???V) >To: informix-list@iiug.org >Subject: IBM Informix ODBC driver >Date: 9 Feb 2004 17:40:37 -0800 > >I'm looking for IBM Informix ODBC driver for windows. >There are two different package available out there: >...

[Informix][Informix ODBC Driver] Database locale information mismatch
I have download ClientSDK 2.90.TC4 I am trying to connect to an IDS10 database. My iLogin works fine, but I cannot set up the ODBC driver, I keep getting the message "[Informix][Informix ODBC Driver] Database locale information mismatch" I cannot leave it blank, under environment, and I cannot find any matching pairs. Can somebody help. XP client and Linux server This is a multipart message in MIME format. --=_alternative 0046812965257177_= Content-Type: text/plain; charset="US-ASCII" I am guessing that you are using 10.00.xC4 or the version where you have fix for 171156 IDS defect. Basically this bug fix will enforce the correct database locale setting from client (i.e. ODBC etc). If you supply the (default is en_US.1252) correct database locale(that is actually the database created with) in ODBC DSN(or your connection string) then your connection should go through. However in ODBC side as well we have the corresponding fix in place. Ask your customer support to get the patch of ODBC defects 175110 and 175746. These ODBC fixes will automatically take care of getting the correct database locale value for the given database (through DSN). Thanks & Regards -Shesh bobkot@gmail.com Sent by: informix-list-bounces@iiug.org 05/23/2006 05:58 PM To informix-list@iiug.org cc Subject [Informix][Informix ODBC Driver] Database locale information mismatch I have download ClientSDK 2.90.T...

Re: IBM Informix ODBC driver #4
--0__=08BBE4A5DFC63CC68f9e8a93df938690918c08BBE4A5DFC63CC6 Content-type: multipart/alternative; Boundary="1__=08BBE4A5DFC63CC68f9e8a93df938690918c08BBE4A5DFC63CC6" --1__=08BBE4A5DFC63CC68f9e8a93df938690918c08BBE4A5DFC63CC6 Content-type: text/plain; charset=US-ASCII You should use CSDK.2.81.TC2.zip because its latest than the CSDK.2.81.TC1.WIN.zip. To verify the same you might want to look into "Defects.txt" file under %INFORMIXDIR%\release\en_us\04e4 directory. HTH -Shesh ...

Re: IBM Informix ODBC driver #3
--0__=08BBE4A5DFC63CC68f9e8a93df938690918c08BBE4A5DFC63CC6 Content-type: multipart/alternative; Boundary="1__=08BBE4A5DFC63CC68f9e8a93df938690918c08BBE4A5DFC63CC6" --1__=08BBE4A5DFC63CC68f9e8a93df938690918c08BBE4A5DFC63CC6 Content-type: text/plain; charset=US-ASCII You should use CSDK.2.81.TC2.zip because its latest than the CSDK.2.81.TC1.WIN.zip. To verify the same you might want to look into "Defects.txt" file under %INFORMIXDIR%\release\en_us\04e4 directory. HTH -Shesh ...