The mssql tag has no wiki summary.
0
votes
2answers
14 views
database server connection to MSSQL Server with ArcCatalog not possible?
I have a MSSQL Server where my geodata is held. In the ArcGIS Docs, it says...
"To administer ArcSDE geodatabases for SQL Server Express, you can also connect to these geodatabases by first making a ...
0
votes
0answers
28 views
QGIS on Mac OS X 10.8.2 and MS Azure SQL database connection
I'm running QGIS on a Mac (10.8.2) and want to get some data from a Microsoft SQL Azure database.
I'm confident the Azure side is fine and I have verified I can get to the Azure db using RazorSQL ...
1
vote
1answer
53 views
How to insert features in a MS SQL based SDE without giving ObjectID s?
I'm trying to load features into ArcSDE without using ArcObjects, and using SQL from my .NET Application instead.
I have followed the answers given in this question: Is it possible to load features ...
0
votes
0answers
73 views
Fill polygon with colour depending on the value in MS SQL Server table
I'm using QGIS 1.8. Windows 7. I have a table in MS SQL Server 2008 R2 database with two fields: id and density(int). There are several polygons in QGIS. How can I set color of polygion depending on ...
0
votes
0answers
83 views
QGIS shows “handle bad layers” window when open project
A problem occurs when I trying to open project. Project has two vector layers, but only one is loaded and appears "handle bad layers" window. I'm using MS SQL Server 2008 R2. Maybe someone knows how ...
1
vote
0answers
63 views
Why does a geoprocessing service fail every other time it is run?
I have a ArcGIS Server 10 geoprocessing service right now that takes in a string and runs a parameterized query to SQL Server 2008R2 through pyodbc. The service works, but only every other time. I can ...
0
votes
0answers
96 views
ArcMap runs custom script once and then it crashes on second run
So I made a script that takes data from an MSSQL database and inserts it into a featureclass. I added the script to a toolbox and am able to run the tool from within ArcMap 10.1. The problem is that ...
0
votes
0answers
31 views
Spatial database connection doesn't work with ms cluster
i got a trouble with MS Cluster. When i try connect direct to node1 the connection is succefuln but when i try connect with cluster Host i get "Failed to connect to the specified server. Bad Login ...
0
votes
1answer
33 views
number of arcgis server users for CAL-based backends
The licenses for our organization's MS SQL and ArcGIS Server are such:
MS SQL: CAL
ArcGIS Server: enterprise
Are the number of users that can be served still limited to the number of CALs present in ...
0
votes
0answers
73 views
How to export Spatial data from MsSQL to MySQL using OpenSource/Free tools
I have a few tables with geometry fields in MsSQL Server 2008. I would like to export the whole table with data to MsSQL Server. Are there any open source/free tools that does this job?
0
votes
0answers
92 views
Retrieving the data from SQL database is taking much more time than expected
I am creating a block wise vector layer and related data stored in a sql database while retrieving the data from the SQL database through querying and would represent the result on a map. This is ...
3
votes
2answers
185 views
migrate PostGIS spatial data to MsSql spatial data
am trying to migrate PostGIS geometry to SQL server Spatial data. which ETL i have to use. it's the first time i'll work with SQL server Spatial.
is there any Data ETL model that do this migration. ...
1
vote
0answers
192 views
Connect QGIS to MSSQL view (i.e. not a table)
I've got a MSSQL view containing data I want to show in QGIS. The view transforms a BLOB field containing WKB that is in one of my tables into a SQL geometry, which QGIS will be able to display.
...
2
votes
1answer
230 views
How to use non-native spatial data from MS SQL Server with ogr2ogr?
I have some tables in MS SQL Server (2012) with WKT string columns.
I want to export these data to a MapInfo tab file.
Currently I am using the following command:
ogr2ogr -f "MapInfo File" ...
1
vote
1answer
152 views
What is the “best practice” way to retrieve features from MSSQL to OpenLayers and display them?
Today I have a table in the DB with columns Feature Name and Feature Point.
When I want to load the points to OL I do the following :
First I call web service to get list of json objects:
var ...
3
votes
1answer
200 views
Is there a way to get centroid of geographic object in MSSQL?
I have a table of OSM geographic roads in MSSQL 2012.
I want to create a new column with the centroid of each road (So I can set center on OpenLayers map for each road).
How can I do it ?
0
votes
0answers
65 views
Can osm way records in SQL spatial be merged to one geographic record if they have same Id?
I've imported England shp file of roads to mssql using OSM2MSSQL and I've noticed that the same road has couple of records with same Id but different geographic (probably it was segmented).
Is there ...
0
votes
2answers
155 views
How can I get nearest road to a lat lon in MSSQL?
I've updated osm data (ways) in MSSQL and got geographic objects. Now I want to get the closet road to any lat lon a user will query.
Which SQL spatial statement is used for that ?
3
votes
2answers
119 views
PostGIS or SQL 2008 ? (For the newbie GIS programmer but familiar with .Net) [closed]
I've been using MS SQL for years. Starting now to develop GIS application and it is required to do queries and store vectors created in OpenLayers in DB.
Assuming I'm developing over .Net , What will ...
3
votes
1answer
165 views
Why don't my polygons from MSSQL2008 display in QGIS?
I have imported a polygon shape file in MSSQL2008 using Shape2SQL loader without any issue. When I import the loaded polygon file in QGIS, I can't see it ! When I import other point or line features ...
1
vote
1answer
279 views
MapServer connection to SQL Server 2008
I'm trying to view some data held in a SQL Server 2008 database using MapServer. I can run the GetCapabilities requests without any errors, but when i try and run a GetFeature I get the following ...
2
votes
3answers
2k views
How to import shapefiles into MS SQL 2008 and then view that data using QGIS?
I'm a QGIS users but not a database person and I need some help on the DB side.
I'm currently in the need to import several shape files into MSSQL 2008 and I have no clue how to do that and my IT guy ...
0
votes
1answer
84 views
Porting existing MSSQL database to SDE
I have an existing MSSQL2008R2 database with views each containing a single geometry field along with a big number of "attributes".
I would like to be able to do INSERTS, UPDATES, and DELETES on ...
3
votes
2answers
639 views
How can i select a polygon in MS SQL 2008
I am very new to MS SQL 2008. I got a task to select a polygon from the polygon layer by giving the X-Y coordinates. I already got the script for PostgreSQL for the same thing, but i need it for MS ...
1
vote
1answer
185 views
Difference in two datasource in geoserver
We have two datasource in geoserver for Sql server. what is the difference between them?
Microsoft SQL Server - Microsoft SQL Server
Microsoft SQL Server (JNDI) - Microsoft SQL Server (JNDI)
2
votes
1answer
552 views
How to get data from MS SQL Server 2008 into Mapserver?
I need to create some layers in my map from a Microsoft SQL 2008 database. I am using Openlayers and Mapserver. The Mapserver instance is running on SUSE linux, so the Mapserver documentation on ...
3
votes
4answers
522 views
update spatial data from excel to ms-sql server 2008
I have 1000's of data with 50's of column. It is point data. The data
is in MS-SQL server.Now each day I need to load 100's of data similar
in structure. How can I achieve it ? I tried to append ...
2
votes
1answer
198 views
Link non-spatial SQL Server query to a Geodatabase?
Is it possible to build an object (of whatever kind) in ArcEngine code that links the geodatabase data with a non-spatial SQL Server query? How would you go about doing this?
2
votes
2answers
558 views
SQL server views in geoserver - problem with sql
I try to extract non-spatial data from mssql as spatial data to my Geoserver 2.1.0 installation from a sql statement looking like this:
SELECT database.table1.id,
...
2
votes
2answers
1k views
Trigger on SQL Server 2008 ArcSDE 10 and ArcGIS Server 10
I need to build a sql server db trigger to update a date field with the current date when a record is inserted or updated, I think. I will be using the date field as a way to recognize ...
1
vote
0answers
235 views
T-SQL with SDE and Web Map ArcGIS Server 10 MSSQL 2008
I need to build a system whereby the user of a web map (the standard web map that ArcGIS Server Manager builds) can edit a feature class's attributes. The attribute will be a 'Comments' field. The ...
0
votes
1answer
169 views
Where does MapInfo store its error and log files?
I am having errors opening a table with spatial co-ordinates in Microsoft SQL and my question in gis.stackexchange is here. I want to know where are the error and log files of Mapinfo stored. I ...
1
vote
1answer
642 views
ArcGIS Server 10 and SQL Server 2008 R2 permissions and feature services
I have ArcGIS Server 10 with SP1 and SP2 on windows server 2008 and ArcSDE (from an edn liscense) installed on top of MS SQL Server 2008.
When I make a spatial db connection in ArcCatalog (direct ...
5
votes
2answers
587 views
ArcSDE Geodatabase MS SQL Server restore of .bak file
If we have ArcSDE 9.3.1 running on MSSQL Server 2008 R2 Enterprise and we do a full backup of a geodatabase. Then I try to restore the .bak file to a MSSQL Server 2008 R2 Express on a machine that ...
