[Mapserver-users] shapfiles 2 MS-SQL Server

[Eduardo Patto Kanegae]

it's basically a "1-to-1" relationship between the shapefile table ( the 
.dbf file) and its database table (mssql).

if u have a point shapefile layer that represents the cities, u should 
also have a table in your database to store more information about each 
city. at the shapefile table and also at the database table u must have 
a common identification field...
so, u run a query against the mssql database, get the ID's ( e.g.: 1, 2, 
3, 5 and 9) and finally ask mapserver to draw cities
which has ID's equal ( 1or 2 or 3 or 5 or 9)

best.

Eduardo

taufan at ebdesksolutions.com escreveu:

>Thank's for your help, but can you explain more detail to me, i'm really need 
>this 'dual' platform work. How i can make this connection possible.
>
>I think i can change link to .dbf in mapfile to my database in sql server. i'm 
>get this idea from Mapinfo MapX. 
>
>Thank's for your kindness
>
>
>Best Regards, 
>Emanuel Taufan R. N 
>GiS Specialist - Indonesia
>
>
>Quoting Eduardo Patto Kanegae <eduardo at consultoria.eti.br>:
>
>  
>
>>By this time I think u can't. Although microsoft is preparing a MSSQL 
>>version( Yukon) which will support
>>spatial data, I haven't heard nothing about MapServer reading MSSQL 
>>datasets.
>>
>>But u can use a 'dual' plataform like using ShapeFiles(maps) + MSSQL(to 
>>store relational data) and link both
>>with the help of a GEO-IDentification field.
>>
>>best.
>>
>>Eduardo Patto Kanegae
>>http://www.consultoria.eti.br
>>
>>## Projeto MapServer Brasil - http://mapserver.cttmar.univali.br ##
>>***************************************
>>***Fim da Mensagem / End of Message ***
>>***************************************
>>
>>
>>
>>taufan at ebdesksolutions.com escreveu:
>>
>>    
>>
>>>Dear All.
>>>
>>>I would like use data source from MS-SQL Server (database) with mapserver,
>>>      
>>>
>>How I 
>>    
>>
>>>can connect my shapfiles in the MS-SQL database format?
>>>
>>>
>>>Taufan
>>>
>>>
>>>
>>>.
>>>_______________________________________________
>>>Mapserver-users mailing list
>>>Mapserver-users at lists.gis.umn.edu
>>>http://lists.gis.umn.edu/mailman/listinfo/mapserver-users
>>>
>>>
>>> 
>>>
>>>      
>>>
>>-- 
>>
>>
>>    
>>
>
>
>
>.
>
>
>  
>

-- 
Eduardo Patto Kanegae
http://www.consultoria.eti.br

## Projeto MapServer Brasil - http://mapserver.cttmar.univali.br ##
***************************************
***Fim da Mensagem / End of Message ***
***************************************