Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to do ODBC connection to Paradox?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00666253
Message ID:
00666330
Views:
18
>>>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
Map
View

Click here to load this message in the networking platform