I successfully connect with AS400 from VB6 sourcecode using OLDEDB and can select/update data by connection string as below:
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@example.com
Thankyou very much.