components needed for Perl connect to MS SQL server on Redhat 8

Posted on 2003-02-23
Medium Priority
Last Modified: 2013-12-15
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?

Question by:rustycp
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Expert Comment

ID: 8009158
Yes, there's an RPM package unixODBC-2.2.2-3.i386.rpm (not installed by default unless you install 'Everything').

I think it's on CD3 of the install set.


Author Comment

ID: 8009362
Ok, I downloaded and installed unixODBC-2.2.2-3.i386.rpm, but when I go to my DBD::ODBC and attempt 'perl Makefile.PL' I still get the error.  Did the unixODBC install the directories I needed, but I have to set the environment varilables?  If so, where did it install them? Here is the exact error message: Thanks!

Using DBI 1.32 installed in /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/auto/DBI

The DBD::ODBC module needs to link with an ODBC 'Driver Manager'.
(The Driver Manager, in turn, needs one or more database specific ODBC drivers.
The DBD::ODBC module does _not_ include any ODBC drivers!)

You need to indicate where your ODBC Driver Manager is installed.
You can do this ether by setting the ODBCHOME environment variable
or by runing 'perl Makefile.PL -o odbcdir'.

If you do not have an ODBC Driver Manager you can try building
the free iODBC Driver Manager in the iodbcsrc directory.

Makefile.PL aborted.

Accepted Solution

linxit earned 400 total points
ID: 8015157
OK, it's a long time since I did this and I don't have access to my Linux box at the moment, but...

# rpm -ql unixODBC
 to list the files installed by the RPM, then set the ODBCHOME variable appropriately.

# export ODBCHOME=/usr/lib/odbc (just a guess)

Just in case, it may also be necessary to install the unixODBC-devel RPM as well.

Sorry I can't offer any more specific help.

You might also want to check out the documentation at www.unixodbc.org

Expert Comment

ID: 9086184
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Post your closing recommendations!  No comment means you don't care.

Featured Post

Create CentOS 7 Newton Packstack Running Keystone

A bug was filed against RDO for the installation of Keystone v3. This guide is designed to walk you through the configuration for using Keystone v3 with Packstack. You will accomplish this using various repos and the Answers file.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Fine Tune your automatic Updates for Ubuntu / Debian
Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will giveā€¦
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Suggested Courses
Course of the Month12 days, 13 hours left to enroll

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question