Create connection in Visual-Studio-2012 with .NET-Framework-4 to Sql-Anywhere-11

[Former Member]

Hello

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

[jeff_albion · Accepted solution]

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 11.0.1.2044 (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 11.0.1.2490 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)

[Former Member · Accepted solution]

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