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