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
LVL 1
pure032398Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Applications

From novice to tech pro — start learning today.