Solved

Using DBase III With ODBC

Posted on 1998-03-23
2
2,178 Views
Last Modified: 2013-11-24
Hello All.
         I've got a number of DBase III (*.dbf) files i wish to use for my net page.
I've previously used MS Access which worked 150% perfectly.

My problem is this.
I've got the following files -> stock.dbf, orders.dbf and clients.dbf. I also have the following
indexes -> artist.ntx + title.ntx + stock.ntx, cliord.ntx, clients.ntx (for the above order).

My problem. Notice the indexes are nTx and not nDx. With the ODBC, it only allows nDx indexes
with the DBase III Files. I've tried using them and it doesn't work.

The only work around i've found is that i need to import the 3 dbf files, then export them out.
This solution is unaccetable becuase this process will need to be done everyday at 6:00pm by
someone working at their company, and they are (basically) computer illiterate.

So. Anyone know a solution to get my Dbase III *.dbf files and their indexes to work with ODBC?
Is there some 'converter' to convert *.nTx to *.nDx ?? Is the meaning of Life = 22?

Thank you kindly

Justin Adler
0
Comment
Question by:pure032398
[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
2 Comments
 
LVL 1

Accepted Solution

by:
Nexial earned 30 total points
ID: 1026208
I do not believe that NTX is a dBaseIII index extension.  It used to denote a Clipper proprietary index format, and is possibly in used by other xBase systems.   The easiest solution, if you have dbaseIII is to auto reindex your .dbf files under dBaseIII and generate the .ndx files you need.

It has been a long time, but you may be also able to set a configuration flag in your XBASE system (be it Clipper, or Foxpro, or...) to force all indexing to be dBaseIII .NDX format.

HOWEVER: Microsoft has said that ACCESS can read clipper files directly as dbase 4 files using the dBase ISAM.   Access does not support the UPDATE of the NTX format index files, but your application does not appear to require that.   If you need that then use the CLIPPER option that specifies use dBase IV format .NDX files, and then ACCESS can update them.

You could look at the Intersolv DataDirect dBase driver which supports Clipper format files and the
NTX format index files. You would then use Access' ODBC functionality to connect to the Clipper files.

     Hope this helps

0
 
LVL 1

Author Comment

by:pure032398
ID: 1026209
Thanks heaps! What I've done is to use a program called xDot (Xbase system thingy) which
is a demo version to transfer why dbf files into cdx, and then i'll try changing my ODBC
to use FOXPRO 2.6 instead of DBaseIII.

Anyways, your answer got me going. So thank you so much. Wish me luck!!

Jussy
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

624 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