Re: Connecting to Informix
From: Mark Rae (mark_at_mark-N-O-S-P-A-M-rae.co.uk)
Date: 08/24/04
- Next message: Jay B. Harlow [MVP - Outlook]: "Re: Problem with string.indexofany"
- Previous message: Patty O'Dors: "Re: Single statement execution"
- In reply to: Mark: "Connecting to Informix"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 24 Aug 2004 15:10:14 +0100
"Mark" <mfield@idonotlikespam.cce.umn.edu> wrote in message
news:OVfWuCeiEHA.1048@tk2msftngp13.phx.gbl...
> We need to connect to an in-house informix database from a .NET web
> application. Any recommendations on:
>
> 1. Drivers.
> 2. Connection strings.
> 3. Ways to optimize speed?
>
> This particular app will be just retrieving and displaying data. No
> inserts/updates/etc.
I had to do this about a year ago. It involved installing a Win32 middleware
app on the IIS box, which included the ODBC drivers. It was to connect to a
legacy Informix DB running on UNIX, and no matter how hard I tried, I just
couldn't get the damn thing to connect via OleDb. ODBC was good enough,
though, because there was no realtime querying - just nightly data
exchanges, so performance wasn't really an issue.
This will give you examples of connection strings for OleDb & ODBC
http://www.connectionstrings.com/
Of course, if you can find a native .NET data provider which works, that
will almost certainly give you the best performance. IBM have released one,
but you'll need to check whether it will work with your particular version
of Informix.
http://weblogs.asp.net/adweigert/archive/2004/03/22/93909.aspx
- Next message: Jay B. Harlow [MVP - Outlook]: "Re: Problem with string.indexofany"
- Previous message: Patty O'Dors: "Re: Single statement execution"
- In reply to: Mark: "Connecting to Informix"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
