.NET Provider for Informix

Posted in 2004

Topics: Connectivity: ODBC / JDBC / .NET

Pantelis Magos — Fri, 26 Mar 2004 12:46:36 — source: IIUG Forums & Mailing Lists

We 'd like to access (UNIX)Informix DS from .NET client applications. =20 Is it ok to use ODBC .NET Data Provider from Microsoft instead of the = (problematic?) Informix OLEDB ? Thanks.

↪ replying to Pantelis Magos

Rajesh Nair — Fri, 26 Mar 2004 14:58:28 — source: IIUG Forums & Mailing Lists

--0__=08BBE4F0DFC22D118f9e8a93df938690918c08BBE4F0DFC22D11 Content-type: multipart/alternative; Boundary="1__=08BBE4F0DFC22D118f9e8a93df938690918c08BBE4F0DFC22D11" --1__=08BBE4F0DFC22D118f9e8a93df938690918c08BBE4F0DFC22D11 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable The native Informix .NET provider is now available with the release of = IBM Informix CSDK 2.81.TC3. .NET applications written against IDS should preferably use this driver. Please contact IBM Informix sales and/or support to obtain this. Sincerely Rajesh Nair Software Development Manager Informix Open Connectivity & Web Administration IBM Data Management Solutions rajeshn@us.ibm.com Tel: (913) 599 7201 "All generalizations are dangerous even this one." = "Pantelis Magos" = <pas@logifer.gr> = Sent by: = To forum.subscriber@ ids@iiug.org = iiug.org = cc = Subj= ect 03/26/2004 06:46 .NET Provider for Informix [2749= ] AM = = = = = = We 'd like to access (UNIX)Informix DS from .NET client applications. =3D20 Is it ok to use ODBC .NET Data Provider from Microsoft instead of the =3D= (problematic?) Informix OLEDB ? Thanks. = --1__=08BBE4F0DFC22D118f9e8a93df938690918c08BBE4F0DFC22D11 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>The native Informix .NET provider is now available with the release = of IBM Informix CSDK 2.81.TC3. .NET applications written against IDS sh= ould preferably use this driver. Please contact IBM Informix sales and/= or support to obtain this.<br> <br> Sincerely<br> Rajesh Nair<br> <br> Software Development Manager<br> Informix Open Connectivity & Web Administration<br> IBM Data Management Solutions<br> rajeshn@us.ibm.com<br> Tel: (913) 599 7201<br> <br> "All generalizations are dangerous even this one."<br> <img src=3D"cid:10__=3D08BBE4F0DFC22D118f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Pantelis Mago= s" <pas@logifer.gr>">"Pantelis Magos" <pas@logi= fer.gr><br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE4F= 0DFC22D118f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">"Pantelis Magos" <pas@logifer.gr&g= t;</font></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: forum.subscriber@iiug.org</font> <p><font size=3D"2">03/26/2004 06:46 AM</font></ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE4F0DFC22D118f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE4F0DFC22D118f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">ids@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE4F0DFC22D118f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE4F0DFC22D118f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE4F0DFC22D118f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D08BBE4F0DFC22D118f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">.NET Provider for Informix [2749]</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D08BBE4F0DFC2= 2D118f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE4F0DFC22D118f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>We 'd like to access (UNIX)Informix DS from .NET client application= s.<br> =3D20<br> Is it ok to use ODBC .NET Data Provider from Microsoft instead of the =3D= <br> (problematic?) Informix OLEDB ?<br> Thanks.<br> <br> <br> </tt><br> </body></html>= --1__=08BBE4F0DFC22D118f9e8a93df938690918c08BBE4F0DFC22D11-- --0__=08BBE4F0DFC22D118f9e8a93df938690918c08BBE4F0DFC22D11 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=08BBE4F0DFC22D118f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=08BBE4F0DFC22D118f9e8a93df938690918c08BBE4F0DFC22D11 Content-type: image/gif; name="pic27273.gif" Content-Disposition: inline; filename="pic27273.gif" Content-ID: <20__=08BBE4F0DFC22D118f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg zMKPVxYJh23qm

↪ replying to Pantelis Magos

Sathyanesh Krishnan — Fri, 26 Mar 2004 16:28:50 — source: IIUG Forums & Mailing Lists

