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