Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2201
  • Last Modified:

Using DBase III With ODBC

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
pure032398
Asked:
pure032398
1 Solution
 
NexialCommented:
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
 
pure032398Author Commented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now