asked on

VFP9 error 2091 and access denied issues Server 2008 remote desktop.

We just completed a data and application migration from a Windows 2000 server to a Windows 2008 server environment. I'm having intermittent issues with my VFP9 applications.

The applications are running on a Windows 2008 R2 remote desktop server. The user sessions have drives mapped to the new file server, also a Windows Server 2008 R2, 64 bit.

I'm seeing intermittent errors, like 2091 - "table has become corrupted." Where the table of interest is not corrupted, and can be opened from vfp9.

Also, intermittently, I'll see 'access denied' errors opening a table. Examination of the security properties of the folder and tables in question shows Everyone to have full control.

any suggestions would be helpful.

ASKER CERTIFIED SOLUTION

Pavel Celba

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jrbbldr

Also you might want to look over some of the previous postings on similar topics such as:
https://www.experts-exchange.com/questions/26653753/FoxPro-app-with-SQL-ODBC-connection-won't-run-on-64-bit-system.html
https://www.experts-exchange.com/questions/21963464/ODBC-drivers-for-Windows-2003-x64-server.html
https://www.experts-exchange.com/questions/26347063/SQL-Server-2008-Enterprise-64-bit-trying-to-load-data-from-FoxPro-tables.html

Good Luck

jrbbldr

I might add that you should probably run testing in a local access to the SQL Server (not using Remote Desktop) to minimize the variables and to ensure that there are no contributing factors being introduced by accessing via Remote Deskop.

Good Luck

jn2112

ASKER

Had to look up how to turn off smb2 and opportunistic file locking elsewhere, but the solution was accurate