[ms4w-users] OGR MySQL support

[Bart van den Eijnden]

I did compile it against the MySQL client on win32, it's quite  
straightforward.

PHP/Mapscript is probably built against GDAL 1.2.6, and the speed-up  
improvements for Virtual Spatial Data that you need Tom are not in 1.2.6.  
So you could drop them in your 1.2.6 GDAL tree and compile a new  
gdal12.dll, which would not require building a new PHP/Mapscript or  
mapserver binary.

Best regards,
Bart

On Tue, 13 Sep 2005 17:59:13 +0200, Frank Warmerdam <fwarmerdam at gmail.com>  
wrote:

> On 9/13/05, Kralidis,Tom [Burlington] <Tom.Kralidis at ec.gc.ca> wrote:
>>
>> Hi,
>>
>> We have a project in which we use OGR's virtual spatial option with a
>> MySQL connection in the .ovf file.  We have this working in a UNIX
>> environment successfully.
>>
>> We have a dev environment which is on Windows and are using the latest
>> ms4w.  The OGR does have MySQL support:
>>
>> Can anyone suggest how we can have this functionality?  Not sure if we
>> need a custom build of OGR?
>
> Tom,
>
> I think you can get the same access to a mysql database
> on windows using ODBC.  The direct mysql support in
> OGR was mainly implemented to avoid the hassle of
> setting up ODBC on unix.
>
> If you really need the direct mysql support you would
> indeed need a custom build.  In fact, I'm not sure that
> I have ever built the direct mysql support on windows.
>
> Best regards,



-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/