Steve, is the script failing when you are using ADO or DBD::Sybase. You
said that DBD::Sybase worked? Did it generate a warning or how did you make
it call ADO, unless you tried to connect with it. Also I have never tried
ADO on anything other than wintel platforms, so not sure about the bug(s) or
if you can even get it to work. I know you must have OLE modules installed
for it to work, but I don't know if OLE modules were ever ported to other
platforms? I wouldn't try using ADO on non-win platforms (hope I didn't
offend anyone).
Maybe someone else can prove me wrong.
Ilya Sterin
-----Original Message-----
From: Steve Starer
To: Sterin, Ilya; [EMAIL PROTECTED]
Sent: 04/25/2001 2:00 PM
Subject: RE: Install question
> Are you using ADO?
No I'm not, and I don't intend to at this time . I think it got
installed
when I ran perl against the DBD bundle.
> connect to Sybase you need to install DBD::Sybase and use
DBI->connect("dbi:sybase:....") as your connect string.
I have the DBI working with the DBD for Sybase. I ran a query and it
worked
as expected. I guess the unexpected part of all of this was getting the
ADO
module installed, and then the fact that my test program failed when it
tried to access the ADO service. My expectation based upon the Cheetah
book
was that I'd get a successful execution of the test script.
Thanks again for your time.
Regards,
Steve Starer
Senior Systems Engineer
Fahnestock & Company
(212) 668-1281
[EMAIL PROTECTED]
-----Original Message-----
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 2:21 PM
To: 'Steve Starer '; '[EMAIL PROTECTED] '
Subject: RE: Install question
Are you using ADO? You are in a Solaris environment and the required
modules are not installed? If you want to connect to Sybase you need to
isntall DBD::Sybase and use DBI->connect("dbi:sybase:....") as your
connect
string.
http://cpan.valueclick.com/modules/by-category/07_Database_Interfaces/DB
D/
Ilya Sterin
-----Original Message-----
From: Steve Starer
To: [EMAIL PROTECTED]
Sent: 04/25/2001 11:59 AM
Subject: RE: Install question
> What's the error message?
The program name is probe-drivers.pl.
(roswell::/export/home/sstarer/src/perl)> ./probe-drivers.pl
Driver: ADO
install_driver(ADO) failed: Can't locate Win32/OLE/Variant.pm in @INC
(@INC
contains: /opt/lib/perl5/5.6.0/sun4-solaris /opt/lib/perl5/5.6.0
/opt/lib/perl5 /usr/local/lib/perl5/5.6.0/sun4-solaris
/usr/local/lib/perl5/5.6.0
/usr/local/lib/perl5/site_perl/5.6.0/sun4-solaris
/usr/local/lib/perl5/site_perl/5.6.0
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris
/usr/local/lib/perl5/site_perl/5.005 /usr/local/lib/perl5/site_perl .)
at
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/DBD/ADO.pm line 562.
BEGIN failed--compilation aborted at
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/DBD/ADO.pm line 562.
Compilation failed in require at (eval 1) line 3.
Perhaps a module that DBD::ADO requires hasn't been fully installed
at ./probe-drivers.pl line 12
thanks for the incredibly quick reply!
Regards,
Steve Starer
Senior Systems Engineer
Fahnestock & Company
(212) 668-1281
[EMAIL PROTECTED]
-----Original Message-----
From: Sterin, Ilya [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 25, 2001 12:07 PM
To: 'Steve Starer '; '[EMAIL PROTECTED] '
Subject: RE: Install question
What's the error message?
-----Original Message-----
From: Steve Starer
To: [EMAIL PROTECTED]
Sent: 04/25/2001 9:55 AM
Subject: Install question
Hope this is the right place to post. I sent mail to get the FAQ and am
awaiting a reply. In the meantime...
I'm in a Sybase/Solaris environment. New to Solaris, and new to Perl.
I just installed DBI. I need it to hit a Sybase database. I grabbed the
DBD
bundle first, and it installed it thinking it was for Sybase, but also
included other modules, in particular, ADO.pm which seems to be for
Microsoft.
I can hit my Sybase server fine, but as I'm new, I've been studying the
cheetah, and the first program in its chapter 3 is a probe of available
sources. It dies with a large error message referencing @INC,
ultimately
stating that perhaps I didn't install ADO properly.
I would love to back that module out, or fix it, and even better,
understand what I did wrong so I don't repeat the crime.
Any/All answers are gratefully appreciated.
Thanks!
Regards,
Steve Starer
Senior Systems Engineer
Fahnestock & Company
(212) 668-1281
[EMAIL PROTECTED]