nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

communication between client side map with sqlserver database table

gumpenagopikrishna

please provide solution for this

タグ付けされた投稿をもっと見る

Accepted answers

All comments

DevonDunham1

One way is to use Postgres. It has support for GIS tables that will allow you to work better.

gumpenagopikrishna

I know rest service with url,but with out that service url how can i communicate sqlserver table with front end map.........i want connections in programming side from sqlserver to client side map.that map is tiled or dynamic......

I know connections of sqlserver table data to bing map,but is it possible for tiled map........

gumpenagopikrishna

Hello
Best way is that (if you are using ArcGIS DT 10.0 and Server 10.0)

1.Create query layer in ArcMap ( click here)

2.Publish as map service in ArcGIS Server..

3.Use REST service for query in java script API.. It will resolve your issue ( Check query task in AGS_JSAPI) all the best : )

I know rest service with url,but with out that service url how can i communicate sqlserver table with front end map.........i want connections in programming side from sqlserver to client side map.that map is tiled or dynamic......

SunilPalkar

Hello
Best way is that (if you are using ArcGIS DT 10.0 and Server 10.0)

1.Create query layer in ArcMap ( click here)

is this fine,but in this request what url i have to be placed.this is sqlserver query purose na

2.Publish as map service in ArcGIS Server..

3.Use REST service for query in java script API.. It will resolve your issue ( Check query task in AGS_JSAPI) all the best : )

gumpenagopikrishna

The usual way to handle a demand of accessing a SQL server outside ArcGis server is to write a REST service at a web server that will handle the request and returning data. In JavaScript you can easily consume such a request by code like this base on JQuery

            $.ajax({
                cache: false,
                type: "POST",
                async: false,
                url: �??rest service url�?�,
                crossDomain: true,
                data: JSON.stringify(data),
                contentType: "application/json;charset=utf-8",
                dataType: "json",
                processdata: true,
                success: function (data) {
                    if (!status)
                        alert("data retrieve failed");
       else
          �?�.. data handling
                },
                error: function (xhr) {
                    alert(xhr.responseText);
                }
            });

Writing REST services is not an ArcGis API issue, but pure writing web services. Currently I am writing a custom graphic layer class that will consume non ArcSDE geometry tables like the SQLGeometry of MS SQL server. I hope later to make the code available. The REST service is written using .NET

is this fine,but in this request what url i have to be placed.this is sqlserver query purose na

JohnnyPenet

The usual way to handle a demand of accessing a SQL server outside ArcGis server is to write a REST service at a web server that will handle the request and returning data. In JavaScript you can easily consume such a request by code like this base on JQuery

            $.ajax({
                cache: false,
                type: "POST",
                async: false,
                url: �??rest service url�?�,
                crossDomain: true,
                data: JSON.stringify(data),
                contentType: "application/json;charset=utf-8",
                dataType: "json",
                processdata: true,
                success: function (data) {
                    if (!status)
                        alert("data retrieve failed");
       else
          �?�.. data handling
                },
                error: function (xhr) {
                    alert(xhr.responseText);
                }
            });

Writing REST services is not an ArcGis API issue, but pure writing web services. Currently I am writing a custom graphic layer class that will consume non ArcSDE geometry tables like the SQLGeometry of MS SQL server. I hope later to make the code available. The REST service is written using .NET

gumpenagopikrishna

You won't be able to connect directly to the SQL database using javascript. You will need to use some server side code to make the table information available as a web service. There are a number of ways to do this. If you have access an ArcGIS server, you could create a published python geoprocessing service that queries a SQL server table and returns the table, then use javascript to execute the service and make the data available to the cilent. At ArcGIS Server 10+, you may also be able to access be able to access a table as part of a map service. We are still on 9.3.1, so I can't say for sure.

Is there any api for this service and viceversa....please provide that link to me....

BillDaigle

You won't be able to connect directly to the SQL database using javascript. You will need to use some server side code to make the table information available as a web service. There are a number of ways to do this. If you have access an ArcGIS server, you could create a published python geoprocessing service that queries a SQL server table and returns the table, then use javascript to execute the service and make the data available to the cilent. At ArcGIS Server 10+, you may also be able to access be able to access a table as part of a map service. We are still on 9.3.1, so I can't say for sure.

会話に参加する

サインインしたメンバーは投稿、更新のフォローなどができます。初めてですか？無料アカウントを登録してください。

クイックリンク

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.