delphi - Could not open Paradox.net

Question

Trying Delphi 10.2 Tokyo with Paradox FireDAC ODBC on Windows 10 throws error ?Could not open Paradox.net. This link describes the problem: https://msdn.microsoft.com/en-us/library/bb221383(v=office.12).aspx

An Embarcadero FireDAC ODBC connection to Paradox table, by default will set ParadoxNetPath to System32 folder:

ODBCAdvanced=CollatingSequence=ASCII;DefaultDir=C:DEVTPDEMOSDATA;DriverId=538;MaxBufferSize=2048;MaxScanRows=8;PageTimeout=600;ParadoxNetPath=C:Windowssystem32;ParadoxNetStyle=4.x;ParadoxUserName=admin;SafeTransactions=0;Threads=3;UserCommitSync=Yes

There may be no write rights to that folder. An easy solution is to try to set it to some place where user has read/write rights. Eg. Temp folder.

Answer 1

I was having the same problem. I have defined in the ODBC settings: ParadoxNetPath = 'PDOXUSRS.NET file path'.

This file must be in a folder where the current user has read and write permissions, so you do not have to run the "As Administrator" program.

If you use the BDE Administrator, you can change the path of the PDOXUSRS.NET file, which is usually at the root of the C: directory.

Another alternative would be to just run the program as Administrator, since this is the master of the system, the problem of this is that depending on where the application is executed, the client will not be allowed to do this operation.