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 <[EMAIL PROTECTED]> To: [email protected] 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: [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