--0__=08BBE4F0DFC991E28f9e8a93df938690918c08BBE4F0DFC991E2 Content-type: multipart/alternative; Boundary="1__=08BBE4F0DFC991E28f9e8a93df938690918c08BBE4F0DFC991E2" --1__=08BBE4F0DFC991E28f9e8a93df938690918c08BBE4F0DFC991E2 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: quoted-printable Hi Pantelis Magos IBM Informix native .Net provider should be the recommended solution. .Net provider is part of IBM Informix Client SDK. Client SDK 2.81 TC3 is the latest. Regards, Satyan. = "Pantelis Magos" = <pas@logifer.gr> = Sent by: = To forum.subscriber@ ids@iiug.org = iiug.org = cc = Subj= ect 03/26/2004 06:46 .NET Provider for Informix [2749= ] AM = = = = = = We 'd like to access (UNIX)Informix DS from .NET client applications. =3D20 Is it ok to use ODBC .NET Data Provider from Microsoft instead of the =3D= (problematic?) Informix OLEDB ? Thanks. = --1__=08BBE4F0DFC991E28f9e8a93df938690918c08BBE4F0DFC991E2 Content-type: text/html; charset=US-ASCII Content-Disposition: inline Content-transfer-encoding: quoted-printable <html><body> <p>Hi <font size=3D"2">Pantelis Magos</font><br> <br> <font size=3D"4" face=3D"Times New Roman">IBM Informix native .Net prov= ider should be the recommended solution.</font><br> <font size=3D"4" face=3D"Times New Roman">.Net provider is part of IBM = Informix Client SDK.</font><br> <font size=3D"4" face=3D"Times New Roman">Client SDK 2.81 TC3 is the la= test.</font><br> <br> Regards,<br> Satyan.<br> <br> <img src=3D"cid:10__=3D08BBE4F0DFC991E28f9e8a93df938@us.ibm.com" width=3D= "16" height=3D"16" alt=3D"Inactive hide details for "Pantelis Mago= s" <pas@logifer.gr>">"Pantelis Magos" <pas@logi= fer.gr><br> <br> <br> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td style=3D"background-image:url(cid:20__=3D08BBE4F= 0DFC991E28f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " wid= th=3D"40%"> <ul> <ul> <ul> <ul><b><font size=3D"2">"Pantelis Magos" <pas@logifer.gr&g= t;</font></b><font size=3D"2"> </font><br> <font size=3D"2">Sent by: forum.subscriber@iiug.org</font> <p><font size=3D"2">03/26/2004 06:46 AM</font></ul> </ul> </ul> </ul> </td><td width=3D"60%"> <table width=3D"100%" border=3D"0" cellspacing=3D"0" cellpadding=3D"0">= <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE4F0DFC991E28f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">To</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE4F0DFC991E28f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">ids@iiug.org</font></td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE4F0DFC991E28f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">cc</font></div></td><td width=3D"= 100%"><img src=3D"cid:30__=3D08BBE4F0DFC991E28f9e8a93df938@us.ibm.com" = border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> </td></tr> <tr valign=3D"top"><td width=3D"1%" valign=3D"middle"><img src=3D"cid:3= 0__=3D08BBE4F0DFC991E28f9e8a93df938@us.ibm.com" border=3D"0" height=3D"= 1" width=3D"58" alt=3D""><br> <div align=3D"right"><font size=3D"2">Subject</font></div></td><td widt= h=3D"100%"><img src=3D"cid:30__=3D08BBE4F0DFC991E28f9e8a93df938@us.ibm.= com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><br> <font size=3D"2">.NET Provider for Informix [2749]</font></td></tr> </table> <table border=3D"0" cellspacing=3D"0" cellpadding=3D"0"> <tr valign=3D"top"><td width=3D"58"><img src=3D"cid:30__=3D08BBE4F0DFC9= 91E28f9e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt= =3D""></td><td width=3D"336"><img src=3D"cid:30__=3D08BBE4F0DFC991E28f9= e8a93df938@us.ibm.com" border=3D"0" height=3D"1" width=3D"1" alt=3D""><= /td></tr> </table> </td></tr> </table> <br> <tt>We 'd like to access (UNIX)Informix DS from .NET client application= s.<br> =3D20<br> Is it ok to use ODBC .NET Data Provider from Microsoft instead of the =3D= <br> (problematic?) Informix OLEDB ?<br> Thanks.<br> </tt><br> <br> </body></html>= --1__=08BBE4F0DFC991E28f9e8a93df938690918c08BBE4F0DFC991E2-- --0__=08BBE4F0DFC991E28f9e8a93df938690918c08BBE4F0DFC991E2 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=08BBE4F0DFC991E28f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=08BBE4F0DFC991E28f9e8a93df938690918c08BBE4F0DFC991E2 Content-type: image/gif; name="pic22627.gif" Content-Disposition: inline; filename="pic22627.gif" Content-ID: <20__=08BBE4F0DFC991E28f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhWABDALP/AAAAAK04Qf79/o+Gm7WuwlNObwoJFCsoSMDAwGFsmIuezf///wAAAAAAAAAA AAAAACH5BAEAAAgALAAAAABYAEMAQAT/EMlJq704682770RiFMRinqggEUNSHIchG0BCfHhOjAuh EDeUqTASLCbBhQrhG7xis2j0lssNDopE4jfIJhDaggI8YB1sZeZgLVA9YVCpnGagVjV171aRVrYR RghXcAGFhoUETwYxcXNyADJ3GlcSKGAwLwllVC1vjIUHBWsFilKQdI8GA5IcpApeJQt8L09lmgkH LZikoU5wjqcyAMMFrJIDPAKvCFletKSev1HBw8KrxtjZ2tvc3d5VyKtCKW3jfz4uMKmq3xu4N0nK BVoJQmx2LGVOmrqNjjJf2hHAQo/eDwJGTKhQMcgQEEAnEjFS98+RnW3smGkZU6ncCWav/4wYOnAI TihRL/4FEwbp28BXMMcoscQCVxlepL4IGDSCyJyVQOu0o7CjmLN50OZlqWmyFy5/6yBBuji0AxFR M00oQAqNIstqI6qKHUsWRAEAvagsmfUEAImyxgbmUpJk3IklNUtJOUAVLoUr1+wqDGTE4zk+T6FG uQb3SizBCwatiiUgCBN8vrz+zFjVyQ8FWkOlg4NQiZMB5QS8QO3mpOaKnL0Z2EKvNMSILEThKhCg zMKPVxYJh23qm9KNW7pArPynMqZDiErsTMqI+LRi3QAgkFUbXpuFKhSYZALd0O5RKa2z9EYKBbpb qxIKsjUPRgD7I2XYV6wyrOw92ykExP8NW4URhknC5dKGE4v4NENQj2jXjmfNgOZDaXb5glRmXQ33 YEWQYNcZFnrYcIQLNzyTFDQNkXIff0ExVlY4srziQk43inZgL4rwxxINMvpFFAz1KOODHiu+4aEw NEjFl5B3JIKWKF3k6I9bfUGp5ZZcdunll5IA4cuHvQQJ5gcsoCWOOUwgltIwAKRxJgbIkJAQZEq0 2YliZnpZZ4BH3CnYOXldOUOfQoYDqF1LFHbXCrO8xmRsfoXDXJ6ChjCAH3QlhJcT6VWE6FCkfCco@@NL

