ODBC and Clipper
Maksim Kozyarchuk
things I say seem dumb.
I am looking for a way to access a Clipper 5.0 Database via ODBC.
When, I used the Dbase 5 ODBC I was able to acess the DBF files, however
it seems to expext NDX and not NTX index files??? Also it seems to
complain that it is not an ISAM complient Database implying that I can't
do "my SQLs :)" against it.
1) Do I need a special ODBC-Clipper driver???
2) Can I do SQL with Clipper Database ????
Thank you Maksim.
Martin Mittelmann
>
> 1) Do I need a special ODBC-Clipper driver???
If you have to read NTX Files, yes.
> 2) Can I do SQL with Clipper Database ????
>
Yes, you can.
We use the ODBC Drivers from Intersolv in our company and we are very
satisfied with them.
Have a look at
http://www.intersolv.com/datadirect/odbcdrivers/frameset_dd_odbc.html
Martin
WMBaum
I don't think there's a dbf/ntx odbc driver, but I'd love to know
about it if there is one..
Clipper 5.2 and 5.3 also have access to foxpro cdx files, which I have
seen an odbc driver for..
In playing with MS Access one day, I noticed that you can create an
access database with tables that are merely links (pointers? forget
the word they used) to other databases, including dbf files. In
short, I think you can create an access database that is links to
various dbf's and their cdx files. The queries I ran from access
seemed to work.. I suspect you could hook up dbf databases with sql,
ado, asp, etc., in this manner..
Let me know if this helps at all, or works, or whatever..
--Bill
On Fri, 31 Jul 1998 09:18:52 -0400, Maksim Kozyarchuk
<unspe...@gs.com> wrote:
> I am looking for a way to access a Clipper 5.0 Database via ODBC.
>When, I used the Dbase 5 ODBC I was able to acess the DBF files, however
>it seems to expext NDX and not NTX index files??? Also it seems to
>complain that it is not an ISAM complient Database implying that I can't
>do "my SQLs :)" against it.
>
> 1) Do I need a special ODBC-Clipper driver???
Martin Mittelmann
>about it if there is one..
>
ntx-files.
http:\\www.intersolv.com
Martin
Maksim Kozyarchuk
I found two ODBC drivers for Clipper one made by Intersolv, the other is CodeBase 6.
Both of them are bundled under dBASE driver. However, I found that there is too much setup
needed when setting up data sources. (For each data source at setup time you need to link .dbf with .ntxs)
Codebase 5 provided a reasonable solution by providing
C library. The API is very similar in structure
to the Clipper language making it easy to port from Clipper to C.
http://www.sequiter.com/sequiter.htm
Maksim.
WMBaum wrote:
Hi,
I don't think there's a dbf/ntx odbc driver, but I'd love to know
about it if there is one..
Clipper 5.2 and 5.3 also have access to foxpro cdx files, which I have
Martin Mittelmann
>by Intersolv, the other is CodeBase 6.
>Both of them are bundled under dBASE driver.
>However, I found that there is too much setup
>needed when setting up data sources.
>(For each data source at setup time you need
>to link .dbf with .ntxs)
Maksim,
i don't know anything about the Codebase driver, but with the Intersolv ODBC
driver it's very easy:
You only have to create a datasource for the directory where your dbf and
ntx files are located.
In this directory you place a file which you can create with any
ascii-editor. It's name is "QEDBF.INI"
The format is easy to understand:
[CUSTOMER.DBF]
NUMMAINTAINED=2
MAINTAIN0=CUST1.NTX
MAINTAIN1=CUST2.NTX
[PRODUCTS.DBF]
NUMMAINTAINED=3
MAINTAIN0=PROD1.NTX
MAINTAIN1=PROD2.NTX
MAINTAIN2=PROD3.NTX
The ODBC Setup-Routine creates exactly this kind of file.
So you can just create a datasource for the directory where all this
files are located without connecting the indexes to the dbf files manually.
You don't have to use the "define" page in the ODBC-admin.
hth,
Martin