The AutoCommit is an over-site that I need to fix. You may
/opt init_autocommit=0, but it doesn't turn autocommit off. It just sets
the value to 0.
For now, use the "dbi:Sybase(AutoCommit=>0):..."
perldoc DBI
"You can also define connection attribute values within
the "$data_source" parameter. For example:
dbi:DriverName(PrintError=>0,Taint=>1):...
"
> > dbi:Sybase:server=XXXX;database=YYYY username passwd
Put quotes around dbi:Sybase...;... If you're using Linux/Unix, the
semi-colon is interpreted as a command separator.
I've applied for a PAUSE id. Hopefully I'll have a new DBI::Shell
release soon.
Tom
On Wed, May 09, 2001 at 04:09:52PM -0400, Curt Russell Crandall wrote:
> I don't think that'll work with dbish. Thanks anyway.
>
> On Wed, 9 May 2001, Jones Robert Contr 81 CS/SCK wrote:
>
> >
> > $dbh->{AutoCommit} = 0;
> >
> > -----Original Message-----
> > From: Curt Russell Crandall [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, May 09, 2001 1:57 PM
> > To: [EMAIL PROTECTED]
> > Subject: dbish questions
> >
> >
> > There's a couple of things I'm having a proble with when trying to use
> > dbish. First, I want to turn autocommit off. So, according to the
> > perldoc on DBI::Shell, I'm supposed to type /option autocommit=0, but when
> > I do I get the message:
> >
> > Unknown or ambiguous option name 'autocommit'
> >
> > I do see an init_autocommit, but I'm unsure if that does what I think it
> > would since it is not documented in the Perldoc.
> >
> > Second, I was trying to specify the database in the driver...
> >
> > dbi:Sybase:server=XXXX;database=YYYY username passwd
> >
> > This doesn't appear to work, however, dbi:Sybase:server=XXXX does
> > work. Is this a bug or is this intentional? It's asking for a DSN and
> > according to the documentation on DBD::Sybase, I am in both cases feeding
> > it a valid DSN.
--
Thomas A. Lowery
See DBI/FAQ http://tlowery.hypermart.net
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com