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

asked 21 Jan '13, 12:15

MiErli's gravatar image

MiErli
21113
accept rate: 0%

edited 22 Jan '13, 03:44

Volker%20Barth's gravatar image

Volker Barth
40.2k361549822


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)

permanent link

answered 21 Jan '13, 16:10

Jeff%20Albion's gravatar image

Jeff Albion
10.8k171175
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

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:

×69
×39
×25

question asked: 21 Jan '13, 12:15

question was seen: 5,093 times

last updated: 22 Jan '13, 03:44