Mapserver and MySQL

[Milo van der Linden]

Let me say that an OVF works excellent in combination with msSqlSpatial 
containing WKB geometry. I am however not sure that mySQL is so OGC 
compliant....

Frank Warmerdam schreef:
> Vishal Nagpal wrote:
>> Hello Everybody,
>> I am trying to use MapServer to read MySQL spatial data but it is 
>> unable to
>> open the database.
>> I tried to use ogrinfo MySQL:test user=mysql  tablename -so
>> But it gave a message that unable to open with existing drivers, I am 
>> working pretty fine with POSTGRES, DGN and DT2 layers is it possible 
>> that i have missed out on some steps in installation of GDAL/OGR,
>>
>> Also I tried to use ovf files but there too I faced the same problem,
>> Some of the examples of ovf file use
>> ODBC while others use MySQL which one to follow, is it OK to use either,
>
> Vishal,
>
> The MySQL driver is not built into OGR by default.  Did you build 
> GDAL/OGR
> from source yourself?  Did you explicitly configure in Mysql support?
>
> OVF (VRT) files are normally used when you use a mysql table through odbc
> that is not using spatial data types.  The OVF file tells OGR which 
> columns
> are x and y.
>
> Best regards,


-- 


	

Milo van der Linden
skype: milovanderlinden <skype:milovanderlinden?add>
mlinden at zeelandnet.nl <mailto:mlinden at zeelandnet.nl>
milovanderlinden at gmail.com <mailto:milovanderlinden at gmail.com>
milo at 3dsite.nl <mailto:milo at 3dsite.nl>
http://www.3dsite.nl

	  	

De informatie in dit bericht reflecteert mijn persoonlijke mening en 
niet die van een bedrijf of instantie. Aan de informatie kunnen geen 
rechten worden ontleend. Indien dit bericht onderdeel is van een forum, 
mailing-list of community dan gelden automatisch de bij het betreffende 
medium behorende voorwaarden. The information in this message reflects 
my personal opinion and not that of a company or public body. All rights 
reserved.If this message is contained in a mailing-list or community, 
the rights on the medium are automatically adapted.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20071106/e4866566/attachment.htm>