Frank, <br><br>On a GDAL build like 1.3.1, would I need to use a vrt file, or can I just use the connect string syntax as detailed on <a href="http://www.gdal.org/ogr/drv_mysql.html">http://www.gdal.org/ogr/drv_mysql.html</a>
. <br><br>I am trying a string like: <br><br>C:\Program Files\FWTools1.0.0b2>MYSQL:aqiTest,user=xxx,password=xxx,host=<a href="http://10.4.5.100">10.4.5.100</a>,port=3306,tables=testdata<br>The filename, directory name, or volume label syntax is incorrect.
<br><br>OR<br><br>C:\Program Files\FWTools1.0.0b2>MYSQL:user=xxx,password=xxx,host=<a href="http://10.4.5.100">10.4.5.100</a>,port=3306,tables=aqiTest.testdata<br>The filename, directory name, or volume label syntax is incorrect.
<br><br><br>Thanks, <br><br>David.<br><br><br><div><span class="gmail_quote">On 3/31/06, <b class="gmail_sendername">Frank Warmerdam</b> <<a href="mailto:warmerdam@pobox.com">warmerdam@pobox.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
David Fawcett wrote:<br>> How far back does the MySQL driver in OGR go?<br><br>David,<br><br>Initial MySQL (nonspatial) support was implemented in late 2004<br>so it is in GDAL 1.2.6 and later.<br><br>> I know that the spatial
<br>> support is hot off of Hobu's grill, but is that when the driver was<br>> written as well. I am hoping to use a direct connect to MySQL in<br>> MapServer 4.6.1 to avoid setting up odbc. Simple X/Y columns for points.
<br><br>This should be possible with any appropriate build of a GDAL no older<br>than GDAL 1.2.6.<br><br>Best regards,<br>--<br>---------------------------------------+--------------------------------------<br>I set the clouds in motion - turn up | Frank Warmerdam,
<a href="mailto:warmerdam@pobox.com">warmerdam@pobox.com</a><br>light and sound - activate the windows | <a href="http://pobox.com/~warmerdam">http://pobox.com/~warmerdam</a><br>and watch the world go round - Rush | President OSGF,
<a href="http://osgeo.org">http://osgeo.org</a><br><br></blockquote></div><br>