Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing DB2 on AS/400
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00484513
Message ID:
00484626
Views:
15
Just using remote views anyway, no ADO.

Thanks buddy.

>Here is what I have heard....
>
>The OLE-DB Provider for DB2, from what I have been told, is a bit kludgy, but it works. The guy I spoke with found that in order to get things to work, the Recordset object was next to useless. Rather, he needed to use the Command Object. Updates through the Recordset did not work. Of course, if you step back for a moment, one should not try to do updates through the RS anyway. The fellow I talked with managed to get things to work. My guess is that most of his issues rested with understanding how ADO/OLE-DB worked. From a performance standpoint, he did go on to say that at times, it would get pokey. Of course, the comment was not qualified all that much. This conversation occurred about a year ago. Perhaps the story is better now.
>
>Here is a link that may help:
>
>http://www.as400network.com/Resources/ClubTech/TNT400/bo400ng/as400adomdac.htm
Jim Falino
Previous
Reply
Map
View

Click here to load this message in the networking platform