through ado.net
It would be my assumption that being that the DataReader is maintaining
state it may be attempting to use a client side cursor.
Steve Miller
G. A. Sullivan
-Original Message-
From: dotnet discussion [mailto:[EMAIL PROTECTED]] On Behalf Of
Christopher Castelot
Sent: Friday, May
uck
-Original Message-
From: dotnet discussion [mailto:[EMAIL PROTECTED]] On Behalf Of
Christopher Castelot
Sent: Thursday, May 02, 2002 3:30 PM
To: [EMAIL PROTECTED]
Subject: [DOTNET] Accessing AS400 data through ado.net
Hi all,
I work in an environment which has most inventory and distri
Ignore my previous note. I was confusing closing the DataReader with the
Connection. Having the one connection definitely increases the performance,
I am not sure by how much yet though.
-Original Message-
From: Christopher Castelot [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 03, 2002
ou only will be using the 400 for this
application, use the SQL extensions for blocking the inserts.
Good luck
-Original Message-
From: dotnet discussion [mailto:[EMAIL PROTECTED]] On Behalf Of
Christopher Castelot
Sent: Thursday, May 02, 2002 3:30 PM
To: [EMAIL PROTECTED]
Subject: [DOT
Hi all,
I work in an environment which has most inventory and distribution data on
an AS400. The company also has an Oracle 8i database for client server apps
and web based business. For all intents and purposes the Oracle database is
a mirror of the 400. However, all data is entered on to the 40
