[fdo-users] Connection problem SQL Server 2008 and FDO

[Jackie Ng]

Hi Lorenzo,

If you're using the latest version of FDO Toolbox, try checking the
OSGeo.SqlServerSpatial provider under the "Providers" tab in the
Preferences, and see if you get the same problem.

If you don't get the same problem after checking that provider, you are
probably experiencing this problem: http://trac.osgeo.org/fdo/ticket/552,
which affects the ODBC Provider and I'm guessing, any provider under the
GenericRdbms framework (MySQL, SQL Server)

- Jackie


LFELLI wrote:
> 
> Hi to all,
> I have just installed Windows server 2008, SQL Server 2008 Express,
> MapGuide Open Source 2.0.2 and FDO 3.3.2
> To configure the SQL Server 2008 i followed :
> http://trac.osgeo.org/fdo/wiki/FdoSQLServerSpatialNotes
> I downloaded SqlSpatialTools. With this tool i've uploaded a .shp file on
> the Sql Server with Shape2Sql and previewed correctly with SqlSpatial tool
> included. 
> When i try to connect  SQL Server using MapGuide Maestro 1.0.9 (OSGeo FDO
> Provider for SQL Server Spatial) i'm able to create the feature source,
> but when i try to create a layer based on that feature source i receive
> the following error:
>  "Failed to read schema from data source.
> The operation gave the error message: Bad document."
> 
> This is all my test:
> I created a db called "navteq" with just one table called "dbo.isole"
> 
> -I change the table using only a column of type int (without any geometry
> or geography type data) but nothing changed.
> 
> -I downloaded and installed FDO Toolbox. The connection is ok, but when i
> expand the treeview i receive the following error:
> 
> Exception occurred: OSGeo.FDO.Common.Exception: Unable to find class 'S'
> at OSGeo.FDO.Commands.Schema.IDescribeSchemaImp.Execute() at ....
> The connection has a strange behavior, in fact if i collapse and then
> reexpand the node of the table the error is slightly different each time,
> for example:
> "Exception occurred: OSGeo.FDO.Common.Exception: Unable to find class
> 'sole' at ...
> I attached a picture with another slightly different error.
>  http://n2.nabble.com/file/n3764539/Errore.jpg 
> 
> Using DescribeSchema of mapagent (http://localhost:8008/mapguide/mapagent)
> this is the empty result:
> <?xml version="1.0" encoding="UTF-8" ?> 
>   <fdo:DataStore xmlns:xs="http://www.w3.org/2001/XMLSchema" 
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
> xmlns:xlink="http://www.w3.org/1999/xlink"
> xmlns:gml="http://www.opengis.net/gml" 
> xmlns:fdo="http://fdo.osgeo.org/schemas"
> xmlns:fds="http://fdo.osgeo.org/schemas/fds" /> 
> 
> 
> During installation progress of SqlServer 2008 Express i set "Mixed Mode"
> for the "Authentication Mode".
> I use "sa" user with the correct password for the connection, but i've
> also tried to connect with windows authentication mode but the result is
> always the same.
> 
> Am i missing something in the SQL Server configuration ?
> Does FDO needs a particular configuration for SQL Server 2008 ?
> 
> P.S.I've also tried with FDO 3.4.0 and 3.4.1 with no result.
> 
> Any hints any will be appreciated.
> 
> Lorenzo
> 

-- 
View this message in context: http://n2.nabble.com/Connection-problem-SQL-Server-2008-and-FDO-tp3764539p3765711.html
Sent from the FDO Users mailing list archive at Nabble.com.