[fdo-users] FDO 3.5 & 3.4 - Cannot create connection to SQL Server 2008 in MapGuide

[David Collins]

Hello.

I have Mapguide 2.1 (Final) with FDO 3.4 and MapGuide 2.2 Beta 1 with FDO
3.5 running on 2 virtual Windows 2008 servers.
I cannot create a connection to SQL Server 2008 on either server ..

*FDO 3.4 -*
The remote server returned an error: (559) MgFdoException.:
An exception occurred in FDO component.
'FdoPtr::operator->': Cannot execute function due to invalid value for
the input parameter(s) 'p'.

*FDO 3.5 -*
The remote server returned an error: (559) MgConnectionFailedException.:
Problem:\nCannot establish connection to the MapGuide Server.\n\nPossible
Causes:\n-Your session has been idle for too long;\n-MapGuide Server is no
longer responding;\n-Internet connection problems.\n\nSolution:\nRestart
your application / session, restart the MapGuide Server service, or contact
with the server administrator.
- Yes, the error message sounds unrelated to the SQL connection, but I don't
get this error if I make a SHP or Oracle connection.

I have the latest SQL Server native client installed ..
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)

<?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>

Can someone help me?

Regards,
David

>> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20100610/99559be5/attachment.html