>Hello:
>
>I have a ERP application....its huge. It cost my company about 4 years of development by 3 to 5 fulltime developers and we have it installed in many sites.
>We built it using remote views, on a SQL Server 2000 and using ODBC (what else ;) )
>But, when it comes to data handling, it experiences problems. Many problems. First, It can't support concurrence very well, slowing down the network. Also, sometimes the application hangs with no reason. There is no piece of code we can identify as the culprit. Reviewing docs, we think that the problem lies with the ODBC connections. So there is the great question:
>What is the mos advanced database access technology we can use to replace ODBC? Also, we would like to replace as less code as possible.
>
>TIA
With Remote Views you don't have any chance other than ODBC. ODBC serves very well for me.
If you put RV and SPT aside, you can use OLEDB. In VFP6 you'd need ADO then. Starting with VFP8, OLEDB is supported through CursorAdapter.
Cetin