.\" Automatically generated by Pod::Man 4.10 (Pod::Simple 3.35)
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sp \" Vertical space (when we can't use .PP)
.if t .sp .5v
.if n .sp
..
.de Vb \" Begin verbatim text
.ft CW
.nf
.ne \\$1
..
.de Ve \" End verbatim text
.ft R
.fi
..
.\" Set up some character translations and predefined strings.  \*(-- will
.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
.\" double quote, and \*(R" will give a right double quote.  \*(C+ will
.\" give a nicer C++.  Capital omega is used to do unbreakable dashes and
.\" therefore won't be available.  \*(C` and \*(C' expand to `' in nroff,
.\" nothing in troff, for use with C<>.
.tr \(*W-
.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
.ie n \{\
.    ds -- \(*W-
.    ds PI pi
.    if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
.    if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\"  diablo 12 pitch
.    ds L" ""
.    ds R" ""
.    ds C` ""
.    ds C' ""
'br\}
.el\{\
.    ds -- \|\(em\|
.    ds PI \(*p
.    ds L" ``
.    ds R" ''
.    ds C`
.    ds C'
'br\}
.\"
.\" Escape single quotes in literal strings from groff's Unicode transform.
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\"
.\" If the F register is >0, we'll generate index entries on stderr for
.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
.\" entries marked with X<> in POD.  Of course, you'll have to process the
.\" output yourself in some meaningful fashion.
.\"
.\" Avoid warning from groff about undefined register 'F'.
.de IX
..
.nr rF 0
.if \n(.g .if rF .nr rF 1
.if (\n(rF:(\n(.g==0)) \{\
.    if \nF \{\
.        de IX
.        tm Index:\\$1\t\\n%\t"\\$2"
..
.        if !\nF==2 \{\
.            nr % 0
.            nr F 2
.        \}
.    \}
.\}
.rr rF
.\" ========================================================================
.\"
.IX Title "DBD::Oracle::Troubleshooting::Cygwin 3pm"
.TH DBD::Oracle::Troubleshooting::Cygwin 3pm "2019-01-06" "perl v5.28.1" "User Contributed Perl Documentation"
.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
.\" way too many mistakes in technical documents.
.if n .ad l
.nh
.SH "NAME"
DBD::Oracle::Troubleshooting::Cygwin \- Tips and Hints to Troubleshoot DBD::Oracle on Cygwin
.SH "VERSION"
.IX Header "VERSION"
version 1.76
.SH "General Info"
.IX Header "General Info"
Makefile.PL should find and make use of \s-1OCI\s0 include
files, but you have to build an import library for
\&\s-1OCI.DLL\s0 and put it somewhere in library search path.
one of the possible ways to do this is issuing command
.PP
.Vb 1
\&    dlltool \-\-input\-def oci.def \-\-output\-lib liboci.a
.Ve
.PP
in the directory where you unpacked DBD::Oracle distribution
archive.  this will create import library for Oracle 8.0.4.
.PP
Note: make clean removes '*.a' files, so put a copy in a safe place.
.SH "Compiling DBD::Oracle using the Oracle Instant Client, Cygwin Perl and gcc"
.IX Header "Compiling DBD::Oracle using the Oracle Instant Client, Cygwin Perl and gcc"
.IP "1." 4
Download these two packages from Oracle's Instant Client for
Windows site
(http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html):
.Sp
Instant Client Package \- Basic: All files required to run \s-1OCI,
OCCI,\s0 and JDBC-OCI applications
.Sp
Instant Client Package \- \s-1SDK:\s0 Additional header files and an
example makefile for developing Oracle applications with Instant Client
.Sp
(I usually just use the latest version of the client)
.IP "2." 4
Unpack both into C:\eoracle\einstantclient_11_1
.IP "3." 4
Download and unpack DBD::Oracle from \s-1CPAN\s0 to some place with no
spaces in the path (I used /tmp/DBD\-Oracle) and cd to it.
.IP "4." 4
Set up some environment variables (it didn't work until I got the
\&\s-1DSN\s0 right):
.Sp
.Vb 2
\&      ORACLE_DSN=DBI:Oracle:host=oraclehost;sid=oracledb1
\&      ORACLE_USERID=username/password
.Ve
.IP "5." 4
.Vb 4
\&      perl Makefile.PL
\&      make
\&      make test
\&      make install
.Ve
.PP
Note, the \s-1TNS\s0 Names stuff doesn't always seem to work with the instant
client so Perl scripts need to explicitly use host/sid in the \s-1DSN,\s0 like
this:
.PP
.Vb 2
\&    my $dbh = DBI\->connect(\*(Aqdbi:Oracle:host=oraclehost;sid=oracledb1\*(Aq,
\&    \*(Aqusername\*(Aq, \*(Aqpassword\*(Aq);
.Ve
.SH "AUTHORS"
.IX Header "AUTHORS"
.IP "\(bu" 4
Tim Bunce <timb@cpan.org>
.IP "\(bu" 4
John Scoles <byterock@cpan.org>
.IP "\(bu" 4
Yanick Champoux <yanick@cpan.org>
.IP "\(bu" 4
Martin J. Evans <mjevans@cpan.org>
.SH "COPYRIGHT AND LICENSE"
.IX Header "COPYRIGHT AND LICENSE"
This software is copyright (c) 2018, 2014, 2013, 2012, 2011, 2010 by Tim Bunce.
.PP
This is free software; you can redistribute it and/or modify it under
the same terms as the Perl 5 programming language system itself.