UDF on Windows XP

[gjking]

Hi guys,

Does anyone have experience with creating a UDF by means of a *.dll on a Windows XP platform.

I use the following software:

Windows XP
PHP 5.1.4
MySQL 5.0.21-community-nt
Apache/2.0.55 (Win32)
DevCpp IDE to compile the src

I compiled the udf_example.cpp from the example (contained in the MySQL src distribution):

C:\DevCpp\bin>g++ -shared -o c:\wamp\mysql\udf_example.dll c:\wamp\mysql\
udf_example.cpp -I c:\wamp\mysql\include -I c:\devcpp\include


And then I put the dll in c:\wamp\mysql\bin (where also the libmySQL.dll resides)
And then I tried to link a function in by means of:

CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example.dll'

But I get the following error: #1127 - Can't find function 'metaphon' in library

---------------------------------------------------------------------------------------------------

[list][*]Did I put the dll in the wrong place ?[*]Or do I have to compile it necessarily with VC++ ?[*]Or do I have to set some environment variable so MySQL knows where the dll can be found ?[*]................[/list]
Hope anyone can help me out...

Kind regards, GJ