Re: Fujitsu ADO Data access guidance needed
- From: "Pete Dashwood" <dashwood@xxxxxxxxxxxxxx>
- Date: Sat, 26 Aug 2006 17:50:34 +1200
"Robin Lee" <robinlee@xxxxxxxx> wrote in message
news:Gu6dnTztv7qQlXLZnZ2dnUVZ_t-dnZ2d@xxxxxxxxxxxxxxx
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.
Then you will know it is quite OK to use it. (I disagree with Frederico on
this; I've used it a number of times and had no problems with it.) However,
for more detailed control, I find embedded SQL via ODBC is still the way to
go... Having said that, there is nothing to stop you creating an ADO object
through the COM interface and then using ADO commands to access whatever you
want. The Fujitsu provided control does this, but shields you from it.
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).
There seems to be some confusion here... These are COBOL file system
operations that really have nothing to do with Relational Databases. You
stated you want access to a SQL Server DB. You can certainly "mimic" these
operations against a RDB using a cursor, or a result set if you use access
via COM, but it is probably best not to think in these terms as it is tying
you to COBOL rather than to your data access needs.
I'm sure someone's been here before. Thank you to anyone who can help.
Without more idea as to what you are trying to do, it is difficult to be
specific.
If you don't find what you want, mail me privately.
Pete.
.
- Follow-Ups:
- Re: Fujitsu ADO Data access guidance needed
- From: Robin Lee
- Re: Fujitsu ADO Data access guidance needed
- References:
- Fujitsu ADO Data access guidance needed
- From: Robin Lee
- Fujitsu ADO Data access guidance needed
- Prev by Date: Re: Crazy COBOL system, need help with cob2csv
- Next by Date: Re: Whacko Russian Declines Field Medal
- Previous by thread: Re: Fujitsu ADO Data access guidance needed
- Next by thread: Re: Fujitsu ADO Data access guidance needed
- Index(es):
Relevant Pages
|
