Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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

dara88's gravatar image

dara88
79336
accept rate: 0%


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.

permanent link

answered 19 Aug '15, 17:39

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
accept rate: 25%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×2

question asked: 11 Aug '15, 11:06

question was seen: 2,237 times

last updated: 21 Aug '15, 17:14