Hello DTS Group,

This is a helpful group. I have a question. How to help SQL Server read a
particular table type.

Here is the environment: the table is a *.dbf, with a *.cdx. The table
runs/updated/etc
under the Novell operating system (an old version, 3 or 4) and is a table
in what is called "Advantage Database Server". This is also pretty old
(1991 or so)

I try copying the table and the index to a diff dir, and then use the import
feature of DTS to read the table (using a dBase IV DSN). Actually no
datasource of any flavor will work, it always returns an error message like
"unable to read rowid", or bad format.

Fox pro will read the table if I have an *.fpt around, the memo fields seem
to be a lost cause. Access does not like the table either. Fox Pro shows
7113 records, Delphi Database Desktop show 7108 records. I have been unable
to find any info on "exporting" data out of the Advantage database (but it
has help files on import!)

Any ideas on how to get at this data more or less accurately??? I have
tried excel too.

Thanks,

eric

I have never worked with this product but

1. How are you connecting to it now ?
2. Maybe you could get an ODBC driver for it and use that as an "Other
Connection"

http://www.advantagedatabase.com/ADS...er/default.htm

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"News Groups" <eholz.one (AT) verizon (DOT) net> wrote