Query SQL Server Table

3683
14
07-26-2011 07:22 AM
BrandonCales
New Contributor III
I have a view on another system (Permits), that I want to query based on the selected Parcel. Do I have to setup a relationship class in ArcGIS Server or is there another way?
0 Kudos
14 Replies
MellissaLasslo
New Contributor III
What version of ArcGIS are you using?
0 Kudos
SheldonKitzul
New Contributor
What version of ArcGIS are you using?


We will be using ArcGIS 9.3.1 with potential to go to 10 or 10.1 if there is significant benefit.
0 Kudos
MellissaLasslo
New Contributor III
We will be using ArcGIS 9.3.1 with potential to go to 10 or 10.1 if there is significant benefit.


I'm not sure how to do it in 9.3.1, but we were just able to do it in 10. Here are some links to threads that may help:

http://forums.arcgis.com/threads/2381-Trying-to-create-map-service-with-non-spatial-SQL-Server-datab...

http://forums.arcgis.com/threads/24893-ArcGIS-Conecction-OLE-DB-Publishing-MapService-Problem?highli...

http://forums.arcgis.com/threads/42972-adding-layer-to-.mxd-from-OLE-database-connection-produces-in...

You can also email me at mellissa.lasslo[@]carbon[dot]utah[dot]gov if you have any more questions or need help.
0 Kudos
SheldonKitzul
New Contributor
I'm not sure how to do it in 9.3.1, but we were just able to do it in 10. Here are some links to threads that may help:

http://forums.arcgis.com/threads/2381-Trying-to-create-map-service-with-non-spatial-SQL-Server-datab...

http://forums.arcgis.com/threads/24893-ArcGIS-Conecction-OLE-DB-Publishing-MapService-Problem?highli...

http://forums.arcgis.com/threads/42972-adding-layer-to-.mxd-from-OLE-database-connection-produces-in...

You can also email me at mellissa.lasslo[@]carbon[dot]utah[dot]gov if you have any more questions or need help.


Thanks Melissa!  I will check into the links.  I GREATLY appreciate your help!
0 Kudos
Abul_Kashem_Md_Hasan
New Contributor
Yes.  It is better to create the WCF service as regular .NET class library (.dll); then create a standard web site of type "Web Service" to deploy the .dll.  This way you get all the power of .NET that Silverlight lacks.  I have done it already and works great.

My scenario may be somewhat different from yours or any other.  I have my Silverlight application sitting on the Cloud server, getting all map services from the ArcGIS Server on the Cloud as well.  My Silverlight application connects to non-GIS servers (standard MSSQL servers) outside the Cloud to retrieve dynamic data (always changing information [massive water meter readings that change every 2 to 4 hours]).  Static information (meter id, address, etc.) comes from the ArcGIS Server in the Cloud, but other dynamic attributes are retrieved from those other servers outside the Cloud.

I can save and open files (somehting very unsual in Silverlight with the browser option on), for my WCF service does it all.

I can share some code and the .dll if anyone needs it.

Hugo.


Dear Hugo,
We are using silverlight. we need to join a table from oracle with map service on the fly. I think you code will be very helpful to us. Could you please send your code to me. My email address is ahasan@cegisbd.com.

Thank you very much.
0 Kudos