Solved

Using DBase III With ODBC

Posted on 1998-03-23
2
2,169 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

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

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
As technology users and professionals, we’re always learning. Our universal interest in advancing our knowledge of the trade is unmatched by most industries. It’s a curiosity that makes sense, given the climate of change. Within that, there lies a…
Viewers will learn the different options available in the Backstage view in Excel 2013.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

730 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