Solved

Need ODBC solution for COBOL data

Posted on 2014-12-30
6
277 Views
Last Modified: 2015-04-21
We have an old DOS-based business system that I'd like to be able to extract data from (easily)   - this will be a one-time exercise as we are migrating away from the DOS system.  Microfocus COBOL.  I'm looking at several tools which are all a little expensive - isn't there an ODBC driver out there that won't cost a lot?
0
Comment
Question by:cheningham1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 27

Expert Comment

by:tliotta
ID: 40524863
We have an old DOS-based business system that I'd like to be able to extract data from (easily)
Are you asking for an ODBC driver that somehow allows you to write in Mf COBOL to retrieve data from an old DOS-based database?

Can you tell us what that database is? I.e., what DBMS defines it? What platform is it installed on and how does it run?

Without knowing the DBMS, there is no good way to know if any ODBC driver was ever created. Makes it difficult to provide answers.

Tom
0
 

Author Comment

by:cheningham1
ID: 40525271
Yes, I am asking for an ODBC driver that I can use to extract data from application called Real World accounting.  We can get the data via text exports but I'm looking for something dynamic.  Products I've seen out on the web that would likely handle this include Parkway, Transoft, Relativity, but I'm not going to spend that level of $$$.
0
 
LVL 28

Accepted Solution

by:
Bill Bach earned 500 total points
ID: 40664329
I may be wrong, but I believe that the RealWorld accounting database uses the Btrieve/PSQL database engine for storage of all of its data.  Can you confirm whether you have either a Btrieve or Pervasive PSQL database engine on your database server?  

If you have Pervasive.SQL 7 or newer (V8, v9, v10, v11, or even v12), then you can use the native ODBC drivers that are provided with the full PSQL engine install.  If you have Btrieve 6.15, then only SOME of the engine licenses included the ODBC driver, so this may be a bit more troublesome.  In this case, search your stack of old 3.5" floppies and look for the Btrieve 6.15 ODBC drivers.  If you have them, then you'll have the drivers.  If not, then you might be stuck.

Once you have the ODBC drivers available, you're half-way home.  Unfortunately, the other half can be just as troublesome.  You need to now locate data dictionary files for your database.  Usually located somewhere int he application data folder, these files (with a DDF extension, like FILE.DDF, FIELD.DDF, etc.) provide the information about the low level database record layout that the the ODBC drivers need to parse the data properly.  If you cannot find DDF's, check with the application developer or support people, or perhaps a user group (in case someone else has built them).  If you don't have DDF's, things get VERY sticky real quick.

With the ODBC drivers and DDF's, the rest is academic.  Create a DSN that points to the database on the server, and you should be set.  

Since there are a LOT of IF's here, give me an idea if any of this is even close, and we can work through one issue at a time.
0
 

Expert Comment

by:cheningham2
ID: 40671324
I have moved on.  Thanks.
0
 
LVL 27

Expert Comment

by:tliotta
ID: 40724801
Near as I can determine, BillBach provided an actual (and the only) "answer" at http:#a40664329 .

Tom
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Azure Functions is a solution for easily running small pieces of code, or "functions," in the cloud. This article shows how to create one of these functions to write directly to Azure Table Storage.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question