topic Connect to SQL Server Database dynbamically in ArcGIS Runtime SDK for WPF (Retired) Questions https://community.esri.com/t5/arcgis-runtime-sdk-for-wpf-retired-questions/connect-to-sql-server-database-dynbamically/m-p/359573#M1775 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I am developing a Runtime application that enables user selected Access or SQL database to connect. According to the concepts page this is possible through datasource or querydatasource but only through the workspaceID from a ArcGISDynamicMapServiceLayer.&nbsp; </SPAN><BR /><SPAN>I was able to open Access database from a custom python script tool. Is this possible to do the same with SQL database?</SPAN><BR /><SPAN>I cannot use CreateDatabaseConnectoin tool because its not supported in ArcGIS Runtime. Another way is using 'pyodbc' library. </SPAN><BR /><BR /><SPAN>Has anybody else ideas or experience with this kind of workflow?</SPAN><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Fri, 15 Feb 2013 18:23:17 GMT jp 2013-02-15T18:23:17Z Connect to SQL Server Database dynbamically https://community.esri.com/t5/arcgis-runtime-sdk-for-wpf-retired-questions/connect-to-sql-server-database-dynbamically/m-p/359573#M1775 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I am developing a Runtime application that enables user selected Access or SQL database to connect. According to the concepts page this is possible through datasource or querydatasource but only through the workspaceID from a ArcGISDynamicMapServiceLayer.&nbsp; </SPAN><BR /><SPAN>I was able to open Access database from a custom python script tool. Is this possible to do the same with SQL database?</SPAN><BR /><SPAN>I cannot use CreateDatabaseConnectoin tool because its not supported in ArcGIS Runtime. Another way is using 'pyodbc' library. </SPAN><BR /><BR /><SPAN>Has anybody else ideas or experience with this kind of workflow?</SPAN><BR /><BR /><SPAN>Thanks!</SPAN></BODY></HTML> Fri, 15 Feb 2013 18:23:17 GMT https://community.esri.com/t5/arcgis-runtime-sdk-for-wpf-retired-questions/connect-to-sql-server-database-dynbamically/m-p/359573#M1775 jp 2013-02-15T18:23:17Z Re: Connect to SQL Server Database dynbamically https://community.esri.com/t5/arcgis-runtime-sdk-for-wpf-retired-questions/connect-to-sql-server-database-dynbamically/m-p/359574#M1776 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>Are these Access / SQL Server databases actually Geodatabases? Or would you like to join a non-spatial table from the database to a spatial dataset in another datasource? I'm assuming it's the latter... you could take a look at this earlier post which discusses using the JoinDataSource: </SPAN><A href="http://forums.arcgis.com/threads/74686-Joining-Database-with-Map-Layer?">http://forums.arcgis.com/threads/74686-Joining-Database-with-Map-Layer?</A><BR /><BR /><SPAN>Cheers</SPAN><BR /><BR /><SPAN>Mike</SPAN></BODY></HTML> Fri, 22 Feb 2013 13:05:07 GMT https://community.esri.com/t5/arcgis-runtime-sdk-for-wpf-retired-questions/connect-to-sql-server-database-dynbamically/m-p/359574#M1776 MichaelBranscomb 2013-02-22T13:05:07Z Re: Connect to SQL Server Database dynbamically https://community.esri.com/t5/arcgis-runtime-sdk-for-wpf-retired-questions/connect-to-sql-server-database-dynbamically/m-p/359575#M1777 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Mike!</SPAN><BR /><BR /><SPAN>I looked at the posting you referred to but I found ArcGIS Runtime doesn't support workspacefactorytype of SQL Server database. So this might not work as desired. </SPAN><BR /><SPAN>I can think of only looping through the data and editing the a default table everytime the application is connected to a new database. Since its not possible to connect to SQL server in ArcGIS Runtime. Actually I need to attach a mdf file to SQL Server.</SPAN><BR /><BR /><SPAN>Is there another way?</SPAN><BR /><BR /><SPAN>Thanks!</SPAN><BR /><BR /><BR /><BLOCKQUOTE class="jive-quote">Hi,<BR /><BR />Are these Access / SQL Server databases actually Geodatabases? Or would you like to join a non-spatial table from the database to a spatial dataset in another datasource? I'm assuming it's the latter... you could take a look at this earlier post which discusses using the JoinDataSource: <A href="http://forums.arcgis.com/threads/74686-Joining-Database-with-Map-Layer?">http://forums.arcgis.com/threads/74686-Joining-Database-with-Map-Layer?</A><BR /><BR />Cheers<BR /><BR />Mike</BLOCKQUOTE></BODY></HTML> Mon, 25 Feb 2013 15:36:43 GMT https://community.esri.com/t5/arcgis-runtime-sdk-for-wpf-retired-questions/connect-to-sql-server-database-dynbamically/m-p/359575#M1777 jp 2013-02-25T15:36:43Z