<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
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....<br>
<br>
Frank Warmerdam schreef:
<blockquote cite="mid:4730773D.5010104@pobox.com" type="cite">Vishal
Nagpal wrote:
<br>
<blockquote type="cite">Hello Everybody,
<br>
I am trying to use MapServer to read MySQL spatial data but it is
unable to
<br>
open the database.
<br>
I tried to use ogrinfo MySQL:test user=mysql tablename -so
<br>
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,
<br>
<br>
Also I tried to use ovf files but there too I faced the same problem,
<br>
Some of the examples of ovf file use
<br>
ODBC while others use MySQL which one to follow, is it OK to use
either,
<br>
</blockquote>
<br>
Vishal,
<br>
<br>
The MySQL driver is not built into OGR by default. Did you build
GDAL/OGR
<br>
from source yourself? Did you explicitly configure in Mysql support?
<br>
<br>
OVF (VRT) files are normally used when you use a mysql table through
odbc
<br>
that is not using spatial data types. The OVF file tells OGR which
columns
<br>
are x and y.
<br>
<br>
Best regards,
<br>
</blockquote>
<br>
<br>
<div class="moz-signature">-- <br>
<title>3DSite</title>
<meta http-equiv="Content-Type" content="text/html; ">
<style type="text/css">
<!--
body {
background-color: #FFFFFF;
margin-left: 5px;
margin-top: 5px;
margin-right: 5px;
margin-bottom: 5px;
}
body,td,th {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
}
.style4 {font-size: 9px; }
.style5 {font-size: 9px; color: #CCCCCC; }
-->
</style>
<meta content="MSHTML 6.00.2900.2912" name="GENERATOR">
<br>
<table border="0" cellpadding="0" cellspacing="0" width="400">
<tbody>
<tr>
<td rowspan="3" align="left" height="0" valign="bottom" width="15"><br>
</td>
<td colspan="2" align="left" height="78" valign="top" width="0">
<p class="style4">Milo van der Linden
<br>
<a href="skype:milovanderlinden?add">skype: milovanderlinden</a><br>
<a href="mailto:mlinden@zeelandnet.nl">mlinden@zeelandnet.nl</a><br>
<a href="mailto:milovanderlinden@gmail.com">milovanderlinden@gmail.com</a><br>
<a href="mailto:milo@3dsite.nl">milo@3dsite.nl</a><br>
<a href="http://www.3dsite.nl">http://www.3dsite.nl</a><br>
</p>
</td>
<td rowspan="3" align="left" height="0" valign="top" width="15"> </td>
<td valign="top" width="300">
<p class="style5"><span lang="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.</span>
<span lang="EN">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.</span></p>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>