using load_file function

[jrwatson999]

I'm having trouble with the load_file function to read a file into a blob. (I am running MySQL 4.1.10 on RedHat Linux) I have a simple table with 2 columns: an INT key and a BLOB. As a test case, I inserted one row with values of 1 and null respectively.

The following SQL works from mysql command line:
UPDATE table SET blobcolumn = LOAD_FILE('/tmp/testfile.dat') WHERE keycolumn = 1;

However, from within a C program, where I log into same database as same user - that command does NOT work.

Am I missing some connection options when connecting in C? Is there a better or alternate method of reading data into a blob column in C?