One of our users got a new pc this week. He has some Excel pivot tables that are reading data from Paradox tables via an odbc connection. Every time he tries to refresh the data, he gets an error message saying 'Could not open Paradox.net'. From what I understand, Paradox.net is the DOS version of pdoxusrs.net. I had the user send me the Excel file and the table it was trying to access and it worked fine for me after setting up the alias that he initially used when he built this pivot table.
I had the user search his hard drive for a file called Paradox.net, and one did not exist. Does anyone have any idea why it would be looking for this file?
Paradox.net along with PDoxuser.net are used by the Borland Database Engine (BDE). So, any and every ODBC driver should respect that and use them in the same way as the BDE. Otherwise, you would not be able to use it for multi-user uses. So, try and see how you configure the net dir for your ODBC driver.
Also, are you using Vista? If so, perhaps your ODBC driver defaults the net dir to C:\ which would cause a similar error. So, same answer, figure out how to specify the net dir.
Paradox
Print This
