[FWTools] MySQL Driver

[Frank Warmerdam]

David Fawcett wrote:
> 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 
> <http://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 
> <http://10.4.5.100>,port=3306,tables=aqiTest.testdata
> The filename, directory name, or volume label syntax is incorrect. 

David,

You need to invoke a command!

eg.
ogrinfo 
MYSQL:aqiTest,user=xxx,password=xxx,host=10.4.5.100,port=3306,tables=testdata

If there are special characters in the password you may find you have to
quote argument to ogrinfo (with double quotes I imagine on windows).

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