mysql ogr connection

[vishal nagpal]

Hi,
you may like to read the discussion Mapserver and MySQL in the same list few days back,
Check with ogrinfo --fomats
It helped me.
All the best.
Vishal



----- Original Message ----
From: Berényi Attila <aberenyi at BURKEN.HU>
To: MAPSERVER-USERS at LISTS.UMN.EDU
Sent: Monday, November 12, 2007 8:36:53 PM
Subject: Re: [UMN_MAPSERVER-USERS] mysql ogr connection


Yeap,

<OGRVRTDataSource>
    <OGRVRTLayer name="data">
        
<SrcDataSource>MYSQL:data,user=root,password=*****,host=localhost,port=3306,tables=data</SrcDataSource> 

        <SrcSQL>SELECT ....</SrcSQL>
    <GeometryType>wkbPoint</GeometryType>
        <GeometryField encoding="PointFromColumns" x="x" y="y"/>
    </OGRVRTLayer>
</OGRVRTDataSource>

Any other idea?

Attila

Anakreon Mentis írta:
> Does the url contains the usr and pswd?
>
> For me it works and the ovf file is:
> <OGRVRTDataSource>
>     <OGRVRTLayer name="sites">
>        
 <SrcDataSource>MYSQL:db_test,user=root,password=,host=localhost,port=3306,tables=site</SrcDataSource> 
>         <SrcSQL>
>         query
>         </SrcSQL>
>         <GeometryType>wkbPoint</GeometryType>
>         <GeometryField encoding="PointFromColumns" x="x" y="y"/> 
>     </OGRVRTLayer>
> </OGRVRTDataSource>
>
>
>
>   


-- 
Berényi Attila        Attila Berényi
térinformatikus        GIS engineer
Burken Kft.        Burken Ltd.
--------------------------------------
H-1155 Budapest, Obsitos tér 2.
Tel.:    +36-1-415-0219
    +36-1-415-0220
Fax:    +36-1-410-1314
E-mail:    aberenyi at burken.hu




__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com