How can I connect my perl script to an Access 2010 (.accdb) file?

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I have had to hang on to my old ActivePerl 5.6.1 binary build 638 in order to use Win32::ODBC on my laptop with Windows(tm) 7 Home Premium O/S. What I found is that the C:\Windows\System32 directory (default for ODBC Administrator Utility accessed from the Windows Help System) contains no ODBC Drivers. But the C:\Windows\SysWOW64 directory does contain ODBC Drivers. So when I run the ODBC Admin Utility from that directory(via Windows Explorer), I do get a list of the Drivers installed (MS-Access, etc.). But this is still not enough. Even though I manually place C:\Windows\SysWOW64 in my path, I still cannot get the latest ActivePerl (5.26.1) Win32::ODBC module to work. It must have been altered sometime after 5.6.1 ActivePerl was released 15 years ago. I have not upgraded my Perl since then because of this long standing bug. My guess is that someone hard coded the Win32::ODBC module to look for drivers in C:\Windows\System32 alone.

Failed: Microsoft ODBC Driver Manager Data source name not found and no default driver specified

Comment on How can I connect my perl script to an Access 2010 (.accdb) file?

Replies are listed 'Best First'.

Re: How can I connect my perl script to an Access 2010 (.accdb) file?
by Sinistral (Monsignor) on Apr 30, 2019 at 14:46 UTC

It sounds like you are aware of the way to create an ODBC DSN, but perhaps these links will help:

Despite the names, the 32 bit ODBC Manager is in SysWow64 (and as you point out, that's where you want to find the drivers). Could you provide more information about how you're setting up the environment to perhaps get better help?

[reply]


laziness, impatience, and hubris
	PerlMonks