>>This may be a dumb question ... but does anyone out there know how to connect to a Paradox database from VFP using ODBC? I tried a way that works with Access, but the Paradox ODBC drivers appear to work a lot differently.
>
>What exactly is the problem? Did you try to create DSN using ODBC Manager?

Hi Sergey,

Yes, I created the DSN, that was the first thing I did. The driver for Paradox is quite a bit different from the Access driver. About all it does is allow you to give the DSN a name and tell it where to find tables. I named the DSN "ParadoxGeneric"

I created a DBC (pdxView.dbc), and did the Create Connection,

Create Connection (this.cConnection) DataSource (This.cConnection)
where This.Connection = "cxnParadoxGeneric"
and This.DataSource = "cxnParadoxGeneric"

When I use similar code with an Access DSN, I can get to the tables with a

Create SQL View viewTableName Connection (This.cConnection) ;
as select * from TableName

but this code fails on the Paradox connection.

Any ideas??? I am definitely not a master at this!

Thanks muchly!
Mike