Re: Accessing Informix DB via ODBC

Posted in 2004

Sheshnarayan Agrawal — Wed, 26 May 2004 19:09:59 -0500 — source: Usenet: comp.databases.informix

--0__=08BBE432DF9394908f9e8a93df938690918c08BBE432DF939490 Content-type: multipart/alternative; Boundary="1__=08BBE432DF9394908f9e8a93df938690918c08BBE432DF939490" --1__=08BBE432DF9394908f9e8a93df938690918c08BBE432DF939490 Content-type: text/plain; charset=US-ASCII You don't need middleware....In your application you can provide the connection string as a DSN name(i.e DSN=mydsn; ) which you might have created using "ODBC Data Source Administrator" with Informix native ODBC Driver OR you can also provide the connection string in your own format ( refer Informix ODBC Programmer's Manual for more info ). You can also use Informix OLE DB or Informix .NET providers. Thanks & Regards -Shesh brobinson@munder. com (BRob) To: informix-list@iiug.org Sent by: cc: owner-informix-li Subject: Accessing Informix DB via ODBC st@iiug.org 05/26/2004 03:35 PM Please respond to brobinson Is it true that you can only access an Informix DB using a middleware product, like Intersolv? We want to query an Informix DB from a web application using IBM's native ODBC driver, but have heard that you need to have a middleware product or pay if developed on our own. --1__=08BBE432DF9394908f9e8a93df938690918c08BBE432DF939490 Content-type: text/html; charset=US-ASCII Content-Disposition: inline <html><body> You don't need middleware....In your application you can provide the connection string as a DSN name(i.e DSN=mydsn; ) which you might have created using "ODBC Data Source Administrator" with Informix native ODBC Driver OR you can also provide the connection string in your own format ( refer Informix ODBC Programmer's Manual for more info ). You can also use Informix OLE DB or Informix .NET providers. Thanks & Regards -Shesh <img src="cid:10__=08BBE432DF9394908f9e8a93df938@us.ibm.com" width="16" height="16" alt="Inactive hide details for brobinson@munder.com (BRob)">brobinson@munder.com (BRob) <table V5DOTBL=true width="100%" border="0" cellspacing="0" cellpadding="0"> <tr valign="top"><td width="1%"><img src="cid:20__=08BBE432DF9394908f9e8a93df938@us.ibm.com" border="0" height="1" width="72" alt=""> </td><td style="background-image:url(cid:30__=08BBE432DF9394908f9e8a93df938@us.ibm.com); background-repeat: no-repeat; " width="1%"><img src="cid:20__=08BBE432DF9394908f9e8a93df938@us.ibm.com" border="0" height="1" width="225" alt=""> <ul> <ul> <ul> <ul>brobinson@munder.com (BRob) Sent by: owner-informix-list@iiug.org 05/26/2004 03:35 PM Please respond to brobinson</ul> </ul> </ul> </ul> </td><td width="100%"><img src="cid:20__=08BBE432DF9394908f9e8a93df938@us.ibm.com" border="0" height="1" width="1" alt=""> To: informix-list@iiug.org cc: Subject: Accessing Informix DB via ODBC</td></tr> </table> <tt>Is it true that you can only access an Informix DB using a middleware product,  like Intersolv?  We want to query an Informix DB from a web application using IBM's native ODBC driver, but have heard that you need to have a middleware product or pay if developed on our own. </tt> </body></html> --1__=08BBE432DF9394908f9e8a93df938690918c08BBE432DF939490-- --0__=08BBE432DF9394908f9e8a93df938690918c08BBE432DF939490 Content-type: image/gif; name="graycol.gif" Content-Disposition: inline; filename="graycol.gif" Content-ID: <10__=08BBE432DF9394908f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAAQAKECAMzMzAAAAP///wAAACH5BAEAAAIALAAAAAAQABAAAAIXlI+py+0PopwxUbpu ZRfKZ2zgSJbmSRYAIf4fT3B0aW1pemVkIGJ5IFVsZWFkIFNtYXJ0U2F2ZXIhAAA7 --0__=08BBE432DF9394908f9e8a93df938690918c08BBE432DF939490 Content-type: image/gif; name="ecblank.gif" Content-Disposition: inline; filename="ecblank.gif" Content-ID: <20__=08BBE432DF9394908f9e8a93df938@us.ibm.com> Content-transfer-encoding: base64 R0lGODlhEAABAIAAAAAAAP///yH5BAEAAAEALAAAAAAQAAEAAAIEjI8ZBQA7 --0__=08BBE432DF9394908f9e8a93df938690918c08BBE432DF939490 Content-type: image/gif; name="pic00817.gif" Content-Disposition: inline; filename="pic00817.gif" Content-ID: <30__=08BBE432DF9394908f9e8a93df938@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 CgrMFsROrIEX3o2whVjWDjoJccN3LdggSGXLCdLEgHr1lyU3O3QxhgohNKXJCWv8JQr/PDdaqd6w 2rj1inLiGeiCJoDspAoQlYE6QWLSECehcWIYxIQES6zhbn1iImTHEQyqJ4eIxJJoUBc+3CbBuwZE V5cJPPkIjFDdeEabQbd6WgICTxiiz0f5dBKquXF6k4senwEhYGnKEFJeGrxUZy8dB8gmAXI/sPvH ESfCwVt5hTgYiqQqtdRNHQIU1PJ33ZqmzgE90OwLaoJcnMop1WiMmgkPHQRIrwgFuNV90A3doNKT mrKIN07AnGcI9BQjhCBN4RfA1qIZnMqorJCogKfGQnxSCDilTVIA0yl5ciTovgLuBDKFUDE9aQcw 9SA+rjSNf9/M1gxrj6VwDTS0IUSElMzBfsj0NFXR2kwsV1A5IF1grLgLL/r1R40BZEnuBWgmQEyb jqRwSAt6bqMCOFkvKFN2GPPkUzIm/SCF8z8pVzpbjVnMsy0vOr1hw3SaSRUhpY09v0z0J1FnwzPl fmh+xl4WtR0zGu24I4KbMQm3lnVu2oNWxI9W/lcyzA+mCKF4DBikxb/+UWtOGRiFP8qEwAayIgIA Ow== --0__=08BBE432DF9394908f9e8a93df938690918c08BBE432DF939490-- sending to informix-list