in reply to WIn32::ODBC - Can't call method "SqL" on an undefined value on XP machine
From my experience, in addition to the above node you should check that your DSN exists on the system. I have a web app using a similar connection method and I have my DSN setup as as system DSN and it works fine.
You mention that it works on Win2K but not XP indicating (to me) separate machines/systems that may not be setup identically.
I would consider start there.