Hello,
I'm porting a DBI-Mysql application to Postgres, but I've big problems
with the BLOBs.
I have beening searching the internet for a while now, but unfortunately
couldn't find much information about how to read/write BLOB data from
Perl DBI in the Postgres DB.
Is there anyone who has dealt
Mr. Zhang,
0.29 or better should work, but get the latest from CPAN. Look at
mytest/testinout.pl for examples. If you still have problems, please post
to [EMAIL PROTECTED], as this list is for development discussions.
Jeff
Hi, I am a programmer working for Betasphere, in Silicon Valley.
Hi all,
I am having a problem installing the above module (Version 0.32). I have
succeeded in the past with a statically linked version but cannot get the
dynamic one going.
The driver I'm using is Redbrick (a data warehouse now provided by Informix
(IBM)). The only tweak that I have made is a
Michael A Chase wrote:
Sorry for interuption, would you tell more about why the database handles
should
be openned in the children. I want to know more more about this. I just
made
some changes to an Perl/DBI application so that it can run long processes
of
executing big SQL
Glen,
Whoops! Misspoke there the first time...
I asked Is it possible without using the ODBC administrator?
I meant, is it possible to create the databases in perl instead of
first creating them in Access?
Glen
I think the 'cheat' posted in response to your original post was a
You set LongReadLen and then proceed as usual. We need to know your
problem, before we can make an attempt to figure out what it is.
Ilya
-Original Message-
From: ZHU Jia
To: [EMAIL PROTECTED]
Sent: 2/7/02 2:32 AM
Subject: How to read/write BLOB in the Postgres DB from Perl DBI?
I suggest you use a driver manager, have DBD::ODBC link with the driver
manager and have the driver manager load your driver. unixODBC or iODBC
*should* work.
As a side note, It looks like dld.sl can't find the path
'../exe/libodbcinst.sl'
It could be a problem that it's a relative path...
What version of DBD::ADO are you using?
perl -MDBD::ADO -e 'print $DBD::ADO::$VERSION;'
Tom
On Wed, Feb 06, 2002 at 02:34:43PM +0100, jc plat wrote:
I want to set the AutoCommit property when opening my database
connection on a SQL server 7 on the same W2000 box.
I'm using ActiveState Perl
Are you sure you're using DBI?
If the password is incorrect, the connection should fail.
The behavior you describe is typical of Sqlplus.
Assuming that you have a scott/tiger account, the following script
should simply fail and report an error: ( change the value of $db first )
There are some significant changes in this release.
Please note that some tests may fail or report they are
unsupported on this platform. Notably Oracle's ODBC driver
will fail the advanced binding tests in t/08bind2.t.
These tests run perfectly under SQL Server 2000. This is
normal and
You are not doing yourself any favors by changing the topic without changing
the subject and removing the non-applicable messages.
Because I had been following this thread, I read your new comments, but
anyone who might be able to help with Solid will skip the message.
What's worse, I've been
From: Khamneian, Mahtaj [EMAIL PROTECTED]
To: Khamneian, Mahtaj [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 10:20
Subject: RE: Perl DBI-connect
Well, apparently my suspicion was not correct.
The following script fails with a segmentation fault on the second user.
YOUNG,ALEX (Non-HP-UnitedKingdom,ex2) wrote:
Hi all,
I am having a problem installing the above module (Version 0.32). I have
succeeded in the past with a statically linked version but cannot get the
dynamic one going.
The driver I'm using is Redbrick (a data warehouse now provided by
Mac,
Ok, I've got a problem with rollback(), I think. I'm not sure it's
a database problem or if it's my code, but here's the output from my
DBI script, and the code itself is attached (NOTE - I intentionally
used the wrong column in my delete statement to force an error):
AUTO_COMMIT is
Hi.
- Original Message -
From: ZHU Jia [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 6:32 PM
Subject: How to read/write BLOB in the Postgres DB from Perl DBI?
Hello,
I'm porting a DBI-Mysql application to Postgres, but I've big problems
with the BLOBs.
On Thu, Feb 07, 2002 at 04:31:08PM -0500, [EMAIL PROTECTED] wrote:
I probably shouldn't say ROLLING BACK TRANSACTION because the
Rollback Status = 1.
But I expect because AutoCommit = (I set it OFF) that the table I
created in the first SQL
statement would not exist. But it does!!
Looking at the Oracle 8 Server Concepts manual, a transaction is committed explicitly
by a commit statement or implicity when a DDL statement is issued. My understanding
is that a create table statement is a DDL statement. Thus an implied commit occurs
at that point in your code and you can
Thanks. (I'm used to using Sybase... I din't know that)
What about inserts? Aren't they also part of a transaction?
-Dave-
-Original Message-
From: dpf
Sent: Thursday, February 07, 2002 4:48 PM
To: Wren, David
Cc: dpf; dbi-users
Subject: RE: Re: Oracle DBI commit/rollback
INSERT, UPDATE, and DELETE are DML. Please at least browse the Oracle
concepts manual. Your Oracle DBA can tell you where to find it.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.htm
Give a
On Thu, Feb 07, 2002 at 04:41:31PM -0500, Ronald J Kimball wrote:
Selects, updates, and deletes are part of a transaction; they can be
commited and rolled back. Creates and alters are not; they happen
immediately and cannot be rolled back.
Selects? Oops. :D I didn't think that explanation
On Thu, Feb 07, 2002 at 07:12:12PM +0300, Andrew Ivanov wrote:
Dear Tim,
I receive the error Can't read $DBI::err, last handle unknown or destroyed
during global destruction many times (and for $DBI::errstr too).
I'm not able to say what is the reason of these errors. Setting the trace
Hi
I've seen this problem on a box I have that has a couple of different perl (and
module) installs on it. Either you have 2 versions of perl installed and you're
picking up part of DBI from the wrong one or (more likely) you have had an older
version of DBI installed at some time and the new
Hi,
I think the new table_info, column_info etc methods for DBI are
really useful, but I was wondering whether there are any plans for some
less verbose/more simplistic API's for retrieving 'data dictionary' type
information, eg I think it would be useful to have something like:
my
How do I install it in Window 2000 using PPM ?
- Original Message -
From: Tim Bunce [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, February 06, 2002 7:41 PM
Subject: ANNOUNCE: DBI 1.21
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.21.tar.gz
size: 208384
A ppm package is now available.
ppm install http://www.xmlproj.com/PPM/DBI-1_20.ppd
Ilya
Dear Dbi-users,
I am having trouble building the above DBD and I have NOT a clue what the
error messages are telling me. I built Perl 5.6.1 using gcc 3.0 and then
built DBI-1.20 successfully.
make test failed with the following errors:
Can't shl_load() a library containing Thread Local
- Original Message -
From: Bart Lateur [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 07, 2002 19:14
Subject: Re: Perl DBI-connect
On Thu, 7 Feb 2002 12:14:02 -0800, Michael A Chase wrote:
# You don't need to disconnect, each assignment to $dbh does that for
you.
27 matches
Mail list logo