topic Trying to create ITable from a MS SQL Server Express table with spatial column in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/trying-to-create-itable-from-a-ms-sql-server/m-p/63284#M1724 <HTML><HEAD></HEAD><BODY><SPAN>Hi, I'm pretty new to C#, SQL Server, and AO so excuse the noobness.&nbsp; What I want to do is take the AdventureWorks2012.Person.Address table (which contains the "SpatialLocation" geography column) stored in my local MS SQL Server Express server and create a query layer and eventually create an ILayer to display in a MapControl on a Windows form.&nbsp; I've tried searching the forums but haven't had any luck finding anything.&nbsp; Is there an example of this that someone can explain to me or point me to?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Tue, 24 Apr 2012 23:28:19 GMT MartinWong 2012-04-24T23:28:19Z Trying to create ITable from a MS SQL Server Express table with spatial column https://community.esri.com/t5/arcobjects-sdk-questions/trying-to-create-itable-from-a-ms-sql-server/m-p/63284#M1724 <HTML><HEAD></HEAD><BODY><SPAN>Hi, I'm pretty new to C#, SQL Server, and AO so excuse the noobness.&nbsp; What I want to do is take the AdventureWorks2012.Person.Address table (which contains the "SpatialLocation" geography column) stored in my local MS SQL Server Express server and create a query layer and eventually create an ILayer to display in a MapControl on a Windows form.&nbsp; I've tried searching the forums but haven't had any luck finding anything.&nbsp; Is there an example of this that someone can explain to me or point me to?</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><SPAN>Martin</SPAN></BODY></HTML> Tue, 24 Apr 2012 23:28:19 GMT https://community.esri.com/t5/arcobjects-sdk-questions/trying-to-create-itable-from-a-ms-sql-server/m-p/63284#M1724 MartinWong 2012-04-24T23:28:19Z Re: Trying to create ITable from a MS SQL Server Express table with spatial column https://community.esri.com/t5/arcobjects-sdk-questions/trying-to-create-itable-from-a-ms-sql-server/m-p/63285#M1725 <HTML><HEAD></HEAD><BODY><SPAN>After doing more research I finally figured it out.</SPAN><BR /><BR /><SPAN>Esri has an exact example of what I was trying to accomplish here:</SPAN><BR /><A href="http://help.arcgis.com/en/sdk/10.0/arcobjects_net/componenthelp/index.html#//001p0000000t000000">http://help.arcgis.com/en/sdk/10.0/arcobjects_net/componenthelp/index.html#//001p0000000t000000</A><BR /><BR /><SPAN>My problem was that I've been trying to use a SqlWorkspaceFactory instead of an OLEDBWorkspaceFactory, plus I was missing the "@" character in my connection string.&nbsp; Also, Esri's SqlWorkspaceFactory example was for a connection to an Oracle DB using a PropertySet so the connection parameters were very different.</SPAN><BR /><BR /><SPAN>Martin</SPAN></BODY></HTML> Wed, 25 Apr 2012 17:45:11 GMT https://community.esri.com/t5/arcobjects-sdk-questions/trying-to-create-itable-from-a-ms-sql-server/m-p/63285#M1725 MartinWong 2012-04-25T17:45:11Z Re: Trying to create ITable from a MS SQL Server Express table with spatial column https://community.esri.com/t5/arcobjects-sdk-questions/trying-to-create-itable-from-a-ms-sql-server/m-p/63286#M1726 <HTML><HEAD></HEAD><BODY><SPAN>I guess I spoke too soon.&nbsp; Apparently the OLEDBWorkspaceFactory cannot be used to connect to spatial data.&nbsp; But, I was finally able to use the SqlWorkspaceFactory once I got the connection parameters right:</SPAN><BR /><UL><BR /><LI>dbclient = "SQLServer"</LI><BR /><LI>serverinstance = "MyPCName"</LI><BR /><LI>authentication_mode = "OSA"</LI><BR /><LI>database = "AdventureWorks2012"</LI><BR /></UL><SPAN>After connecting and getting the SQLworkspace, I setup my queryDescription to the Person.Address table and used the OpenQueryClass method to create my feature class to add to the map control.</SPAN><BR /><BR /><SPAN>Martin</SPAN></BODY></HTML> Thu, 26 Apr 2012 19:43:44 GMT https://community.esri.com/t5/arcobjects-sdk-questions/trying-to-create-itable-from-a-ms-sql-server/m-p/63286#M1726 MartinWong 2012-04-26T19:43:44Z Re: Trying to create ITable from a MS SQL Server Express table with spatial column https://community.esri.com/t5/arcobjects-sdk-questions/trying-to-create-itable-from-a-ms-sql-server/m-p/63287#M1727 <HTML><HEAD></HEAD><BODY><SPAN>Hi Martin,</SPAN><BR /><BR /><SPAN>Is this SDE database?</SPAN><BR /><BR /><SPAN>David</SPAN></BODY></HTML> Tue, 01 May 2012 09:13:20 GMT https://community.esri.com/t5/arcobjects-sdk-questions/trying-to-create-itable-from-a-ms-sql-server/m-p/63287#M1727 DavidLednik 2012-05-01T09:13:20Z