Thanks,Zac, for your help. The connection details are correct - I use them all the time in about 3 other pieces of software.
Couldn't find a simple version number for the SQL Server native client - ended up going into the registry .. (This was the latest version that I could find on the Microsoft site today.) HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products\0B739D9D248E031459889B848E6709A4\ProductName=Microsoft SQL Server 2008 Native Client HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products\0B739D9D248E031459889B848E6709A4\Version=0xa000640(167773760) (For security reasons, I have changed the username and password values, below.) <?xml version="1.0" encoding="utf-8"?> <FeatureSource xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; xmlns:xsd="http://www.w3.org/2001/XMLSchema"; xsi:noNamespaceSchemaLocation="FeatureSource-1.0.0.xsd"> <Provider>OSGeo.SQLServerSpatial</Provider> <Parameter> <Name>Username</Name> <Value>geo</Value> </Parameter> <Parameter> <Name>Password</Name> <Value>fred</Value> </Parameter> <Parameter> <Name>Service</Name> <Value>maittestsql\testsql2008</Value> </Parameter> <Parameter> <Name>DataStore</Name> <Value>geol_dwh_test</Value> </Parameter> </FeatureSource> Regards, David On Thu, Jun 10, 2010 at 11:54 AM, Zac Spitzer <[email protected]> wrote: > The problem you are describing is FDO specific, which is an underlying > layer of MapGuide... > > but, b4 we go that far over to fdo-users, your original post was missing > the information like is the exact version of the native client, plus the > xml > definition of your feature source, > > ie it could be the connection parameters are simply wrong? > > z > > > On 10 June 2010 11:47, David Collins <[email protected]> wrote: > > At the moment, the problem description is very tied to MapGuide. > > Can you (or someone) tell me how to simplify the problem for the benefit > of > > the FDO-users list? > > ie. Can I use some lower-level FDO utility to try to create the SQL > > connection, that doesn't involve the MapGuide software? > > > > > > On Thu, Jun 10, 2010 at 11:21 AM, Zac Spitzer <[email protected]> > wrote: > >> > >> I'd suggest posting this question on fdo-users as it's a specific FDO > >> question > >> -- > >> Zac Spitzer > >> Solution Architect / Director > >> Ennoble Consultancy Australia > >> http://www.ennoble.com.au > >> http://zacster.blogspot.com > >> +61 405 847 168 > > > > > > _______________________________________________ > > mapguide-users mailing list > > [email protected] > > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > > > > > > > -- > Zac Spitzer > Solution Architect / Director > Ennoble Consultancy Australia > http://www.ennoble.com.au > http://zacster.blogspot.com > +61 405 847 168 > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users >
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
