[mapguide-users] how to create data connection based on SQLspatial 2008 with ADSK MGStudio 2007?

[Carl]

It works. Service means the server name and the datastore means the database
name.

Thank you All.

and then I create a new layer based on the sql spatial featuresource.
because there might be many spatial tables within a database, one spatial
table must be chosen as the feature class of the new layer.



Berdel, Brian wrote:
> 
> I created a connection (with the Help of Jason) by setting the server
> name as the service and the datastore as the database. 
> 
> Brian  Berdel 
> McMahon Associates, Inc. 
> p: 215.283.9444
> www.mcmtrans.com 
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Kenneth,
> GEOGRAF A/S
> Sent: Sunday, April 06, 2008 2:08 PM
> To: MapGuide Users Mail List
> Subject: Re: [mapguide-users] how to create data connection based on
> SQLspatial 2008 with ADSK MGStudio 2007?
> 
> AFAIK, the datastore is not used, and service parameter is the server
> name.
> Actually the Service is inserted in a string like:
> ConnectionString="DRIVER={SQL Server}; SERVER=" + service.
> So, service can probably also be: "localhost; Database=mydb".
> 
> Correct me if I'm wrong.
> 
> Regards, Kenneth, GEOGRAF A/S
> 
> 
> 
> Carl skrev:
>> I am trying to use the FDO for MS SQL 2008. the FDO library for SQL
> 2008 has
>> been added to bin/fdo and the providers.xml is updated accordingly.
> When the
>> tabpage of new featuresource is shown, how to fill following
> parameters:
>> username, password, service, and the datastore. It seems that username
> and
>> password are about one account of the sql server. but what's meaning
> of
>> service and datastore?
>>
>> Thanks in advance!
>>   
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://www.nabble.com/how-to-create-data-connection-based-on-SQL-spatial-2008-with-ADSK-MGStudio-2007--tp16526301s16610p16532808.html
Sent from the MapGuide Users mailing list archive at Nabble.com.