General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>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,
Found the problem ... apparently there are some "lock" files that came with the data we were converting. The ODBC driver was sending back a cryptic message similar to "The directory is controlled by other .Net file" ... and then got a similar message from Paradox itself, followed by a message about "locks". I removed the Paradox.lck and PdoxUsrs.lck files ... and connections went through.
Mike
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only