[FWTools] MySQL Driver

[David Fawcett]

Frank,

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
http://www.gdal.org/ogr/drv_mysql.html.

I am trying a string like:

C:\Program Files\FWTools1.0.0b2>MYSQL:aqiTest,user=xxx,password=xxx,host=
10.4.5.100,port=3306,tables=testdata
The filename, directory name, or volume label syntax is incorrect.

OR

C:\Program  Files\FWTools1.0.0b2>MYSQL:user=xxx,password=xxx,host=10.4.5.100
,port=3306,tables=aqiTest.testdata
The filename, directory name, or volume label syntax is incorrect.


Thanks,

David.


On 3/31/06, Frank Warmerdam <warmerdam at pobox.com> wrote:
>
> David Fawcett wrote:
> > How far back does the MySQL driver in OGR go?
>
> David,
>
> Initial MySQL (nonspatial) support was implemented in late 2004
> so it is in GDAL 1.2.6 and later.
>
> > I know that the spatial
> > support is hot off of Hobu's grill, but is that when the driver was
> > written as well.  I am hoping to use a direct connect to MySQL in
> > MapServer 4.6.1 to avoid setting up odbc.  Simple X/Y columns for
> points.
>
> This should be possible with any appropriate build of a GDAL no older
> than GDAL 1.2.6.
>
> Best regards,
> --
>
> ---------------------------------------+--------------------------------------
> I set the clouds in motion - turn up   | Frank Warmerdam,
> warmerdam at pobox.com
> light and sound - activate the windows | http://pobox.com/~warmerdam
> and watch the world go round - Rush    | President OSGF, http://osgeo.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/fwtools/attachments/20060403/0cbf3754/attachment.html