Jeff
Same env as before.
After running the test, I find I can't delete the table perl_dbd_test
from the db test.
A little program with
my($sql) = 'drop table perl_dbd_test';
my($sth) = $dbh -> do($sql);
outputs:
Error: DBD::mysql::db do failed: Error on delete of
'.\test\perl_dbd
Jeff
Same env as before.
t\07bind.1..10
ok 1
Test 2: connecting to the database
ok 2
Test 3: create test table
Using fields: COL_A smallint NOT NULL PRIMARY KEY , COL_B
varchar(255), COL_C long varchar, COL_D da
tetime
DBD::ODBC::db do failed: [MySQL][ODBC 3.51
Driver][mysqld-3.23.51-ma
Jeff
Same env as in previous post.
t\05meth.1..6
ok 1
ok 2
DBD::ODBC::db rollback failed: [MySQL][ODBC 3.51 Driver]Warning:
Some non-transactional changed tab
les couldn't be rolled back (SQL-HY000)(DBD: db_rollback/SQLTransact
err=-1) at t\05meth.t line 34.
ok 3
ok 4
ok 5
ok 6
calling f
Jeff
I'm working thru the tests, and have some problems.
Environment:
OS: Win2K
Perl 5.8.0
DBI 1.30
DBD::ODBC 1.01
MyODBC 3.51.04
MySQL 3.23.51
Problem (1 of several, for the moment):
t\03dbatt1..16
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
not ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 1
Yep... that is ABSOLUTELY correct.
Also not that he is using 32bit oracle, which is different from my setup. I
suggested he try the 64bit oracle client.
To mention some thing else that should be obvious... is SHLIB_PATH set to
the oracle lib dir?
Lincoln
-Original Message-
From: NIPP,
I use DBIx::Recordset but every time I invoke it with perl 5.6.1 and
DBD::Oracle 1.12, I see this:
Use of uninitialized value in string eq at
/usr/lib/perl5/site_perl/5.6.1/i386-linux/DBD/Oracle.pm line 327.
Use of uninitialized value in string eq at
/usr/lib/perl5/site_perl/5.6.1/i386-linux/DBD/O
This may or may not be obvious... Did you add the -lcl and
-lpthreads as the first in the list of libraries? I have learned from
experience they absolutely have to be the first two in the list in that
order. Also, maybe obvious, you were compiling Perl with the -lcl and
-lpthreads, right
Greetings,
I have spent about two weeks going over the archives and reading
everything I can find out the DBD on hpux. I still can't get it to work
Short form:
HPUX 11.11 64 bit
Oracle 8.1.7 32 bit
HP extra cost compiler
Perl 5.8.0 and 5.6.1 used
DBI 1.18, 1,25 and 1.30 all tried
DBD 1.07 and 1.1
Thanks much, David.
--
Jeff
Crown David T. (DNREC) wrote:
Since I'm attempting to keep an eye on the list for anything that looks
interesting for the FAQ, if you have not the time/inclination/whatnot to
put it in the FAQ, flag it (Ilya - FAQ? Caught my eye on this one), and
I'll take care of it
Thanks, David, really really appreciate all your work on this, past and present:-)
Ilya
-Original Message-
From: Crown David T. (DNREC) [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 3:08 PM
To: Michael A Chase; Jeff Zucker
Cc: dbi-users
Subject: RE: Re: Having Problems with
Since I'm attempting to keep an eye on the list for anything that looks
interesting for the FAQ, if you have not the time/inclination/whatnot to
put it in the FAQ, flag it (Ilya - FAQ? Caught my eye on this one), and
I'll take care of it.
David Crown, MCSE, MCP+I, CCNA
Office of Information Techno
On Thu, 12 Dec 2002 11:52:25 -0800 Jeff Zucker <[EMAIL PROTECTED]> wrote:
> Sterin, Ilya (I.) wrote:
>
>> Anyone can add to the FAQ, they just need to register and create a
>> password first
>
>
> Yep, and thanks for all your work on it. I guess I was being lazy and
> asking if this is alread
No problem:-) I was going to do it myself, but I'm a bit busy at the
moment:-)
Ilya
-Original Message-
From: Jeff Zucker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 2:52 PM
Cc: dbi-users
Subject: Re: Having Problems with DBD::CSV (Ilya - FAQ?)
Sterin, Ilya (I.) wrote:
Sterin, Ilya (I.) wrote:
Anyone can add to the FAQ, they just need to register and create a password first
Yep, and thanks for all your work on it. I guess I was being lazy and
asking if this is already covered, but I can look that up myself when/if
I ever have time.
--
Jeff
Ilya
-O
Anyone can add to the FAQ, they just need to register and create a password first,
which can be done from the FAQ screen.
Ilya
-Original Message-
From: Jeff Zucker [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 12, 2002 1:39 PM
To: David Steinbrunner; dbi-users
Subject: Re: Having P
Hi David,
SQL string values must occur between single quotes, not double quotes:
SELECT * FROM foo WHERE bar = 'baz' CORRECT
SELECT * FROM foo WHERE bar = "baz" WRONG
Values that have single quotes inside them must not appear in the SQL as
raw single, quotes, they must be escaped.
On 12/12/02 1:16 PM, M.W. Koskamp wrote:
>> > Select email from order_info where name = 'Tim O'Reilly'
>> DBD::CSV::db prepare failed: Mismatched single quote before: 'Reilly'
>> Cannot prepare Select email from order_info where name = 'Tim O'Reilly':
>> Mismatched single quote before: 'Reilly'
>
>
> Select email from order_info where name = 'Tim O'Reilly'
> DBD::CSV::db prepare failed: Mismatched single quote before: 'Reilly'
> Cannot prepare Select email from order_info where name = 'Tim O'Reilly':
> Mismatched single quote before: 'Reilly'
Did you try: where name = $dbh->quote("Tim O'
Hello,
I'm having two problems with DBD::CSV. I am working with two comma
delimited files and to start out on the small project I need to match
names from one file to a name in the other file. Here is the block of
code that I am using to get an idea of how many matches I have and what
is not mat
On Thu, 12 Dec 2002 08:23:29 -0800 (PST) Nanditha Gade <[EMAIL PROTECTED]> wrote:
> Hi,
> I have a stored procedure which returns an Oracle
> OBJECT. This object contains a list of objects, which
> inturn contain the table. I would like to read a
> column from this table.
>
> I am new to perl D
On Thu, 12 Dec 2002 08:43:14 -0800 (PST) steve hatfield <[EMAIL PROTECTED]>
wrote:
> I just need to know how does do handle errors?? Is it the same way as
> doing a prepare and execute?
You can look at the source code in DBI.pm to see how it is handled unless
overridden by the DBD. In fact it's
Hi all:
I just need to know how does do handle errors?? Is it the same way as doing a prepare
and execute?
Thanks,
Steve
-
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Hi,
I have a stored procedure which returns an Oracle
OBJECT. This object contains a list of objects, which
inturn contain the table. I would like to read a
column from this table.
I am new to perl DBI. Can some one tell me if this is
possible. If yes, any pointers would be great.
ps: Can yo
Lance,
The first thing to note is that for more recent DBD::ODBC's a newer OOB is
required to pass all of the 20SqlServer tests (I know you didn't get that far
but when you do mail me personally and I'll send you the most up to date OOB
client for Linux). The tests that sometimes fail with OOB cli
Well, I'm not sure what "Tried my best to install it" means. Did you get errors? Did
it install fine? Did you follow install instructions? Did you install it in the
standard directory? Do you have more than one perl interpreter on your system?
We need more info:-)
Ilya
-Original Messa
I'm trying to install the DBD::DB2 module from CPAN (DBD-DB2-0.76) onto an
AIX machine ( version 4.3.3.0) running perl version 5.005_03. I have
installed the DBI (DBI-1.32) module successfully; however, when I try to
install DBD::DB2 module, i'm running into problems. perl Makefile.PL ran
fine, a
Hello,
How do I recompile perl with -DDEBUGGING so that I can use the switch
-D ?
Thank you for your help,
Ghyslain Laramée
Programmer Analyst / Programmeur Analyste
Information Technology Services Directorate, PSC /
Direction des Services de technologie de l'information, CFP
613.947-0722,
Hello there,
I installed Perl on my new server a few days ago. As far as Perl,
everything is working except I couldn't get DBI.pm working correctly. I
downloaded the DBI.pm from
http://search.cpan.org/author/TIMB/DBI-1.32/DBI.pm site and tried my best to
install it.
The following error shows
On Wed, Dec 11, 2002 at 03:20:59PM -0700, Ken Miller wrote:
> I'm playing around with using Cache::MemoryCache to store some database
> 'objects'. However, when I stuff an object into the cache, and the cache
> goes out of scope, I get these messages:
>
> (in cleanup) dbih_getcom handle D
29 matches
Mail list logo
