Existe Is there any way to conect an old database on SQL Anywhere 9 With Asp.net ?

[Former Member]

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.

[jeff_albion · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks finally I got it but let me ask what are the implications of be a .NET 1.x assembly???

[jeff_albion · Accepted solution]

It was written before ADO.NET 2.0 was released, so it may not support all of the modern ADO.NET (2.0, 3.5, 4.x) features that may be needed...

https://msdn.microsoft.com/en-us/library/ms971494.aspx

and I am noting it as a general reminder that SQL Anywhere 9 was end-of-life'd on January 31, 2010, so if you run into problems with missing features or bugs we will only be able to recommend possible workarounds.

Glad to hear that you were able to get it working!