Thanks for the offer, but we chose a different path. Here's why:

1.) The ODBC driver didn't support btrieve 6.10 - only 6.15 and later. 2.) once we were able to connect and get most of the structure, we found that the (ahem) programmers cheated big-time. When they added email address and other fields to the contact information, they didn't put it in the database, but in ASCII files - so the data we were looking for wasn't where it should be. 3.) The company that wrote the original software is in bankruptcy court, so there was no chance of getting support.

Our final answer was to use a scripting tool to create a series of reports to ASCII, then combine them into a single table for processing. With most systems that we interface to, the hourly process takes less than 10 seconds - this one takes 20 minutes.

I envy those who don't have to interface to "legacy systems" . . .

Thanks again,

\/\/ayne



>>>>I'm trying to connect to a btrieve database that I have no idea what the table names are or what syntax to use on a SQL pass-through command.
>>>
>>>Try using SQLTABLES() to get a list of the tables in the database. You can then use SQLCOLUMNS() to get a list of the fields in each table.
>
>By now you've probably solved this? I do this every day, but the tables and structures are known. But just in case I can help?
>
>-Kevin