in reply to SQL err in WIN32

Your problem seems to be solved, so I'll just comment on your use of the modules. Win32::ODBC is completely unrelated to DBI, so you would rarely if ever need to use both modules. Unless you need some special feature(s) of Win32::ODBC, I would just use DBI and DBD::ODBC, as it is more portable, you can use placeholders and bind values, and you are likely to get more help with it around here. But since you already have it working with Win32::ODBC, you can ignore that advice for now unless you want to do more work just for the sake of doing more work :)

Also, you seem to be including DB_File for no apparent reason, (so you should be able to remove all references to it and DBI AFAICT)