Re^5: Update: Using Perl to connect to an Access 10 database

[poj]

When you installed Access did you choose 64-bit or 32-bit version ?

Open Access and use File->Help to see under About Microsoft Access (on right)

Mine shows Version 14.0.7232.5000 (32-bit)

Udpdate : to check which drivers you have use

Control Panel -> System and Security -> Administrative Tools

Then select ODBC Data Sources (32-bit) or ODBC Data Sources (64-bit). Select Drivers tab.

poj

[merrymonk]

I have exactly the same data for the Version of Access.

Following your 'path', the Drivers tab says the File is ODBCJT32.DLL.
Does this mean that I can only use a 32 bit Perl to connect to the current version of Access or is there some way of using a 64 bit Perl with this Access?

As an alternate, is it likely that if I re-install Access as 64 bit I then can use the 64 bit Perl? If I do this do I also have to re-install other parts of Office 10 so that all are 64 bit?

[stevieb]

I wasn't very clear in my first post here. You don't have to re-install anything here. What I meant originally was:

• run the %systemdrive%\Windows\SysWoW64\odbcad32.exe command, and set up your DSN
• run the %systemdrive%\Windows\System32\odbcad32.exe command, and set up your DSN, *again*

Each of those corresponds with each platform. The first is the ODBC manager program for 32-bit, and the latter is for 64-bit. The DSNs for each version are stored separately (at least the system DSNs are, but I digress). After you've got your DSNs set up for both platforms, everything should just work.

[poj]

if I re-install Access as 64 bit I then can use the 64 bit Perl

Maybe, but I don't think the 64 bit ODBC driver is on the install disk so you need to download it. See 64bit v 32bit and be aware that "Compiled Access databases, like .MDE and .ACCDE files, won’t work unless they are specifically written for the 64-bit version of Office." and all the other caveats under "Reasons to choose the 32-bit version"

do I also have to re-install other parts of Office 10 so that all are 64 bit?

Yes, that is how I read it

poj