Hi,
I've successfully connected with AS400 from VB6 sourcecode using OLDEDB and can select/update data by connection string as below:

"Provider=IBMDA400;Data source=SVRDEV;Username=USR;Password=PWD"

But my problems are:
- When user access application (use connection mentioned above), it invest a large of resource and the other users in my LAN network cannot access AS400 temporarily. It makes a "traffic-jam" and we have to restart server sometimes before everything can work as normal.
- It takes lots of time to finish an updateable query

So, anybody meet this issue and any solution for this case pls tell me asap. I look forwards your feedback here or email me at [email protected]

Thankyou very much.
Han

Han