My client wants to use his VPN to run his AREV32 app remotely. I told him I thought that to get around the slowness of running the OI engine remotely that we should try installing OI on his laptop and run an app that attaches all of the tables on the server. I have tried this and it seems to work with pretty good performance but I'm worried about problems under the covers like indexing and record locking (he's running the Network Driver). Also, would it be necessary to exactly duplicate the application name and path structure? What other problems are likely?

Thanks,

Jim

Installing the application locally and attaching to the data tables over the VPN is a good suggestion. As far as duplicating the application name and path that depends on the application and how it attaches to the tables.

The Universal Driver will keep the database consistent and locks active. The only concern is large selects/read next loops. Depending on the bandwidth and latency of the VPN these operations could appear noticeably slower.

Most of our clients opt for Remote Desktop / Citrix / 2x Application Server solution to work around any problems cause by complex database operations that get bogged down on the VPN. This would be the recommended method. If you need more information please let me know. 2x has a 3 user free perpetual license that can be a good way to get started and expand if needed.

View this thread on the Works forum...