Create Table Error using C API

[Steve Graber]

I'm having trouble creating tables using the C API. The same query works fine from the mysql command line interface. Here is the C code.

char* szCreateTableSQL = "CREATE TABLE DATALOG (Timestamp TIMESTAMP, TransportType INT, Address VARCHAR(64), DBName VARCHAR(64), UserName VARCHAR(64), Password VARCHAR(64), DataLog1 VARCHAR(255), DataLog2 VARCHAR(255), DataLog3 VARCHAR(255), DataLog4 VARCHAR(255), DataLog5 VARCHAR(255))";

if ( mysql_query( myData, szCreateTableSQL ) )
{
}

I'm using version 4.1 of MySQL. Can anyone tell me what I am doing wrong?

Thank you for your help,
Steve