Cobol and Access-database

[tsunami100]

Hi,
Is there anybody who knows how i can make a link or connection between an access-database and a cobol-datafile ?

Thanks.

I choose my username Tsunami so that everytime somebody see this, he or she will remember this disaster where i lost a good friend.

 

[fredericofonseca]

depends on the COBOL vendor you are using.

If RM/COBOL (Liant) or Microfocus COBOL then you can use Relativity from Liant (

http://www.liant.com/products/relativity/)

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[tsunami100]

Hi,

Now i know that i can make a connection with ODBC.
What i need is the AcuODBC-driver.
Is this free to download and does anybody now where ?

Thanks.

I choose my username Tsunami so that everytime somebody see this, he or she will remember this disaster where i lost a good friend.

 

[3gm]

None of the AcuCOBOL stuff (AcuODBC, runtime, etc) is free or available for download.

You can use ADODB via ActiveX to get to Access, SQL Server, Excel, etc files in AcuCOBOL at no cost.

Regards.

Glenn

 

[tsunami100]

Thanks for your reply Glenn.

Is it possible to be a litlle bit more specific.
I don't have any clue about cobol so can you tell me what to do.
Thanks a lot

Best regards,

Lode.

I choose my username Tsunami so that everytime somebody see this, he or she will remember this disaster where i lost a good friend.

 

[MuadDubby]

Hi

The instructions Glenn mentioned should be applicable to any version of Cobol that has access to Active-x controls (Acu Cobol and MicroFocus Cobol are two good examples). Can you tell us what version/vendor you're using?

If the type of Cobol you're using supports this, you would end up using ADO just like from within VB (same methodology of using connections, recordsets, etc.), but the syntax of the verbs would be different (AcuCobol, for example, uses the MODIFY verb to execute a method, CREATE to instatiate an object, etc).

.DaviD.