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

[pryrt]

64 bit - run %systemdrive%\Windows\SysWoW64\odbcad32.exe
32 bit - run %systemdrive%\Windows\System32\odbcad32.exe

Like many people, you got your bits-vs-folder confused, because of Microsoft's insane naming scheme. SysWow64 means "Windows 32-bit on Windows 64-bit", and is the folder that holds the 32bit executables and DLLs for use on a 64bit OS. System32 kept it's historic name, even though in 64-bit OSes, it's the directory for the 64bit system files. See File System Redirector in MS online docs for even more.

[stevieb]

Thanks pryrt,

You're absolutely right. Good grief!

[merrymonk]

Thank you for your comments.
This is an area I have never been to before so I am having trouble understanding the implications of what you have said. For example "you have to create your DSN in two locations:" sadly means nothing to me but I guess something may need to be done to the line

my $dsn = 'driver=Microsoft Access Driver (*.mdb, *.accdb);dbq='.$dbfi
+le;


I have found that I do have odbccad32.exe and odbc32.dll in both the SysWOW64 and System32 directories. I am using Windows 10 OS.
I get the impression that I may have to do something so that the correct odbccad32.exe is used?
Is that correct and if so can you point me to some web page that has more 'clues'?

[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