Re: dbish questions
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=;database= 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=;database= username passwd
> >
> > This doesn't appear to work, however, dbi:Sybase:server= 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
Re: dbish questions
With dbish in DBI 1.14, if you do
/option init_autocommit=0
/connect back_ to_ your_ datasource
AutoCommit will be turned off.
I don't know about the Sybase DSN...
- Original Message -
From: "Curt Russell Crandall" <[EMAIL PROTECTED]>
To: "Jones Robert Contr 81 CS/SCK" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, May 09, 2001 4:09 PM
Subject: RE: dbish questions
> I don't think that'll work with dbish. Thanks anyway.
>
> On Wed, 9 May 2001, Jones Robert Contr 81 CS/SCK wrote:
>
> >
> >
> > Try ...
> >
> > $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=;database= username passwd
> >
> > This doesn't appear to work, however, dbi:Sybase:server= 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.
> >
> > Thank you,
> > Curt Crandall
> >
>
>
RE: dbish questions
I don't think that'll work with dbish. Thanks anyway.
On Wed, 9 May 2001, Jones Robert Contr 81 CS/SCK wrote:
>
>
> Try ...
>
> $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=;database= username passwd
>
> This doesn't appear to work, however, dbi:Sybase:server= 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.
>
> Thank you,
> Curt Crandall
>
RE: dbish questions
Try ...
$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=;database= username passwd
This doesn't appear to work, however, dbi:Sybase:server= 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.
Thank you,
Curt Crandall
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=;database= username passwd This doesn't appear to work, however, dbi:Sybase:server= 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. Thank you, Curt Crandall
