Hi,
I'm fairly new to Perl in general, so I'm having extra
difficulty with my question. I have Perl5 ver. 5.such-and-such
installed on my machine. I then also installed the Perl DBI (Database
Interface). I'd like to install the DBD::ODBC module, but I'm finding
little help on this. When downloading the module from www.perl.org/CPAN/modules/by-module/DBD and choosing DBD-ODBC-1.13, the README file (which includes most of the
instructions on how to build this module), is too vague for me when it
says:
[BEGIN]
BUILDING:
set-up these
environment variables:
DBI-DSN The dbi data source, e.g.
'dbi:ODBC:YOUR_DSN_HERE'
DBI_USER The username to use to connect to the
database
DBI_PASS The username to use to connect to the
database
ODBCHOME (Unix only) The dir your driver manager is installed
in
[END]
I have a basic
understanding of what these environment variables are, but I don't know where
I'm supposed to be setting them up? Is it assuming that I already have a
Perl script to put them in? And if so, I'm confused because the above
instructions come before the module is even completely built. I've
attached the full README file. If it
helps I'm working on a Redhat Linux system.
Thanks if you have
any info on this or advice as to who to talk to... =-)
~Sharon
DBD::ODBC -- DBD module interfacing the ODBC databases. $Id: README 93 2004-02-19 19:28:16Z jurl $
Copyright (c) 1994,1995,1996,1997,1998 Tim Bunce
portions Copyright (c) 1997,1998,1999,2000,2001,2002 Jeff Urlwin
portions Copyright (c) 1997 Thomas K. Wenrich
You may distribute under the terms of either the GNU General Public
License or the Artistic License, as specified in the Perl README file.
PLEASE READ THE ENTIRE README FILE CAREFULLY !
*BEFORE* BUILDING, TESTING AND INSTALLING this you will need to:
Build, test and install Perl 5 (as per DBI specifications/compatibility)
It is very important to TEST it and INSTALL it!
Build, test and install the DBI module (at least DBI 1.201).
It is very important to TEST it and INSTALL it!
Remember to *read* the DBI README file!
Remember to *read* the DBD::ODBC.pm POD documentation and the
DBD::ODBC::Changes.pm POD documentation!!!
BUILDING:
set-up these environment variables:
DBI_DSN The dbi data source, e.g. 'dbi:ODBC:YOUR_DSN_HERE'
DBI_USER The username to use to connect to the database
DBI_PASS The username to use to connect to the database
ODBCHOME (Unix only) The dir your driver manager is installed in
perl Makefile.PL
make (or nmake, if VC++ on Win32)
make test (or nmake, if VC++ on Win32)
TESTING
make test
make test TEST_VERBOSE=1 (if any of the t/* tests fail)
make install (if the tests look okay)
Note that the tests currently all pass when using the Microsoft SQL
server driver. See the known compatibility list below.
If the tests from t/09bind.t fail, that is an indication of lack of
ODBC Level 2 functionality. This does not (necessarily) mean that
your installation is broken. It does indicate that your ODBC driver
does not support certain level 2 calls (see below). All other tests
should pass, however, since I've tested with a limited number of ODBC
drivers, I could have something wrong in the test. Please notify me
if you have an incompatibility in the other tests. (For example,
some Paradox ODBC drivers *could* fail, if they don't support long
file names, since in Paradox file names are tableName.db.). Please
let me know about any incompatibilities you encounter (I'm sure you
will). I will say, though, that I may not be able to reproduce or
fix problems without some help, since I can't possibly install all
the known ODBC drivers. Please try to "solve" the problem, in
addition to discovering it.
If any of the tests fail and you are using SQL Server and Windows drivers,
ensure you updated to MDAC 2.7 or later.
NOTES on ODBC Drivers and Compatibility with DBD-ODBC
This version utilizes at least one "Level 2" ODBC call (SQLDescribeParam).
This *will* affect compatibility with specific ODBC drivers. If the
driver is not level 2 (or does not support the level 2 function(s)
required), then full compatibility will not be available.
DBD-ODBC currently uses SQLDescribeParam for binding parameters to queries.
You may (and probably will) have success using DBD-ODBC without binding
parameters.
In some future version you should be able to use bind_param even on
level 1 drivers. This is a VERY low priority!
KNOWN COMPATIBLE Drivers (w/level 2 calls):
Driver Version
Platform tested
Microsoft SQL Server v 2.65.0240 NT 4.0
Intersolv Oracle7 Driver* v 3.00.0000 NT 4.0
*full support is optional, via configuration of DSN -- Advanced page.
Select "Enable SQLDescribeParam".
IF YOU HAVE PROBLEMS:
Do not hand edit the generated Makefile unless you are completely sure
you understand the implications! Always try to make changes via the
Makefile.PL command line and/or editing the Makefile.PL.
You should not need to make any changes. If you do *please* let me
know so that I can try to make it automatic in a later release.
This software is supported via the dbi-users mailing list. For more
information and to keep informed about progress you can join the a
mailing list via http://www.fugue.com/dbi (if you are unable to use the
web you can subscribe by sending a message to [EMAIL PROTECTED], it
may take a few days to be processed).
Please post details of any problems (or changes you needed to make) to
[email protected] and CC them to me at [EMAIL PROTECTED] But note...
** IT IS IMPORTANT TO INCLUDE THE FOLLOWING INFORMATION:
1. A complete log of a all steps of the build, e.g.:
perl Makefile.PL (do a make realclean first)
make
make test
make test TEST_VERBOSE=1 (if any tests fail)
2. Full details of which software you are using, including:
Perl version (the output of perl -V)
It is important to check that you are using the latest version before
posting. If you're not then I'm *very* likely to simply say "upgrade to
the latest". You would do yourself a favour by upgrading beforehand.
Please remember that I'm _very_ busy. Try to help yourself first,
then try to help me help you by following these guidelines carefully.
Regards,
Tim and Jeff.
===============================================================================
Other info:
DBI 'home page': http://dbi.perl.org
perldoc DBI
perldoc DBD::ODBC (which will include the DBD::ODBC FAQ list)
perldoc DBD::ODBC::Changes
Win32 ODBC drivers:
http://www.microsoft.com/support/products/backoffice/odbc/
Follow "Microsoft ODBC Desktop Database Drivers 3.5 For 32-Bit Programs"
and "ODBC Drivers for Win95 Applications".
For Access use version "Access ODBC driver 3.40.2111 27/03/96" or later.
Also, see the examples in the tests and the mytest directory. They *do* show
some of the things you can do with the special DBD::ODBC functions.
End.
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
