I am trying to move my website from IIS to Apache on Redhat 8. I have several Perl scripts on the site that access an MS SQL Server. So I am trying to configure my new Linux system so that database access from Perl is possible. I have installed Linux with Perl, and tested everything successfully. I've also downloaded and installed DBI.pm.
Here's where I'm stuck: I have downloaded DBD::ODBC, however when I attempt to install it, I get a message that says I need ODBCHOME set in my environment. I issued 'echo $ODBCHOME' and got nothing. I understand from my searching that I must set the ODBCHOME environment variable to my ODBC home directory, but I'm not even sure what my ODBC home directory is, or if it's something additional I should install. Is there a specific RPM package missing that I need to install? Can someone get me moving in the right direction?