ROOT and Microsoft Access (using ODBC)

Hi all,

My first post here.

I have a Microsoft Access database with data that I need to get into ROOT. I have defined a data source, but ROOT always returns an error (cannot connect to the datasource).

I think the problem is to do with the fact I am running on WinXP 64. There are two data source locations (64 bit and 32 bit). I have tried all I can think of to access the DB, but no luck at all. I’ve tried .dsn files, and also referencing the db directly in the calls to either “ODBC://”, "“odbcd://” and "“odbcn://”.

Has anyone done this before and had some success?

For info, the code works perfectly on a 32bit platform.

All the best,

Tony.