Using embedded SQL to create MS Access database

[geronimo1985]

Hi

I have a problem, I ve looked for it on google and other sources yet I cant find and answer... How can I create a MS Access database in Cobol (I use perCobol as compiler) using embedded SQL? COuld you also tell me how to connect to this database, and make tables and insert data. If you know only a part of the solution, please tell me. All help is very much appreciated. Thanks.

 

[Dimandja]

I suggest starting small.

1. Build an Access database manually. If you have a problem with that, try the Access forum somewhere here.

2. Use COBOL to open it, and access data. Does your environment support embedded SQL? Show us an example of that. Can you formulate a simple SELECT statement?

When you can do that, move on to creating Access databases programmatically. Why you must do it that way is puzzling.

Most of all, you need to show us some code.

__________________________________________
Try forum1391 for lively discussions

 

[WMK]

According to:

http://www.legacyj.com/FAQ/faq-sqlaccess.html

"Does PERCobol support accessing data SQL databases?

PERCobol accesses most databases through JDBC. (As far as a COBOL programmer is concerned it is SQL and is accessed as with most other COBOL compilers). SQL setup details"

with a link to:

http://www.legacyj.com/FAQ/faq-sql.html

I can't find any indication that Microsoft provides a JDCB driver for ACCESS - but there are some listed (for sale) on the web.

There is also the statement at:

http://www.legacyj.com/FAQ/faq-msaccess.html

"Does PERCobol allow accessing data stored in Microsoft Access?

Yes, LegacyJ has tested PERCobol with Microsoft Access and most real SQL databases."

So I would suggest using your support for more details.




Bill Klein