Nevermind- I was able to figure it out.  I had missed a line in the
README.win32 file- I was supposed to have editted makefile, not
makefile.mk to indicate my CCHOME and my CCTYPE.  I'm surprised
it worked as well as it did.  I started from
scratch, editting 'makefile', and it worked okay.  I did get a lot
of errors from the long.t test, though.  This is from a 8.1.5 client
accessing a 8.0.5 database.  We're going to be upgrading the database
soon, hopefully that will help.

C:\bperl\DBD-Oracle-1.06> set ORACLE_USERID=scott/tiger@idv8

C:\bperl\DBD-Oracle-1.06> nmake test

Microsoft (R) Program Maintenance Utility   Version 6.00.8168.0
Copyright (C) Microsoft Corp 1988-1998. All rights reserved.

        C:\bperl\5.6.0\bin\MSWin32-x86\perl.exe -Mblib
-Ic:\bperl\5.6.0\lib\MSWi
n32-x86 -Ic:\bperl\5.6.0\lib -e "use Test::Harness qw(&runtests $verbose);
$verb
ose=0; runtests @ARGV;" t\base.t t\general.t t\long.t t\plsql.t t\reauth.t
Using C:/bperl/DBD-Oracle-1.06/blib
t\base..............ok
t\general...........ok
t\long..............ok 71/140# failed test 72 at line 101. ORA-24345: A
Truncati
on or null fetch error occurred (DBD NO_DATA: OCIAttrGet OCI_ATTR_ROWID /LOB
ref
etch)
t\long..............NOK 72# failed test 73 at line 102. ORA-24345: A
Truncation
or null fetch error occurred (DBD NO_DATA: OCIAttrGet OCI_ATTR_ROWID /LOB
refetc
h)
t\long..............NOK 73# failed test 74 at line 103. ORA-24345: A
Truncation
or null fetch error occurred (DBD NO_DATA: OCIAttrGet OCI_ATTR_ROWID /LOB
refetc
h)
t\long..............ok 76/140# failed test 78 at line 118. Strings are of
differ
ent lengths (0 vs 20), Len 0
# failed test 79 at line 120. Strings are of different lengths (0 vs 20),
Len 0
# failed test 80 at line 122. Strings are of different lengths (0 vs 20),
Len 0
t\long..............ok 82/140# failed test 84 at line 136.
t\long..............NOK 84# failed test 85 at line 138. truncation error not
tri
ggered (LongReadLen 81910, data 1)
# failed test 86 at line 142. (DBI::errstr undefined)
t\long..............ok 88/140# failed test 90 at line 155.
t\long..............NOK 90# failed test 92 at line 158.
t\long..............NOK 92# failed test 94 at line 178. Strings are of
different
 lengths (0 vs 71680), Len 0
t\long..............ok 97/140# failed test 98 at line 197. (DBI::errstr
undefine
d)
# failed test 99 at line 198. Strings are of different lengths (0 vs 10240)
t\long..............ok 100/140# failed test 101 at line 201. (DBI::errstr
undefi
ned)
# failed test 102 at line 202. Strings are of different lengths (0 vs 81920)
t\long..............ok 103/140# failed test 104 at line 229. Fetched length
0, e
xpected 71680
# failed test 105 at line 230.
t\long..............ok 106/140# failed test 107 at line 101. ORA-01403: no
data
found (DBD NO_DATA: OCIAttrGet OCI_ATTR_ROWID /LOB refetch)
t\long..............NOK 107# failed test 108 at line 102. ORA-01403: no data
fou
nd (DBD NO_DATA: OCIAttrGet OCI_ATTR_ROWID /LOB refetch)
t\long..............NOK 108# failed test 109 at line 103. ORA-01403: no data
fou
nd (DBD NO_DATA: OCIAttrGet OCI_ATTR_ROWID /LOB refetch)
t\long..............ok 111/140# failed test 113 at line 118. Strings are of
diff
erent lengths (0 vs 20), Len 0
# failed test 114 at line 120. Strings are of different lengths (0 vs 20),
Len 0

# failed test 115 at line 122. Strings are of different lengths (0 vs 20),
Len 0

t\long..............ok 117/140# failed test 119 at line 136.
t\long..............NOK 119# failed test 120 at line 138. truncation error
not t
riggered (LongReadLen 81910, data 1)
# failed test 121 at line 142. (DBI::errstr undefined)
t\long..............ok 123/140# failed test 125 at line 155.
t\long..............NOK 125# failed test 127 at line 158.
t\long..............NOK 127# failed test 129 at line 178. Strings are of
differe
nt lengths (0 vs 71680), Len 0
t\long..............ok 132/140# failed test 133 at line 197. (DBI::errstr
undefi
ned)
# failed test 134 at line 198. Strings are of different lengths (0 vs 10240)
t\long..............ok 135/140# failed test 136 at line 201. (DBI::errstr
undefi
ned)
# failed test 137 at line 202. Strings are of different lengths (0 vs 81920)
t\long..............ok 138/140# failed test 139 at line 229. Fetched length
0, e
xpected 71680
# failed test 140 at line 230.

t\long..............NOK 140Some tests for LONG data type handling failed.
These
are generally Oracle bugs.
Please report this to the dbi-users mailing list, and include the
Oracle version number of both the client and the server.
Please also include the output of the 'perl -V' command.
(If you can, please study t/long.t to investigate the cause.
Feel free to edit the tests to see what's happening in more detail.
Especially by adding trace() calls around the failing tests.
Run the tests manually using the command "perl -Mblib t/long.t")
Meanwhile, if the other tests have passed you can use DBD::Oracle.

