[fdo-users] Can't select features using SQL Server data connection

Tue Jun 26 11:11:56 PDT 2018

It SHOULD be significantly faster.  We don’t have enough information to figure out why.  You will need to check SQL indexes, server performance, network performance, etc…

Martin Morrison
Infrastructure Application Engineer/Systems Analyst
 Engineering Design Systems, Inc.
540.345.1410
martin.morrison at edsi.com<mailto:martin.morrison at edsi.com>
[cid:image001.jpg at 01D2249F.40681A50]

From: fdo-users [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Elad Lavi
Sent: Tuesday, June 26, 2018 11:48 AM
To: fdo-users at lists.osgeo.org
Subject: Re: [fdo-users] Can't select features using SQL Server data connection

Thanks! that was it. I appreciate it.

Can someone advise me about a reason why when using SQL Server as a data connection, it is significantly slower than when working directly with the shape files?
This is SQL Server 2014 Express. I imported the data from shape files to the database using shape2sql (which sadly didn't offer to add primary key).
Perhaps this is normal but I suspect that there's something I am missing with the FDO settings.
The database is on the same machine of course.

Thanks a lot.

On Tue, Jun 26, 2018 at 3:53 PM Martin Morrison <martin.morrison at edsi.com<mailto:martin.morrison at edsi.com>> wrote:
Do you have a primary key set?

Martin Morrison
Infrastructure Application Engineer/Systems Analyst
 Engineering Design Systems, Inc.
540.345.1410
martin.morrison at edsi.com<mailto:martin.morrison at edsi.com>

-----Original Message-----
From: fdo-users [mailto:fdo-users-bounces at lists.osgeo.org<mailto:fdo-users-bounces at lists.osgeo.org>] On Behalf Of Elad
Sent: Tuesday, June 26, 2018 3:16 AM
To: fdo-users at lists.osgeo.org<mailto:fdo-users at lists.osgeo.org>
Subject: [fdo-users] Can't select features using SQL Server data connection

Hi. I'm new to MapGuide and Maestro but I am expirienced programmer.
I have shape files and I have also imported them into MS SQL Server using shape2sql.
When I create a data connection directly to the shape files, and then create a layer for some feature, I am able to select features using the select tool on the map.
But, when I create the same layer using the SQL Server spatial feature source, the features are shown but are not selectable. When trying to select, it looks like it is processing (the red rectangle hangs for a while on the screen) but after few seconds, it says "0 features selected" and the features are not highlighted as using the shape file directly.

What I've tried so far: I susspected that when using the shape files directly, Maestro recognized the other files such as the .prj files with the coordinate system so in the data connection, I have set the coordinate system manualy to what ever it is in the prj file. It didn't help.

I have other issues such as slowness compared to working with the shape files directly.
I realize the shape2sql is outdated and perhaps misimported the data into the database, but it does show correctly on the map with all the other feature data.

Interstingly, when I set the tooltip to "TYPE" for example which is one of the feature data fields, it is shown! I can't select features even using the single feature selection.

Please help.
by the way, is there a forum for newbies?

Thanks.

--
Sent from: http://osgeo-org.1560.x6.nabble.com/FDO-Users-f3898664.html
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org<mailto:fdo-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/fdo-users
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org<mailto:fdo-users at lists.osgeo.org>
https://lists.osgeo.org/mailman/listinfo/fdo-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/fdo-users/attachments/20180626/d24022d9/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4893 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/fdo-users/attachments/20180626/d24022d9/attachment-0001.jpg>