On Wed, Sep 22, 2004 at 02:58:39PM -0400, Jeff <[EMAIL PROTECTED]> wrote:
>
> On Sep 22, 2004, at 2:37 PM, David Good wrote:
> >
> >$db = "foo";
> >$dbcc_sql = "dbcc checkdb($db)";
> >my $sth = $dbh->prepare($dbcc_sql);
> &
t this error:
DBD::ODBC::st execute failed: called with 1 bind variables
when 0 are needed at ./sql_dbcc line 558.
If I use "do" with a placeholder:
$db = "foo";
$dbcc_sql = "dbcc checkdb(?)";
if ($dbh->do($db
I did my tests again with an error handler this time. I'm
attaching the modified scripts and the logs in case you'd like to look
through them.
--
David Good[EMAIL PROTECTED]
This space intentionally le
rsimplified by test case. I think I should've put in an
error handler to catch the status messages like I do in the real backup
script. That might highlight the problem. I'll try to do that on Monday...
> I think it's a bug, but I don't believe it&
as well as trace logs (with DBI_TRACE=9) for each
of them.
--
David Good[EMAIL PROTECTED]
This space intentionally left blank.
#! perl
use strict;
use warnings;
use DBI;
my $dbh = DBI->connect(
"dbi:ODBC:DEVCYGW
On Fri, Jul 02, 2004 at 08:37:43PM +0200, Michael Peppler <[EMAIL PROTECTED]> wrote:
> On Fri, 2004-07-02 at 20:19, David Good wrote:
> > I'm having trouble with DBD::Sybase 1.04 on ActivePerl 5.8.4 (build 810)
> > on Windows. It seems to hang when connecting. Here
m line 99 via foo line 10
<> DESTROY ignored for outer handle DBI::st=HASH(0x1c1c9e0) (inner
DBI::st=HASH(0x1c1ca7c) has ref cnt 1)
>> DESTROY DISPATCH (DBI::st=HASH(0x1c1ca7c) rc1/1 @1 g0 ima4 pid#2184) at
c:/Perl/site/lib/DBD/Sybase.pm line 99 via foo line 10
-> DESTROY for DBD::Sybase::st (DBI::st=HASH(0x1c1ca7c)~INNER) thr#15d4a54
syb_st_finish() -> ct_cancel(CS_CANCEL_ALL)
--
David Good[EMAIL PROTECTED]
This space intentionally left blank.
some discussion here about this a few months ago.
You may wish to check the archives. It's a feature already present in
DBD::Sybase and DBD::ODBC (for ODBC drivers that support it). IIRC,
it'll be in the next release of DBD::DB2.
--
David Good [
> I guess, it should be possible.
> > But I have NOT been able to accomplish this.
> >
> > Any clue/help will be greatly appreciated.
> >
> > Thanks,
> > MVRamana
> > _____
> > Get y
_Programming the Perl DBI_ does not mention multiple result sets. Is
> > this a tacit admission that such capability is not (yet) a part of DBI?
> > Did I miss an explicit such admission somewhere?
> >
> > Keith Junker
>
> --
> Michael Peppler - Data Migrations
roeck
<[EMAIL PROTECTED]> wrote:
> David,
>
> By the way : the same answers is good for Pro*C : with one particular Pro*C program,
>you can connect
> to any Oracle version. No need to recompile.
>
> Brgds,
>
> Mark
>
>
> David Good wrote:
>
> >
et v2 on older versions of
> Oracle. Up to 7.3.4, SQL*Net v1 was still supported. Starting from 7.3.4, you
> can't use v1 anymore. So, if you want to connect to pre-7.3.4 versions, make sure
> you have the SQL*Net v2 listener configured and running.
>
> Hope this helps,
>
piled
alot differently for each version of Oracle they want it to run against.
Is it possible to have one copy of DBD::Oracle that'll work with Oracle 7, 8
and maybe even 9?
--
David Good [EMAIL PROTECTED]
This space intentionally left blank.
13 matches
Mail list logo