↪ replying to Pantelis Magos

Christine Normile — Fri, 26 Mar 2004 21:39:21 — source: IIUG Forums & Mailing Lists

For optimal performance with .Net, use the native .Net provide from IBM Client-SDK 2.81UC3. (http://www14.software.ibm.com/webapp/download/search.jsp?go=y&S_TACT=TrialsAndB etas&S_CMP=&s=&q=2.81.TC3). Or use the latest version of the OLE DB driver with any C-SDK 2.81. It was re-written for 2.81 and is much improved. Christine Normile I/T Specialist, Informix Solutions Data Management Worldwide Technical Enablement Telephone: 877-252-5399 T/L 273-0981 Mobile: 210-365-5073 "Pantelis Magos" <pas@logifer.gr> Sent by: forum.subscriber@iiug.org 03/26/2004 06:46 AM To: ids@iiug.org cc: Subject: .NET Provider for Informix [2749] We 'd like to access (UNIX)Informix DS from .NET client applications. =20 Is it ok to use ODBC .NET Data Provider from Microsoft instead of the = (problematic?) Informix OLEDB ? Thanks.

↪ replying to Christine Normile

CHRISTOPHER HUGHES — Tue, 30 Mar 2004 15:32:27 — source: IIUG Forums & Mailing Lists

Hi Christine I hope you can help me I am trying to add an ado.net connection in visual studio using csdk-TC3 as you suggested. We have Informix Online v7.3 The oledbadapter wizard will allow the connection to test successfully however i get a "Connection Failure" when i attempt to use this connection. any help is greatly appreciated. thanks - chris