FAILED tests 72-74, 78-80, 84-86, 90, 92, 94, 98-99, 101-102, 104-105,
107-109,
113-115, 119-121, 125, 127, 129, 133-134, 136-137, 139-140
        Failed 36/140 tests, 74.29% okay
t\plsql.............ok
t\reauth............skipped test on this platform
Failed Test  Status Wstat Total Fail  Failed  List of failed
----------------------------------------------------------------------------
---
t\long.t                    140   36  25.71%  72-74, 78-80, 84-86, 90, 92,
94,
                                              98-99, 101-102, 104-105,
107-109,
                                              113-115, 119-121, 125, 127,
129,
                                              133-134, 136-137, 139-140
1 test skipped.


*************************************8
output from perl -V
Summary of my perl5 (revision 5 version 6 subversion 0) configuration:
  Platform:
    osname=MSWin32, osvers=4.0, archname=MSWin32-x86
    uname=''
    config_args='undef'
    hint=recommended, useposix=true, d_sigaction=undef
    usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
    useperlio=undef d_sfio=undef uselargefiles=undef 
    use64bitint=undef use64bitall=undef uselongdouble=undef usesocks=undef
  Compiler:
    cc='cl', optimize='-O1 -MD -DNDEBUG', gccversion=
    cppflags='-DWIN32'
    ccflags ='-O1 -MD -DNDEBUG -DWIN32 -D_CONSOLE -DNO_STRICT
-DPERL_MSVCRT_READFIX'
    stdchar='char', d_stdstdio=define, usevfork=false
    intsize=4, longsize=4, ptrsize=4, doublesize=8
    d_longlong=undef, longlongsize=8, d_longdbl=define, longdblsize=10
    ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=4
    alignbytes=8, usemymalloc=n, prototype=define
  Linker and Libraries:
    ld='link', ldflags ='-nologo -nodefaultlib -release
-libpath:"c:\bperl\5.6.0\lib\MSWin32-x86\CORE"  -machine:x86'
    libpth=C:\PROGRA~1\MICROS~4\VC98\lib
    libs=  oldnames.lib kernel32.lib user32.lib gdi32.lib winspool.lib
comdlg32.lib advapi32.lib shell32.lib ole32.lib oleaut32.lib  netapi32.lib
uuid.lib wsock32.lib mpr.lib winmm.lib  version.lib odbc32.lib odbccp32.lib
msvcrt.lib
    libc=msvcrt.lib, so=dll, useshrplib=yes, libperl=perl56.lib
  Dynamic Linking:
    dlsrc=dl_win32.xs, dlext=dll, d_dlsymun=undef, ccdlflags=' '
    cccdlflags=' ', lddlflags='-dll -nologo -nodefaultlib -release
-libpath:"c:\bperl\5.6.0\lib\MSWin32-x86\CORE"  -machine:x86'


Characteristics of this binary (from libperl): 
  Compile-time options:
  Built under MSWin32
  Compiled at Oct 19 2000 17:20:23
  @INC:
    c:/bperl/5.6.0/lib/MSWin32-x86
    c:/bperl/5.6.0/lib
    c:/bperl/site/5.6.0/lib/MSWin32-x86
    c:/bperl/site/5.6.0/lib
    .

-----Original Message-----
From: Brad Howerter [mailto:bhower@[...].com]
Sent: Thursday, October 19, 2000 3:03 PM
To: 'dbi-users@fugue.com'
Cc: 'tim.bunce@ig.co.uk'
Subject: Windows2000 DBD::Oracle link problem



I can't link DBD::Oracle in windows 2000.  I'll include the information
asked for in the README.

Some possibly pertinent info:
I'd already installed ActiveState's perl, but I don't think it's
conflicting.
I had to change my OCI directory name from oci to oci80.  This is Oracle
8.1.5.
I also tried linking STATIC, but that failed in a different way.

Any help you can give me would be greatly appreciated.

dbdimp.obj : error LNK2001: unresolved external symbol _strcmp
Oracle.obj : error LNK2001: unresolved external symbol __fltused
dbdimp.obj : error LNK2001: unresolved external symbol __fltused
dbdimp.obj : error LNK2001: unresolved external symbol __imp__atoi
oci8.obj : error LNK2001: unresolved external symbol __imp__atoi
dbdimp.obj : error LNK2001: unresolved external symbol _memset
oci8.obj : error LNK2001: unresolved external symbol _memset
dbdimp.obj : error LNK2001: unresolved external symbol _strlen
oci8.obj : error LNK2001: unresolved external symbol _strlen
dbdimp.obj : error LNK2001: unresolved external symbol _strcpy
dbdimp.obj : error LNK2001: unresolved external symbol __imp__sprintf
oci8.obj : error LNK2001: unresolved external symbol __imp__sprintf
oci8.obj : error LNK2001: unresolved external symbol __imp__strchr
oci8.obj : error LNK2001: unresolved external symbol __imp__strncpy
LINK : error LNK2001: unresolved external symbol __DllMainCRTStartup@12
blib\arch\auto\DBD\Oracle\Oracle.dll : fatal error LNK1120: 10 unresolved
extern


------------------------------------------------------------------------------
DBI HOME PAGE AND ARCHIVES: http://www.symbolstone.org/technology/perl/DBI/
To unsubscribe from this list, please visit: http://www.isc.org/dbi-lists.html
If you are without web access, or if you are having trouble with the web page, 
please send mail to dbi-users-request@[...].org with the subject line of:
'unsubscribe'.
------------------------------------------------------------------------------