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 driverGuys-
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 mismatchYou 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 errorHi 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 mismatchI 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
...