https://community.sap.com/t5/technology-q-a/create-connection-in-visual-studio-2012-with-net-framework-4-to-sql/qaa-p/13844516#M4875359 <P>Hello Thanks for your reply - and the information to my question. Best regards - Michael</P> Tue, 22 Jan 2013 03:10:17 GMT Former Member 2013-01-22T03:10:17Z https://community.sap.com/t5/technology-q-a/create-connection-in-visual-studio-2012-with-net-framework-4-to-sql/qaq-p/13844514 <P>Hello</P> <P>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......</P> <P>Please - have anyone a clue for my problem? Many thanks in advance some information &amp; best regards Michael</P> Mon, 21 Jan 2013 12:15:38 GMT https://community.sap.com/t5/technology-q-a/create-connection-in-visual-studio-2012-with-net-framework-4-to-sql/qaq-p/13844514 Former Member 2013-01-21T12:15:38Z https://community.sap.com/t5/technology-q-a/create-connection-in-visual-studio-2012-with-net-framework-4-to-sql/qaa-p/13844515#M4875358 <P>For .NET applications, you generally want to use our <A href="http://dcx.sybase.com/index.html#1201/en/dbprogramming/adodotnet-development.html">SQL Anywhere ADO.NET Data Provider</A>. (Found in <CODE>%SQLANY12%\\Assembly</CODE>, and registered to the GAC in a full SQL Anywhere install).</P> <P>Have you had a chance to take a look through the Samples that come with SQL Anywhere? Inside the <CODE>\\Samples\\SQLAnywhere\\ADO.NET</CODE> folder, there are several examples that use our ADO.NET provider. There are also <A href="http://dcx.sybase.com/index.html#1201/en/dbprogramming/adodotnet-tutorials.html">tutorials in the documentation</A> that illustrate how the samples work.</P> <HR /> <P>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 <A href="http://search.sybase.com/kbx/changerequests?bug_id=640109">CR #640109</A>, to ensure that the v4 ADO.NET provider registers correctly once you have installed the EBF. (The EBF download website can be found <A href="http://downloads.sybase.com/swd/summary.do?baseprod=144&amp;client=ianywhere&amp;timeframe=0">here</A>)</P> Mon, 21 Jan 2013 16:10:49 GMT https://community.sap.com/t5/technology-q-a/create-connection-in-visual-studio-2012-with-net-framework-4-to-sql/qaa-p/13844515#M4875358 jeff_albion 2013-01-21T16:10:49Z https://community.sap.com/t5/technology-q-a/create-connection-in-visual-studio-2012-with-net-framework-4-to-sql/qaa-p/13844516#M4875359 <P>Hello Thanks for your reply - and the information to my question. Best regards - Michael</P> Tue, 22 Jan 2013 03:10:17 GMT https://community.sap.com/t5/technology-q-a/create-connection-in-visual-studio-2012-with-net-framework-4-to-sql/qaa-p/13844516#M4875359 Former Member 2013-01-22T03:10:17Z