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.
  • Comment on Re: WIn32::ODBC - Can't call method "SqL" on an undefined value on XP machine