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

Thanks pryrt,

You're absolutely right. Good grief!

  • Comment on Re^3: Update: Using Perl to connect to an Access 10 database

Replies are listed 'Best First'.
Re^4: Update: Using Perl to connect to an Access 10 database
by merrymonk (Hermit) on May 31, 2019 at 08:29 UTC
    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;

    [download]

    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'?
[reply]
[d/l]

      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
[reply]
[d/l]
[select]
        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?
[reply]

In Section Seekers of Perl Wisdom