Greetings.
I have posted to the PostgreSQL and DBI mailing lists regarding a
possible bug in DBD::Pg v0.95 and insertion of large amounts of text
into a field of type "text" in 7.1 pre-release versions of
PostgreSQL, but have received no response. Might anyone have a clue
as to where I can look
Hi,
The forthcoming PostgreSQL 7.1 will eliminate the previous 8KB limit
on attribute size. Unfortunately, DBD-Pg 0.95 seems not to cope: when
storing large values via DBD-Pg perl dumps core.
I've seen the problem with perl 5.005_03 and perl 5.6.0, running on:
1. NetBSD-1.5/i386
2.
Using...
$dbh = DBI-connect('dbi:Oracle:TEST1', 'test1', 'test1' , {Printerror = 0,
RaiseError = 1} );
I get Oracle error ORA-12154 TNS: could not resolve service name (DBD Error:
OCIServerAttach)
Yet I don't really want to use TNS (I think) - I want to do an old fashioned
connect to SID TEST1
If "host=localhost;sid=TEST1" in place of "TEST1" works, you have an error
in tnsnames.ora.
How to fix it depends on your platform. Most Win32 Oracle installs have a
Easy*Net icon that starts a program that will build TNS entries for you. On
most other platforms, you will have to add the entry
Hi Tim...
I don't know if these are important:
DBI.xs: In function `set_trace_file':
DBI.xs:457: warning: passing arg 1 of `setlinebuf' from incompatible pointer
type
DBI.xs: In function `XS_DBI__var_FETCH':
DBI.xs:2305: warning: passing arg 1 of `fprintf' from incompatible pointer
type
and
Here's a patch (with thanks to H.Merijn Brand).
Tim.
diff -c -r10.30 DBI.xs
*** 10.30 2001/03/30 14:35:41
--- DBI.xs 2001/04/02 12:26:57
***
*** 30,36
--- 30,38
#ifdef HAS_SETLINEBUF
#define PerlIO_setlinebuf(f)setlinebuf(f)
#else
+ #ifndef
Hi Perlsters dbi-users,
Accidentally took out the admin privs , cant get back into mysql permission
tables.
Tried to use "mysql_fix_privilege_tables" script to fix it.
Reported "Access denied" . Tried to re-install the package . Cobalt server
has
binary that install easily but when it
Hi,
I just upgraded from DBI 1.14 to 1.15. After the install completed, I
ran a check on what else needed to be upgraded, the CPAN module reports
that DBD::ADO module needs to be upgraded from the current 0.419 to
version 1.17 as found in DBI 1.14.
Why did the version regress? Let's take a
Ah, well spotted! Many thanks.
Tim.
On Mon, Apr 02, 2001 at 12:38:25PM -0400, T.J. Mather wrote:
I think I might have found a bug with the new selectrow_hashref feature of
DBI under mod_perl using Apache::DBI. When I attempt to use
selectrow_hashref, I get the following error:
Can't
I think you can start safe_mysqld with a switch called
"--skip-grant-tables" or something like that - once mysqld is
started with that, you should be able to log in as root with
NO password - get your stuff straightened out, then stop and
start safe_mysqld without "--skip-grant-tables".
The
If "host=localhost;sid=TEST1" in place of "TEST1" works, you have an error
in tnsnames.ora.
How to fix it depends on your platform. Most Win32 Oracle installs have a
Easy*Net icon that starts a program that will build TNS entries for you. On
most other platforms, you will have to add the entry
Dear Perl DB gurus
I have an Access database that I would like to be able to update/query from Unix.
What is the best way to do this? Can I use ODBC on UNIX?
Thanks for any and all suggestions.
Thanks
Phillip
--
Phillip Millman
Associate Director
UBS Warburg
1285 Avenue of the Americas
can't Install dbd for postgreSQL
someboy can help, Me
Greetings.
The following patch was submitted by Tom Lane of the PostgreSQL core
team, and has been tested (on an Athlon 800, Linux 2.4.2, Perl 5.6.0,
DBI 1.15) and is verified to fix the segfault issue.
*** DBD-Pg-0.95/dbdimp.h~ Mon Jul 10 13:47:51 2000
--- DBD-Pg-0.95/dbdimp.h
It was certainly a problem with the permissions.
The IUSR_ was set for the local machine and was not a user on the
Domain. Therefore, from what I gather, it's request for authentication
to Oracle was not even given permission to occur, so no username or
password was ever able to send.
Now, I
On 2 Apr 2001, at 17:33, Millman, Phillip wrote:
I have an Access database that I would like to be able to update/query
from Unix. What is the best way to do this? Can I use ODBC on UNIX?
:) ... oh geee ... I once had to do something like this for an MS
SQL server. I managed to connect
Any chance we can aggregate the last few patches submitted for DBD::Pg and
get a new release out? Anyone know Edmund's status as maintainer?
Thanks - and good job, Jeff, Bruce, and Tom!
David
On 2 Apr 2001, Jeff Duffy wrote:
Greetings.
I have posted to the PostgreSQL and DBI mailing
If I have a database handle, is it possible to get back the username,
password, attributes and data source? That is... I have a database
handle and I wish to reconnect using just information from it.
This is so Class::DBI can take an existing database handle rather than
the connection
Hello,
I installed Perl DBI and Oracle DBD locally under my own unix directory. I
wrote a test a script to retrieve data from an Oracle database. The script
worked perfectly under command line and I got the right data from the
database. However, when I tried to execute the script from a web
I am having problems trying to do file access
Here is my code:
$statement = "ALTER DATABASE BACKUP CONTROLFILE TO TRACE";
$updated=$dbh-do($statement);
if ($updated){
print "Control File Backed up to Tracebr";
I've only been using DBI for about a week, so forgive the newbie questions.
I'm using cgi-lib and a sql database.
I have a few functions right now to handle my database stuff..(insert,
select, update).
At the beginning of each of these functions, I'm connecting to the DB and at
the end i
On Mon, 2 Apr 2001 17:54:00 -0700 (PDT), David Wheeler alluded:
Any chance we can aggregate the last few patches submitted for DBD::Pg and
get a new release out? Anyone know Edmund's status as maintainer?
That's undetermined: Of course everyone assumes unless we hear
otherwise that Edmund
I got similar results combining DBI 1.15 with DBD::Oracle 1.06 under WinNT
4.0 SP4, Oracle 8.1.5.0.0, and Perl 5.6.0.
Please run this script and send the results to the list:
#!perl -w
use DBI;
use DBD::Oracle qw(ORA_RSET);
use strict;
$| = 1;
my $dbuser = $ENV{ORACLE_USERID} ||
* Jim Mahoney ([EMAIL PROTECTED]) [010402 22:03]:
I recently spent more time than I'd like to admit
trying to understand a bug in my DBI program, and
now that I understand what's going on, I'm writing
to suggest that the documentation show better how the type
conversion from perl scalars
Are you seeting the ORACLE_HOME environmental variable as thus?:
BEGIN {
$ENV{ORACLE_HOME} = '/path/to/oracle/product/';
}
--
anthony bouvier
notsoevil philosopher
--
-Original Message-
From: Charley Wu [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 5:04 PM
To:
How about some code. Do you have the DBD::pg installed? Send in you code
so we can help.
Ilya Sterin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 4:45 PM
To: [EMAIL PROTECTED]
Subject: HELP, HELP, HELP
can't Install dbd for
Mostly on Windows I always connect using ODBC. Depending on what you are
doing the performace might or might not matter. Always an extra layer
provides some performance lack, but the millisecond might not even compare
to optimizing you network. Usually it doesn't matter, but then again not
The browser connects with a user nobody or www or other, since when you
installed Oracle the ORACLE_HOME was not set for this user, you can either
set it in the environment or explicitely in you script. A sample script
would also help.
Ilya Sterin
-Original Message-
From: Charley Wu
Look at mod-perl for consistant connections. You must be using apache
though.
The way you would reprepare is by having a query that might run mulitple
times but with different parameters. Here is an example...
$sth = $dbh-prepare("select col1, col2, col3 from foo where col1 = ? and
col2 = ?");
the project fell through I never pursued it. Anyhow I did
this through
freetds (and I remember reading a lot about sybase at the time for
some reason):
TDS has nothing to do with MS Access.
__
Please Note :
Only
Hello All,
I have a similar issue with some Perl scripts that are invoked by QMail -
the scripts process email on a command-response type system, interacting
with an Oracle database.
Or at least - that's the idea :) Qmail sets its own Enviroment variables to
scripts it calls (i'm using a pipe
All,
Looking through some examples in the v3 Camel book of the Embed module
and I have a few questions:
1. Can I embed the DBI module into a C++ app? I'd love to have the DBI
flexibility.
2. If so, any tricks I need to know about? Any other sources of info I
should look at? I've gone some
32 matches
Mail list logo
