DBD::ODBC Core Driver Version

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

Platform: Windows/Strawberry Perl 5.20 I am using latest DBI/ODBC packages. I am using DBD::ODBC ver 1.60. I would like to know how to find out the version of internal (windows) ODBC driver used?

Perl script using DBI methods 
            |
            v
           API 
            |
            v
           DBI
            |
            v
        DBD::ODBC
            |
            v
    ODBC Driver Manager
            |
            v
        ODBC Driver (How to find the version used here?)
[download]

Appreciate any help in this regard.

Comment on DBD::ODBC Core Driver Version Download Code

Replies are listed 'Best First'.
Re: DBD::ODBC Core Driver Version by GrandFather (Saint) on Oct 06, 2020 at 06:28 UTC
In the Windows search bar enter ODBC then click "ODBC Data Sources (64-bit). In the popup dialog click on the Drivers tab. Optimising for fewest key strokes only makes sense transmitting to Pluto or beyond	[reply]
Re^2: DBD::ODBC Core Driver Version by dominic01 (Sexton) on Oct 06, 2020 at 06:48 UTC
Thank you and I checked it and I do not see a ODBC Driver. However, I am able to connect to my SQL Server without any issues. I used `$dbh = DBI->connect( "DBI:ODBC:driver={SQL Server};Server=$server;Data +base=$database;UID=$dbusername;PWD=$dbpassword", { PrintError => 1, RaiseError => 1 } )` [download] Also I noted another driver "SQL Server". Hope that handles the connectivity part.	[reply] [d/l]
Re^3: DBD::ODBC Core Driver Version by afoken (Chancellor) on Oct 06, 2020 at 19:09 UTC
I checked it and I do not see a ODBC Driver See also DBD::ODBC::FAQ. On a 64 bit Windows, there are two ODBC managers: Why cannot I connect to my data source on Windows 64? If you are running a 32bit Perl on a 64bit Windows machine you will need to be aware there are two ODBC administrators and you need to create your DSNs with the right one. The ODBC Administrator you get to from Control Panel, Administrative Tools, Data Sources is the 64bit one and data sources created here will not be visible or useable from 32bit applications. The ODBC administrator you need to use for 32bit applications can be found at X:\windows\syswow64\odbcad32.exe. You can find more about this than you'd probably care to know at http://www.easysoft.com/developer/interfaces/odbc/64-bit.html Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply]