Q: compiling a UDF using VC++6

#1 (**permalink**) 03-20-2008, 12:47 PM

Greetings all,

I need to create a UDF under Windoze.

I've found some examples of MySQL UDFs and some webpages describing
how I need to compile them as a DLL (on a Windoze box).

I have Visual Studio 6.0 EE .

I'm running MySQL Server 5.0 installed as a precompiled binary. I do
see an ./include directory under C:\Program_Files\MySQL
\MySQL_Server_5.0 and this dir does contain the header files
referenced in the UDF examples I've found.

I need some help setting up my project in VC++6 to compile my UDF.
Would someone please give me a hand?

TIA,

Still-learning Steve

#2 (**permalink**) 03-20-2008, 12:47 PM

> I need some help setting up my project in VC++6 to compile my UDF.
> Would someone please give me a hand?

I've successfully compiled the dll with the HAVE_DLOPEN macro added to
the preprocessor definitions.
I've copied the dll to C:\Program Files\MySQL\MySQL Server 5.0\bin
I've logged in to the MySQL command line client as root so should have
privileges needed to create the function.
But when I try:
CREATE AGGREGATE FUNCTION foo RETURNS STRING SONAME 'udf_foo';
I get a
ERROR 1127 (HY000): Can't find function 'foo' in library
message.

Aaaargh! Anyone have an idea of what I'm doing incorrectly?

TIA,

Still-learning Steve

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode