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

[Elad Lavi]

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>
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
>
>
> -----Original Message-----
> From: fdo-users [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
> 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
> https://lists.osgeo.org/mailman/listinfo/fdo-users
> _______________________________________________
> fdo-users mailing list
> 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/a3360dc3/attachment.html>