On Wed, 24 Sep 2003 11:59:31 -0700, "Ryan Ternier" <rternier (AT) visualstatement (DOT) com> wrote:

¤ Hi, i'm trying to access an old Paradox file with vb.net using ODBC, but
¤ can't get anywhere with it.
¤
¤ Access can load the file, so I know I can get into it.
¤
¤ Any help would be much appreciated.
¤
¤ Attached is a zipped format of the DB file i'm working with
¤

I wasn't able to open it with Access at all using the ISAM driver. Do you know what version of
Paradox this file is in? Also, is there an associated index file?


Paul ~~~ pclement (AT) ameritech (DOT) net
Microsoft MVP (Visual Basic)

On Thu, 25 Sep 2003 08:02:35 -0700, "Ryan Ternier" <rternier (AT) visualstatement (DOT) com> wrote:

¤ I couldn't tell you. I've never worked with Paradox files before, so I am
¤ not sure what to look for.
¤ There are a lot of DB files within the folder I am working with. the
¤ C555main.DB is just one of 10 files I need to parse for information.
¤
¤ Here's another one I am able to open.
¤

I've tried Access 97 and XP and I get the same error message for both: "External table not in
expected format". This error can occur when the associated index file is missing.

Borland has a Viewer for Paradox tables but I don't have the BDE (Borland Database Engine)
installed.

http://info.borland.com/devsupport/bde/utilities.html


Paul ~~~ pclement (AT) ameritech (DOT) net
Microsoft MVP (Visual Basic)

I opened your first Paradox table using Borland Database Desktop and it look
ok ( 2 records).
A Paradox "database" is composed from all tables from a given folder...
The connection string should be something like:
"{Microsoft Paradox Driver (*.db)};DBQ=physical path to .db
file;DriverID=26" (if you use the Microsoft Paradox Driver, that might be
not compatible with the most recent Paradox versions)

Try to use the ODBC driver from Intersolv/Merant, Borland or from Corel
(they are not free as far as I know) .

Tudor Turcu
______________________

"Paul Clement" <UseAdddressAtEndofMessage (AT) swspectrum (DOT) com> wrote