Re: Initial Install Issue
On Wed, 16 May 2001 08:56:00 -0500, Spohn, Albert F. wrote: Here's the error I'm getting: Driver: ADO install_driver(ADO) failed: Can't locate Win32/OLE/Variant.pm in @INC (@INC contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/pe. BEGIN failed--compilation aborted at /usr/lib/perl5/site_perl/5.005/i386-linux/DBD/ADO.pm line 562. Perhaps a module that DBD::ADO requires hasn't been fully installed at ./dbi_test line 10 It looks to me like you don't have Win32::OLE. -- Bart.
Re: Initial Install Issue
On Wed, 16 May 2001 16:11:01 +0200, Bart Lateur wrote: It looks to me like you don't have Win32::OLE. Eh? Driver: ADO install_driver(ADO) failed: Can't locate Win32/OLE/Variant.pm in @INC (@INC contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/pe. You're trying ADO on Linux? I was pretty damn sure ADO was Win32 only. -- Bart.
RE: Initial Install Issue
Win32::OLE is win only module. Ilya Sterin -Original Message- From: Bart Lateur To: [EMAIL PROTECTED] Sent: 05/16/2001 8:25 AM Subject: Re: Initial Install Issue On Wed, 16 May 2001 16:11:01 +0200, Bart Lateur wrote: It looks to me like you don't have Win32::OLE. Eh? Driver: ADO install_driver(ADO) failed: Can't locate Win32/OLE/Variant.pm in @INC (@INC contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/pe. You're trying ADO on Linux? I was pretty damn sure ADO was Win32 only. -- Bart.
Re: Initial Install Issue
On Wed, 16 May 2001 08:32:05 -0600, Sterin, Ilya wrote: Win32::OLE is win only module. As ADO stands for ActiveX Data Objects, I would say this counts for ADO also. I quote from the Perl DBI book (p.171): ADO (ActiveX Data Objects) is Microsoft's latest flavor of proprietary Win32-only data access API. ... If it helps, you can think of ADO as a layer of gloss over ODBC, though in fact it's built on Microsoft's OLE DB API. I'd say it's a mistake even trying to install DBD::ADO on Linux. -- Bart.
RE: Initial Install Issue
Ignore that program... it almost NEVER works. I'm on a [...] I'd reinstall DBD::Sybase and send the error output here. Okay, thanks. Here's the output of my DBD::Sybase make test. I checked the documentation suggestion for core dumps on linux (non-existant $SYBASE/locales stuff) and that proved not to be the case on my box. PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/lib/perl5/5.00503/i386-linux -I/usr/lib/perl5/5.00503 -e 'use Test::Ht t/autocommitCan't call method do on an undefined value at t/autocommit.t line 45. dubious Test returned status 255 (wstat 65280, 0xff00) Undefined subroutine Test::Harness::WCOREDUMP called at /usr/lib/perl5/5.00503/Test/Harness.pm line 288. make: *** [test_dynamic] Error 255 - Al
RE: Initial Install Issue
Yes, but I can imagine it can probably be simulated with OLE::Lite or similar cross platform modules, that allow OLE type access on non win32 platform, but then again why?? Ilya Sterin -Original Message- From: Bart Lateur To: [EMAIL PROTECTED] Sent: 05/16/2001 8:54 AM Subject: Re: Initial Install Issue On Wed, 16 May 2001 08:32:05 -0600, Sterin, Ilya wrote: Win32::OLE is win only module. As ADO stands for ActiveX Data Objects, I would say this counts for ADO also. I quote from the Perl DBI book (p.171): ADO (ActiveX Data Objects) is Microsoft's latest flavor of proprietary Win32-only data access API. ... If it helps, you can think of ADO as a layer of gloss over ODBC, though in fact it's built on Microsoft's OLE DB API. I'd say it's a mistake even trying to install DBD::ADO on Linux. -- Bart.
Re: Initial Install Issue
The only thing the program lacks is an eval around the data_sources
method call to cleanly catch drivers that are 'installed' but not
functional.
Tim.
On Wed, May 16, 2001 at 11:16:11AM -0400, Curt Russell Crandall wrote:
Ignore that program... it almost NEVER works. I'm on a Solaris box, it'll
go through the ADO driver no problem, but I get a similar error when it
hits the Oracle driver (can't locate DBD::Oracle).
I've run this program on several different systems: Linux, Solaris, HP-UX,
Irix with all sorts of DB's loaded on it and DBD drivers. NEVER, EVER has
this program worked correctly because it can't find one thing or
another. Not that the program code itself is to blame, but for some
reason it fails to print out data sources, etc. etc. due to the setup.
Also, I've never seen a Perl DBI install where DBD::ADO was NOT
present. Even if you load it onto a UNIX box, DBD::ADO always seems to be
in the install... I haven't checked the manifest for DBI, but I'd be
willing to bet you'd find that driver in there. But it is possible that
the Win32 modules were not included in your Perl install.
So, if you are getting a problem with installing DBD::Sybase, I doubt it
has anything to do with the error you got running that test
script. Do you have the OpenClient libs or the TDS libs installed on your
machine? DBD::Sybase won't install w/o them. If that is not the case,
I'd reinstall DBD::Sybase and send the error output here.
On Wed, 16 May 2001, Spohn, Albert F. wrote:
My initial install of DBI 1.15 bundle went without an apparent hitch. I
then attempted to run the following code from the O'Reilly Perl DBI book to
see what drivers were installed (expecting to see either 'none' or maybe one
that came with the DBI 1.15 bundle). My knee-jerk reaction was to try to
install a driver, then try again - so I tried the Sybase 0.91 DBD, but it
wouldn't install cleanly... so I figured I better address the initial issue
first. At any rate, here's the code:
#!/usr/bin/perl -w
use DBI;
my @drivers = DBI-available_drivers();
die No drivers found!\n unless @drivers;
foreach my $driver (@drivers ) {
print Driver: $driver\n;
my @dataSources = DBI-data_sources ($driver);
foreach my $dataSource ( @dataSources ) {
print \tData Source is $dataSource\n;
}
print \n;
}
exit;
Here's the error I'm getting:
Driver: ADO
install_driver(ADO) failed: Can't locate Win32/OLE/Variant.pm in @INC (@INC
contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/pe.
BEGIN failed--compilation aborted at
/usr/lib/perl5/site_perl/5.005/i386-linux/DBD/ADO.pm line 562.
Perhaps a module that DBD::ADO requires hasn't been fully installed
at ./dbi_test line 10
Here's my perl -V info:
Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration:
Platform:
osname=linux, osvers=2.2.14-5.0, archname=i686-linux
uname='linux jesse 2.2.14-5.0 #1 tue mar 7 21:07:39 est 2000 i686
unknown '
config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define
use64bitint=undef use64bitall=undef uselongdouble=undef usesocks=undef
Compiler:
cc='cc', optimize='-O2', gccversion=egcs-2.91.66 19990314/Linux
(egcs-1.1.2 release)
cppflags='-fno-strict-aliasing'
ccflags ='-fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64'
stdchar='char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lndbm -lgdbm -ldb -ldl -lm -lc -lposix -lcrypt
libc=/lib/libc-2.1.3.so, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under linux
Compiled at Mar 31 2001 23:48:51
@INC:
/usr/local/lib/perl5/5.6.0/i686-linux
/usr/local/lib/perl5/5.6.0
/usr/local/lib/perl5/site_perl/5.6.0/i686-linux
/usr/local/lib/perl5/site_perl/5.6.0
/usr/local/lib/perl5/site_perl
.
Many thanks to whomever was willing to wade through this junk! Any help
would be appreciated, of course.
- Al
Al Spohn
Publishing and Media Technology Services
Mayo Clinic 507-284-1666
Re: Initial Install Issue
On Wed, May 16, 2001 at 05:22:45PM +0100, Tim Bunce wrote:
I guess I could add an option to available_drivers() to have it hide
drivers that are 'installed' but fail to load.
D'oh. Forget that thinko. What it needs is an eval around the
data_sources method call.
Tim.
Tim.
On Wed, May 16, 2001 at 08:56:00AM -0500, Spohn, Albert F. wrote:
My initial install of DBI 1.15 bundle went without an apparent hitch. I
then attempted to run the following code from the O'Reilly Perl DBI book to
see what drivers were installed (expecting to see either 'none' or maybe one
that came with the DBI 1.15 bundle). My knee-jerk reaction was to try to
install a driver, then try again - so I tried the Sybase 0.91 DBD, but it
wouldn't install cleanly... so I figured I better address the initial issue
first. At any rate, here's the code:
#!/usr/bin/perl -w
use DBI;
my @drivers = DBI-available_drivers();
die No drivers found!\n unless @drivers;
foreach my $driver (@drivers ) {
print Driver: $driver\n;
my @dataSources = DBI-data_sources ($driver);
foreach my $dataSource ( @dataSources ) {
print \tData Source is $dataSource\n;
}
print \n;
}
exit;
Here's the error I'm getting:
Driver: ADO
install_driver(ADO) failed: Can't locate Win32/OLE/Variant.pm in @INC (@INC
contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/pe.
BEGIN failed--compilation aborted at
/usr/lib/perl5/site_perl/5.005/i386-linux/DBD/ADO.pm line 562.
Perhaps a module that DBD::ADO requires hasn't been fully installed
at ./dbi_test line 10
Here's my perl -V info:
Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration:
Platform:
osname=linux, osvers=2.2.14-5.0, archname=i686-linux
uname='linux jesse 2.2.14-5.0 #1 tue mar 7 21:07:39 est 2000 i686
unknown '
config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define
use64bitint=undef use64bitall=undef uselongdouble=undef usesocks=undef
Compiler:
cc='cc', optimize='-O2', gccversion=egcs-2.91.66 19990314/Linux
(egcs-1.1.2 release)
cppflags='-fno-strict-aliasing'
ccflags ='-fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64'
stdchar='char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lndbm -lgdbm -ldb -ldl -lm -lc -lposix -lcrypt
libc=/lib/libc-2.1.3.so, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under linux
Compiled at Mar 31 2001 23:48:51
@INC:
/usr/local/lib/perl5/5.6.0/i686-linux
/usr/local/lib/perl5/5.6.0
/usr/local/lib/perl5/site_perl/5.6.0/i686-linux
/usr/local/lib/perl5/site_perl/5.6.0
/usr/local/lib/perl5/site_perl
.
Many thanks to whomever was willing to wade through this junk! Any help
would be appreciated, of course.
- Al
Al Spohn
Publishing and Media Technology Services
Mayo Clinic 507-284-1666
Re: Initial Install Issue
I guess I could add an option to available_drivers() to have it hide
drivers that are 'installed' but fail to load.
Tim.
On Wed, May 16, 2001 at 08:56:00AM -0500, Spohn, Albert F. wrote:
My initial install of DBI 1.15 bundle went without an apparent hitch. I
then attempted to run the following code from the O'Reilly Perl DBI book to
see what drivers were installed (expecting to see either 'none' or maybe one
that came with the DBI 1.15 bundle). My knee-jerk reaction was to try to
install a driver, then try again - so I tried the Sybase 0.91 DBD, but it
wouldn't install cleanly... so I figured I better address the initial issue
first. At any rate, here's the code:
#!/usr/bin/perl -w
use DBI;
my @drivers = DBI-available_drivers();
die No drivers found!\n unless @drivers;
foreach my $driver (@drivers ) {
print Driver: $driver\n;
my @dataSources = DBI-data_sources ($driver);
foreach my $dataSource ( @dataSources ) {
print \tData Source is $dataSource\n;
}
print \n;
}
exit;
Here's the error I'm getting:
Driver: ADO
install_driver(ADO) failed: Can't locate Win32/OLE/Variant.pm in @INC (@INC
contains: /usr/lib/perl5/5.00503/i386-linux /usr/lib/pe.
BEGIN failed--compilation aborted at
/usr/lib/perl5/site_perl/5.005/i386-linux/DBD/ADO.pm line 562.
Perhaps a module that DBD::ADO requires hasn't been fully installed
at ./dbi_test line 10
Here's my perl -V info:
Summary of my perl5 (revision 5.0 version 6 subversion 0) configuration:
Platform:
osname=linux, osvers=2.2.14-5.0, archname=i686-linux
uname='linux jesse 2.2.14-5.0 #1 tue mar 7 21:07:39 est 2000 i686
unknown '
config_args=''
hint=recommended, useposix=true, d_sigaction=define
usethreads=undef use5005threads=undef useithreads=undef
usemultiplicity=undef
useperlio=undef d_sfio=undef uselargefiles=define
use64bitint=undef use64bitall=undef uselongdouble=undef usesocks=undef
Compiler:
cc='cc', optimize='-O2', gccversion=egcs-2.91.66 19990314/Linux
(egcs-1.1.2 release)
cppflags='-fno-strict-aliasing'
ccflags ='-fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64'
stdchar='char', d_stdstdio=define, usevfork=false
intsize=4, longsize=4, ptrsize=4, doublesize=8
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t',
lseeksize=8
alignbytes=4, usemymalloc=n, prototype=define
Linker and Libraries:
ld='cc', ldflags =' -L/usr/local/lib'
libpth=/usr/local/lib /lib /usr/lib
libs=-lnsl -lndbm -lgdbm -ldb -ldl -lm -lc -lposix -lcrypt
libc=/lib/libc-2.1.3.so, so=so, useshrplib=false, libperl=libperl.a
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-rdynamic'
cccdlflags='-fpic', lddlflags='-shared -L/usr/local/lib'
Characteristics of this binary (from libperl):
Compile-time options: USE_LARGE_FILES
Built under linux
Compiled at Mar 31 2001 23:48:51
@INC:
/usr/local/lib/perl5/5.6.0/i686-linux
/usr/local/lib/perl5/5.6.0
/usr/local/lib/perl5/site_perl/5.6.0/i686-linux
/usr/local/lib/perl5/site_perl/5.6.0
/usr/local/lib/perl5/site_perl
.
Many thanks to whomever was willing to wade through this junk! Any help
would be appreciated, of course.
- Al
Al Spohn
Publishing and Media Technology Services
Mayo Clinic 507-284-1666
