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. Thanks finally I got it but let me ask what are the implications of be a .NET 1.x assembly???
(21 Aug '15, 11:49)
dara88
Replies hidden
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!
(21 Aug '15, 17:14)
Jeff Albion
|