RE: ANNOUNCE: Advanced DBI tutorial slides
I see some references to v2 several times in this list, but don't know the real state of it and I'm curious. So, is there a v2 in-process or is it just an idea for now? And when will we see a first release (alpha/beta/final)? -Original Message- From: Tim Bunce [mailto:[EMAIL PROTECTED] Sent: Monday, August 02, 2004 5:32 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: ANNOUNCE: Advanced DBI tutorial slides I uploaded the slides for my Advanced DBI tutorial shortly before OSCON but forgot to announce them: file: $CPAN/authors/id/T/TI/TIMB/DBI_AdvancedTalk_2004.tar.gz size: 3122405 bytes md5: b8a8f1732a0d67c6c69e48e4541c3162 Most easily read online via: http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/index.htm you'll also find some mention of DBI v2 here: http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/sld097.htm Tim.
RE: Questions about connectivity
ok. thanks for the reply :)
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Friday, March 05, 2004 1:30 AM
To: Burak Gursoy
Cc: [EMAIL PROTECTED]
Subject: Re: Questions about connectivity
On Thu, Mar 04, 2004 at 09:44:11PM +0200, Burak Gursoy wrote:
The mysql client library is helpfully automatically reconnecting you.
The latest version of DBD::mysql disables that (in most cases) because
it's
fundamentally unsafe, e.g., you've lost any table locks you think you
may
have.
uhm... so, this can cause a corrupted table?
Not physically corrupt, no. But a LOCK TABLE foo READ you did earlier
may be either a) no longer in effect, or b) still in effect but held by a
connection to the database that the mysql server doesn't yet realise is
dead.
Remember that the connection may have failed due to a temporary
network condition so the original server process may still be running.
and this can happen with other languages I believe? (as you said mysql
client library)
Yes.
Tim.
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 9:34 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Questions about connectivity
On Thu, Mar 04, 2004 at 05:58:43PM +, [EMAIL PROTECTED]
wrote:
The mysql client library is helpfully automatically reconnecting
you.
The latest version of DBD::mysql disables that (in most cases) because
it's
fundamentally unsafe, e.g., you've lost any table locks you think you
may have.
Tim.
Cheers Guys,
I have a related question, if I've stored some private_ data in the $dbh
object, and I wish to print this data to a logfile whenever an error
occurs,
I wanted to use an ErrorHandler subroutine which reads the private_ data.
But if the error occurs through an $sth I get a DBI::st rather than the
DBI::db handle back - and thus no access to the private data (I'm only
able
to control the creation code of the $dbh not any subsequent $sth's). So if
you have an $sth, is it possible to get the corresponding $dbh back from
the
$sth - if that makes any sense.
Is the documentation not clear about $sth-{Database} ?
Tim.
RE: Questions about connectivity
The mysql client library is helpfully automatically reconnecting you.
The latest version of DBD::mysql disables that (in most cases) because
it's
fundamentally unsafe, e.g., you've lost any table locks you think you may
have.
uhm... so, this can cause a corrupted table?
and this can happen with other languages I believe? (as you said mysql
client library)
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 04, 2004 9:34 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Questions about connectivity
On Thu, Mar 04, 2004 at 05:58:43PM +, [EMAIL PROTECTED] wrote:
The mysql client library is helpfully automatically reconnecting you.
The latest version of DBD::mysql disables that (in most cases) because
it's
fundamentally unsafe, e.g., you've lost any table locks you think you
may have.
Tim.
Cheers Guys,
I have a related question, if I've stored some private_ data in the $dbh
object, and I wish to print this data to a logfile whenever an error occurs,
I wanted to use an ErrorHandler subroutine which reads the private_ data.
But if the error occurs through an $sth I get a DBI::st rather than the
DBI::db handle back - and thus no access to the private data (I'm only able
to control the creation code of the $dbh not any subsequent $sth's). So if
you have an $sth, is it possible to get the corresponding $dbh back from the
$sth - if that makes any sense.
Is the documentation not clear about $sth-{Database} ?
Tim.
RE: Connecting to MS SQL 2000?
DBD::Sybase is used I think... or DBD::ODBC -Original Message- From: Ravi Malghan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 12:02 AM To: [EMAIL PROTECTED] Subject: Connecting to MS SQL 2000? What DBD module do I need to connect to a MS SQL 2000 DB? Thanks Ravi
Re: Problem In installing DBI in Win NT machine
ppm gets the archive(s) from activestate.com. so, you have to be connected to internet during installation... - Original Message - From: Abhra [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Abhra [EMAIL PROTECTED] Sent: Thursday, September 27, 2001 4:59 PM Subject: Problem In installing DBI in Win NT machine Hello I am a beginner in Perl . I have installed Active perl latest version in my Win NT machine. I am trying to install DBI module in my machine by both ppm and manual method. While installing I am facing following problem 1. while trying to install DBI in WIN NT machine by ppm I gave following command ppm ppm Install DBI It gives error: Could not locate a PPD file for the package BDI. Please note during installation internet connection was on and done proxy setting. 2. While trying to install by manual ,i have down loaded DBI madules from CPAN and gave following command perl Makefile.pl nmake it gives error : The name specified is not recognised as an internal or external command,operable program or batch file Please note: In my machine namke is available not dmake Can any body suggest me the remedy for the following problem and how i can install DBI in my window Nt machine Thanking in advance Abhra
