Solved

Using DBase III With ODBC

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
null value 15 103
Partially Contained Databases - Cross Database Queries 3 52
SQL anywhere 11 databases 1 82
Database Design Dilemma 6 39
As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
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.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

832 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