Re: Fujitsu ADO Data access guidance needed



On Fri, 25 Aug 2006 10:23:31 -0400, Robin Lee <robinlee@xxxxxxxx>
wrote:

Could someone please provide some sample code or point me to a good
tutorial or reference material regarding the use of ADO to access
Microsoft SQL server, under Fujitsu PowerCobol v6.1

Some years ago I recall that I used embedded and SQL and ODBC with Fuji
version 5 but that's all rather fuzzy to me now. I think I saw a post
here stating that ADO is better.

I've used the samples provided with the v6.1 compiler, utilizing the
AdoDataAccess control to successfully connect to and browse a known
dataset, but the examples are very elementary.

I'm hoping to come up with some simple code to perform typical COBOL
data access along the lines of traditional START KEY/READ NEXT (UNTIL).

I'm sure someone's been here before. Thank you to anyone who can help.
First of all DO NOT use their control. it will give you more headaches
than you are expecting.

Second search google for that subject, as I have post a few things
about it already.

www.tek-tips.com also has a few samples of mine on the FAQ's of COBOL.

As for full samples, you really need to refer to how other (in VB) use
recordsets, as that is how you will also need to do. Just adapt the
methods to the way COBOL constructs them.

Also stay away from bound controls if you can.


Frederico Fonseca
ema il: frederico_fonseca at syssoft-int.com
.



Relevant Pages

  • Re: VB6 Winsock action on Server
    ... With the introduction on your part of ADO and DBMS. ... to be used to connect and manage data flow between client and DB? ... I think the issue is namely how to control concurrent access. ...
    (microsoft.public.vb.general.discussion)
  • Re: VB6 - Using Unbound Controls
    ... The VB6 Forms use Data Controls and ADO. ... I've developed Access Apps w/ Unbound ... Controls using DAO for almost 6 years, ... selected data from the Field data saved by the Data Control in the VB6 ...
    (microsoft.public.vb.general.discussion)
  • Re: ADO control and SQL Session
    ... In my testing, if I open a VBA form with ADO control, sp_who ... I closed the form,reopen it, the number of sql session ... I close the ADO record set connection ...
    (microsoft.public.vb.controls)
  • Re: Cobol MS-Access
    ... Micro Focus COBOL.> ... ODBC driver, sometimes without requiring any change to the COBOL code, BUT ... Cursors in ODBC hold the DB connection for as long as the cursor is open. ... DAO or ADO, both of which are many times more efficient than ODBC. ...
    (comp.lang.cobol)
  • Re: How do I list files in directory?
    ... It's got nothing to do with ADO. ... >intrinsic control for listing files in a given directory. ... And thank you to Larry and Ruskin too!! ...
    (microsoft.public.vb.general.discussion)