I have to make a new interface for an old database, i have a database on sql anywhere 9 and an Asp.Net MVC 5 where I need to show database's data. I need to know the best ways should I use to connect both.
asked 11 Aug '15, 11:06
You generally have two options to connect from ADO.NET - direct ADO.NET or ODBC. For direct ADO.NET, you can use the included ADO.NET SQL Anywhere 9 driver (iAnywhere.Data.AsaClient.dll) that is included in the full SQL Anywhere 9 install in \win32. Be aware that it is a .NET 1.x assembly.
Otherwise, you can try the ADO.NET-ODBC bridge to the SQL Anywhere 9 ODBC driver via OdbcConnection, although this is not recommended for both compatibility and performance reasons.
answered 19 Aug '15, 17:39