Re: [mapguide-users] Can you help with connection properties for OSGeo.SQLServerSpatial?
these could be the system tables of the your datastore...the only users tables that'll appear in the tables section will be those with have spatial fields (this is what i remember from my last work with sql) ... On Fri, Nov 13, 2009 at 7:58 AM, JamesDudden jamesdud...@blueyonder.co.ukwrote: Martin Morrison wrote: What version of which provider are you using? The SQL spatial provider has a login button... Am using MGStudio 09 and the provider doesn't have a number it just says: OSGeo.SQLServerSpatial - http://www.software-matters.co.uk Software Matters - http://www.software-matters.co.uk/bespoke-database-design.html Bespoke Database and Software Solutions -- View this message in context: http://n2.nabble.com/Can-you-help-with-connection-properties-for-OSGeo-SQLServerSpatial-tp3998955p484.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Can you help with connection properties for OSGeo.SQLServerSpatial?
Service is the named SQL Server instance DataStore is the name of the database - Jackie JamesDudden wrote: Hi, Can anybody help with the connection properties for OSGeo.SQLServerSpatial? What do I need to put in the following fields: Service Datastore Any help is welcomed Regards JD -- View this message in context: http://n2.nabble.com/Can-you-help-with-connection-properties-for-OSGeo-SQLServerSpatial-tp3998955p3999172.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
RE: [mapguide-users] Can you help with connection properties for OSGeo.SQLServerSpatial?
I am using SQL 2008 Express. I have tried what you suggested but still get the same error when clicking Test Connection. If I click on the little box at the end of the DataStore row I get a different error: The remote server returned an error: (559) MgFdoException Any ideas? JD - http://www.software-matters.co.uk Software Matters - http://www.software-matters.co.uk/bespoke-database-design.html Bespoke Database and Software Solutions -- View this message in context: http://n2.nabble.com/Can-you-help-with-connection-properties-for-OSGeo-SQLServerSpatial-tp3998955p3999415.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
RE: [mapguide-users] Can you help with connection properties for OSGeo.SQLServerSpatial?
Once you type the service name in, are you able to login? -Original Message- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of JamesDudden Sent: Friday, November 13, 2009 9:09 AM To: mapguide-users@lists.osgeo.org Subject: RE: [mapguide-users] Can you help with connection properties for OSGeo.SQLServerSpatial? I am using SQL 2008 Express. I have tried what you suggested but still get the same error when clicking Test Connection. If I click on the little box at the end of the DataStore row I get a different error: The remote server returned an error: (559) MgFdoException Any ideas? JD - http://www.software-matters.co.uk Software Matters - http://www.software-matters.co.uk/bespoke-database-design.html Bespoke Database and Software Solutions -- View this message in context: http://n2.nabble.com/Can-you-help-with-connection-properties-for-OSGeo-SQLServerSpatial-tp3998955p3999415.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Can you help with connection properties for OSGeo.SQLServerSpatial?
Atika Irfan wrote: just checking ...try with a ODBC connection to the same datastore service This works! But, when I look at the data none of my tables are there? All I see in the list of tables is: MSreplication_options spt_fallback_db spt_fallback_dev spt_fallback_usg spt_monitor spt_values I don't know what these are. Any ideas? JD - http://www.software-matters.co.uk Software Matters - http://www.software-matters.co.uk/bespoke-database-design.html Bespoke Database and Software Solutions -- View this message in context: http://n2.nabble.com/Can-you-help-with-connection-properties-for-OSGeo-SQLServerSpatial-tp3998955p3999664.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
RE: [mapguide-users] Can you help with connection properties for OSGeo.SQLServerSpatial?
What version of which provider are you using? The SQL spatial provider has a login button... -Original Message- From: mapguide-users-boun...@lists.osgeo.org [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of JamesDudden Sent: Friday, November 13, 2009 9:29 AM To: mapguide-users@lists.osgeo.org Subject: RE: [mapguide-users] Can you help with connection properties for OSGeo.SQLServerSpatial? Martin Morrison wrote: Once you type the service name in, are you able to login? No, I can't see anywhere to login. What should happen? JD - http://www.software-matters.co.uk Software Matters - http://www.software-matters.co.uk/bespoke-database-design.html Bespoke Database and Software Solutions -- View this message in context: http://n2.nabble.com/Can-you-help-with-connection-properties-for-OSGeo-SQLServerSpatial-tp3998955p3999513.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
RE: [mapguide-users] Can you help with connection properties for OSGeo.SQLServerSpatial?
Martin Morrison wrote: What version of which provider are you using? The SQL spatial provider has a login button... Am using MGStudio 09 and the provider doesn't have a number it just says: OSGeo.SQLServerSpatial - http://www.software-matters.co.uk Software Matters - http://www.software-matters.co.uk/bespoke-database-design.html Bespoke Database and Software Solutions -- View this message in context: http://n2.nabble.com/Can-you-help-with-connection-properties-for-OSGeo-SQLServerSpatial-tp3998955p484.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users