I have the chunk of code below. The exact same code with just a slightly different query to access a different database works fine in another script elsewhere on the site, but for some reason this page alone always throws the error:
Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement., SQL state 37000 in SQLExecDirect in C:\Inetpub\wwwroot\fuel\test.php on line 29
INSERT INTO mreports (Year, Month, File, Order) VALUES ('2003', 'Jan', 'monthlyreports/test.pdf', '1')
Record not added, an error occurred : 37000
Sorry if I misplaced this, my reasoning was that the error was a sql statement syntax error so it would've fallen under the mysql category.
The year field is defined as a number, as is the Order, everything else is numeric. I've tried removing the quotes and I get the same error, and actually in a working statement I have elsewhere for another DB and table I use the quotes and it works...