[mapguide-users] Re: MGOS 2.2 on Windows 2008 Server - Problem connecting from Maestro

[David Collins]

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 <zac.spitzer at gmail.com> 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 <david.8.collins at gmail.com> 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 <zac.spitzer at gmail.com>
> 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
> > mapguide-users at lists.osgeo.org
> > 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
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20100610/0b26a63c/attachment.html