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 must create a database-connection from a .NET-Framework-4-Application (written in C#) and with Visual-Studio 2012. My first problem is, to create in the Visual-Studio-2012 a datasource in the dataSource-Explorer. I can't see any Sql-Anywhere-database-connections/or connection-options. And the next question is - how could I create a db-connection to the Sql-Anywhere-11 - with OLE-Db-provider? native-database-provider? or other......

Please - have anyone a clue for my problem? Many thanks in advance some information & best regards Michael

asked 21 Jan '13, 12:15

MiErli's gravatar image

accept rate: 0%

edited 22 Jan '13, 03:44

Volker%20Barth's gravatar image

Volker Barth

For .NET applications, you generally want to use our SQL Anywhere ADO.NET Data Provider. (Found in %SQLANY12%\Assembly, and registered to the GAC in a full SQL Anywhere install).

Have you had a chance to take a look through the Samples that come with SQL Anywhere? Inside the \Samples\SQLAnywhere\ADO.NET folder, there are several examples that use our ADO.NET provider. There are also tutorials in the documentation that illustrate how the samples work.

Also note that SQL Anywhere (GA) did not come with .NET Framework 4 support - that was available in a later EBF of 11.0.1. I would suggest that you obtain a build higher than to avoid CR #640109, to ensure that the v4 ADO.NET provider registers correctly once you have installed the EBF. (The EBF download website can be found here)

permanent link

answered 21 Jan '13, 16:10

Jeff%20Albion's gravatar image

Jeff Albion
accept rate: 25%

Hello Thanks for your reply - and the information to my question. Best regards - Michael

(22 Jan '13, 03:10) MiErli
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 21 Jan '13, 12:15

question was seen: 5,097 times

last updated: 22 Jan '13, 03:44