Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement