After developing for more than 25 years on a Sybase (SAP ASE) database, we are migrating to MS SQL. We are using the native ASE interface for our database connection. We have some large Powerbuilder applications that rely heavily on this database. However, most of communication is done though stored procedures (data retrieval and insert/update/delete).
I'm just starting to look how we can connect our Powerbuilder applications to the MS SQL database but i'm not sure which to choose from. Reading the docs, it seems that i have these options:
- Standard Database Interface -> ADO.Net
- Native Database Interface ->
- MSOLEDBSQL SQL Server
- SNC SQL Native Client
The SNC looks outdated (don't know for sure, just by looking at the supported MS SQL versions). Besides the performance difference (i read somewhere that the standard database interfaces are slower than the native, but i'm not sure if we will notice this), what are the main differences choosing between the ADO.Net or the MSOLEDBSQL SQL Server?
Or maybe in other words -> since we have no legacy here, which one is more future proof?