www.cpan.org
-Original Message-
From: Veeresh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 12:56 AM
To: [EMAIL PROTECTED]
Subject: DBD-1.08 DBD-Oralce-1.01
Hi,
I need DBD-1.08 and DBD-Oralce-1.01.
Can you please suggest me where i can get these.
Thanks in
Hi,
I used to use DBD:Oracle and it worked fine.
I'm using ActivePerl 5.6.1.
Now I switched to DBD:Sybase. I installed the Sybase module via
ActiveState
ppm.
So far ok.
When I tried to execute a perl script connecting to a sybase db I get
the following error:
install_driver(Sybase) failed_ Can't
That's the fourth time. Enough is enough. Stop posting this. Someone will
answer [maybe] in their own time.
Perhaps you may think that prodding a tiger with a stick is also a wise
thing to do?
--Neil
-Original Message-
From: Falk [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16,
Let's see an example of your code, your SQL and your data, but...
as I don't know if your using bind parameters or not - if not then you might
want to use the quote method, specifying a data type:
$sql = $dbh-quote($value, SQL_VARCHAR);
If you are binding then use something like this:
Have you installed any Sybase client libraries?
Download the DBD::Sybase module from CPAN and read all the documentation
that it comes with.
I see you are Win32 based so you must use either the Sybase client libraries
or Microsoft's SQL server libraries - TDS is the key here (that's the
Try a $update-bind_param_inout(..., { ora_type = ORA_RSET })
so oracle knows you're passing a cursor. Use trace to see more detail.
Tim.
On Wed, Aug 15, 2001 at 06:14:28PM -0700, Rob McMillin wrote:
Revisions:
Oracle 8.1.7.1.1 (8i release 3)
RedHat 6.2
Perl 5.6.0
DBD::Oracle 1.07
I'm
It seems new Perl path (d:\Indigoperl) has
not been set. Your script still trying to find DBI.pm
in G:\Perl
Elango
gopinath r wrote:
Hello
I have some doubts about connecting oracle 8.4
database from perl 5
I installed Indigoperl(perl 5) in widows NT system.The
directory G:/Indigoperl/site/lib
Nayeem,
The key may be how perl handles those single quotes (does not allow
variable interpolation within them).
HTH Dave
Nayeem [EMAIL PROTECTED] wrote in message
news:006f01c12345$21e92e50$[EMAIL PROTECTED]...
Can Anybody help me to insert the records in Sql Server. Actually this
Oracle 8.1.7.0.0
Solaris 5.8
DBI 1.18
DBD 1.07
We run a script that makes every second a connection to the oracle database,
read out a table and disconnects.
After a while (10 hours the last time) we've got these messages :
DBI-connect(TEST) failed: ORA-00604:error occured at recusive SQL
Hi folks, I'm having a dickens of a time with DBIx::Recordset and some LEFT
OUTER JOIN stuff. I have three tables (t1,t2,t3) and this is what the $set
looks like:
$set = DBIx::Recordset - SetupObject({
'!Table' ='t1, t2, t3',
'!TabJoin' ='t1 left outer
I'm using DBIx::Recordset 0.18-beta, and a MySQL database.
0.18 is 2 1/2 years old! Please upgrade first to the actual version (0.24).
Many things has changed and bugs have fixed since that time.
If your problem persist after the upgrade, let me know and we will see
what's going wrong
Gerald
I've a database in oracle, and I've created a stored procedure to do some
INSERTION transactions. How can I call that stored procedure in Perl so
that it will execute the insertion. Can some one give me a example of
code?
my $sth = $dbh-prepare(
BEGIN
stored_proc(?);
END;
);
I'm using DBIx::Recordset 0.18-beta, and a MySQL database.
0.18 is 2 1/2 years old! Please upgrade first to the actual version (0.24).
Many things has changed and bugs have fixed since that time.
Whoops! Just upgraded to 0.24 and the problem is still there. I can
however now use this
Whoops! Just upgraded to 0.24 and the problem is still there. I can
however now use this syntax without receiving the execute called with 1
bind variables when 0 are needed error message:
By examining $set-LastSQLStatement I can see that there is no 'where'
clause tacked on to the SQL
Greetings,
we do have one big trouble with the following (rare?) combination:
Solaris 2.8/Intel
Oracle 8.1.5 (delivered with Solaris as evaluation version)
DBD::Oracle 1.08
Perl 5.6.1 (no-threads)
The problem is that nothihg does work. Namely, we already gave up trying to
get server running
On Thu, 16 Aug 2001 10:11:50 +0200, Elango, Palchamy wrote:
It seems new Perl path (d:\Indigoperl) has not been set. Your script still
trying to find DBI.pm in G:\Perl
Yeah. Run the setup script disguised as a DOS .bat file.
--
Bart.
OK.
better $sth = ( INSERT INTO bearbeiter (funktionID, redakteurID) VALUES
('$funktionID', '$redakteurID') );
$dbh-do($sth) or die Copy mistake ($sth);
And that will break when presented with a $funktionID or $redakturID value
containing quotes, etc, so in general, you would be
That would work fine, just that escape for the single quote is not needed.
Ilya
-Original Message-
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: 8/16/01 4:51 AM
Subject: Re: Problems with INSERT
OK.
better $sth = ( INSERT INTO bearbeiter (funktionID, redakteurID)
VALUES
On Thu, Aug 16, 2001 at 03:41:06PM +0200, Oleg Mechtcheriakov wrote:
The point is that connection from perl script failes whereas the connection
with SQLPLUS works OK.
With what command line, exactly?
P.S. Forgot to say that to get to that point we had to recompile Perl and
DBI/DBD
Ilya -
No joy, no warnings. You'll see that the included test results look the same as the
previous ones I sent to you, even though I did make the changes you suggested below.
At the end of the typescript, you can see the diff of the modified general.t vs. the
original. Where now?
Sorry
I *am* the SysAdmin on this system. *BG*
We haven't done anything as far as modifying the warnings - this is a straight 4.3.3
install. The Perl version is 5.6.0. I understand that we CAN ignore this error, but
I'm a bit leery of doing that (knowingly ignoring an error). Any ideas as to how
Where can I download it?
What is the latest version?
Thanks,
Maria Elena
http://www.perl.com/CPAN-local/modules/by-module/DBI/
-Original Message-
From: Maria Vargas [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 10:21 AM
To: [EMAIL PROTECTED]
Subject: I need the DBI Module
Where can I download it?
What is the latest version?
Thanks,
Maria
In Oracle 8.1.7, Ora-04031 errors are often caused by fragmented shared pool
in the SGA (system global area) of the Oracle instance. There is a known bug
for this error which is introduced in Oracle 8.1.7 version and not present
in earlier releases. This bug is a memory leak problem and is
On Tue, 14 Aug 2001, Curt Russell Crandall wrote:
We've been noticing that often times DBD::Informix is not returning the
whole error message generated by the database. For example, I received
the following string in response to a char to numeric conversion error:
SQL:-1213:
Hmmm; -1213
What does this mean?!
Can't locate BDB/ODBC.pm in @INC (@INC contains: /perl/doc/lib
/usr/local/lib/perl5/5.00502/sun4-solaris /usr/local/lib/perl5/5.00502
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris /usr/local/lib/perl5/site_perl/5.005
.) at table.pl line 33.
Thanks,
Maria Elena
We don't set INFORMIXDIR in the scripts, the system is set up so all
accounts (including web, the account that owns all the web content and
scripts) have $INFORMIXDIR set to /usr/informix.
What is odd is that for the SAME script, it will display $DBI::errstr
correctly once, and then the next
Anyone,
I need to gain access to Oracle and Sybase on an AIX Unix system. I tried
perl makefile.pl; make; etc. to no avail. Please advise what steps do I
need to follow to get things to work on this platform.
(Note: I am able to do everything I need to via ActivePerl DBI, DBDSybase
and
Hello,
I'm a newbie here and have a question regarding the use of
DBI::ODBC with SQL Server. I've checked the mail archives
and seen others with the same problem but have yet to
come across the solution.
Here's what I'm doing: (note: actual user name and password have been
changed here).
use
Anyone has ever tried to connecto to a DBF set of files using Xbase when the
files are located on a network drive? I'm running a cgi to write a set of
records onto those files.
I've tried the following with no success:
$dbh1 = DBI-connect(DBI:XBase:f:) or die $DBI::errstr;
$dbh1 =
Carl,
The connection doesn't get its username and password attributes from the
DSN, so that wouldn't matter. It does, however get its other connection info
from the DSN.
If you have copied your code directly, then you have an error you wrote
$dbh = DBI-connect(dbi:ODBC:LocalServer, user,
Anyone ever seen this before?
When trying to open a database using mySQL, the specified username and
password work fine, and all access permissions seem to be in place. But
when trying to open *any* database on the server through DBI, I receive an
Access denied for user@host. I'm pretty much at
I don't think this is the problem. There aren't any filehandles that are
opened by the script unless something within DBD::Informix is opening
filehandles.
Since I'm the only one here today, I have the luxury of using the web
server on the test system without someone constantly restarting it.
Alzabo is a program and a module suite, with two core functions. Its first
use is as a data modelling tool. Through either a schema creation
interface or a perl program, you can create a set of schema, table,
column, etc. objects to represent your data model. Alzabo is also capable
of reverse
Forgot this in the last reply... it's the code I'm using to examine this
problem. Basically, it provides a text box for you to enter 1 SQL
statement. If executed successfully, it prints the results otherwise it
prints the error. Ignore the Javascript, it's not completed, but it's
meant to
On Thu, Aug 16, 2001 at 12:16:02PM -0500, Dana Kaempen wrote:
I *am* the SysAdmin on this system. *BG*
We haven't done anything as far as modifying the warnings - this is a straight 4.3.3
install. The Perl version is 5.6.0. I understand that we CAN ignore this error, but
I'm a bit leery
Thanks everyone. :)
-Brad B
-Original Message-
From: Dong Wang [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 16, 2001 2:41 PM
To: 'Bonn, Brad'; '[EMAIL PROTECTED]'
Subject: RE: Access permissions problem.
I think that is related to the set up in the user table in MySQL db.
It means exactly what it says. Can't find BDB::ODBC, it's DBD::ODBC. You
shouldn't be using it explicitelly, but rather through the DBI connect call.
See perldoc DBI. You script should only contain use DBI pragma.
Ilya
-Original Message-
From: Maria Vargas
To: [EMAIL PROTECTED]
Sent:
Just out of curiosity...
You found the mailing list and the subscription information, you even know
what DBI is, but you couldn't find where to download it
If you go to any search engine and type in DBI download, your first link
should point you to one of the mirrors.
Ilya
-Original
Hi All,
Would someone please advise me regarding the best/easiest way to select two columns'
worth of data and form a two-dimensional array? I need to do so in order to be able
to use some of the GD module's methods. I haven't been able to find answers in
documents/archives that I've
Just like you would construct any other two, three, four dimensional array.
You can either fetch through the data and then build an array, or use
fetchrow_arrayref, which will return an array reference.
Ilya
-Original Message-
From: Brian Warn
To: [EMAIL PROTECTED]
Sent: 8/16/01 1:14 PM
I am thinking you mean something like the following...
my @row;
my $sth = $dbh-prepare(SELECT name,phone FROM AddressBook ORDER BY name);
unless($sth-execute()) {
die Error: $DBI::errstr\n\n;
}
while(@row = $sth-fetchrow) {
print Name: .$row[0]. | Phone: .$row[1].\n;
}
Perhaps cross-posting is frowned upon, but I see lots of traffic on
dbi-users, so I am cross-posting.
Help is appreciated.
Dan
--
Dan Frankowski ph# 952-842-5476 mailto:[EMAIL PROTECTED]
-Original Message-
From: Frankowski, Dan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August
Actually I meant selectall_arrayref.
Ilya
-Original Message-
From: Sterin, Ilya
To: 'Brian Warn '; '[EMAIL PROTECTED] '
Sent: 8/16/01 1:17 PM
Subject: RE: constructing 2D array
Just like you would construct any other two, three, four dimensional
array.
You can either fetch through the
Actually there is a big discussion going on about adding this support, on
dbi-dev. Look in the archives for the past week to two weeks.
Ilya
-Original Message-
From: Frankowski, Dan
To: '[EMAIL PROTECTED]'
Sent: 8/16/01 1:09 PM
Subject: FW: DBI or DBD::ODBC for bulk insert?
Perhaps
On Thu, 16 Aug 2001, Curt Russell Crandall wrote:
We don't set INFORMIXDIR in the scripts, the system is set up so all
accounts (including web, the account that owns all the web content and
scripts) have $INFORMIXDIR set to /usr/informix.
But web servers explicitly reset the environment to the
I have to thank you for the detail of BDB instead of DBD that was the whole
problem to begin with.
To answer your curiosity I did get to download the DBI from search.cpan.org yesterday
but for some reason the files where corrupted when I tried to use them. So I wrote and
asked for a place to
Thanks for your reply.
How do I look in the archives?
I went to www.symbolstone.org and tried to access the U.S. archives. Looks
like it goes to http://outside.organic.com/mail-archives/dbi-users/, which
is down.
There is also some interface to query this list server by message number,
but I
Try this...
http://aspn.activestate.com/ASPN/Mail/Browse/Threaded/perl-DBI-dev
The subject is array binding
Ilya
-Original Message-
From: Frankowski, Dan
To: Sterin, Ilya
Cc: '[EMAIL PROTECTED]'
Sent: 8/16/01 1:21 PM
Subject: RE: DBI or DBD::ODBC for bulk insert?
Thanks for your
On Thu, 16 Aug 2001, Curt Russell Crandall wrote:
Forgot this in the last reply... it's the code I'm using to examine this
problem. Basically, it provides a text box for you to enter 1 SQL
statement. If executed successfully, it prints the results otherwise it
prints the error. Ignore the
My curiosity was actually due to you not wanting to share the personal
problem which would of been very informative in this case. Then the answer
would of been that there is either a problem with the way you are
downloading it, since we haven't heard of any other such problems, and the
Thanks for the information. I'm not authorized to rebuild DBD::Informix
on these systems nor do I know when or how DBD::Informix was built last
time. I'll forward your advice to the senior developer here.
It's still a little confusing as to how I'll get the correct errstr the
first time, but
Tim Bunce wrote:
Try a $update-bind_param_inout(..., { ora_type = ORA_RSET }) so
oracle knows you're passing a cursor. Use trace to see more detail.
Okay, specifics? While I got the select to work okay, I have yet to see
a working example of UPDATE ... WHERE CURRENT OF in Oracle using DBI.
On Thu, 16 Aug 2001, Curt Russell Crandall wrote:
Thanks for the information. I'm not authorized to rebuild
DBD::Informix on these systems nor do I know when or how DBD::Informix
was built last time. I'll forward your advice to the senior developer
here.
That will be problematic. You've got
I'm just trying to gather info... I'll let the senior developer worry
about reinstalls and stuff... less for me to worry about. So, I'm not
upset at all about not having authority to reinstall things. Actually,
there's nothing stopping me since I'm root... but I don't want to make the
boss mad.
Hello all,
I've recently begun moving my perl skills from a Win32 platform to now a
Linux platform. I plan to make a lot of database use of my previously built
SQL Server databases. I'm familiar with DBI, however I'm having a hell of a
time trying to understand the DBD::ODBC for Linux and the
I suggest getting the O'Reilly Programming the Perl DBI book. It has lots of
examples for different databases.
michelle
Hi.
- Original Message -
From: Poulson, Shawn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 17, 2001 6:13 AM
Subject: Connection to SQL Server from Linux
Hello all,
I've recently begun moving my perl skills from a Win32 platform to now a
Linux platform. I plan to
How about reading the POD documentation in ODBC.pm?
Jeff
Hello all,
I've recently begun moving my perl skills from a Win32 platform to now a
Linux platform. I plan to make a lot of database use of my previously
built
SQL Server databases. I'm familiar with DBI, however I'm
having
Are you explicitely coercing the insert by specifying the data type for
a place holder in the statement handle definition? Are you even using
place holders? Is your quoting in order?
Can you show the code snippets that give you the problem, and possibly
the 'describe table' output?
Peace.
- Original Message -
From: Jeff Urlwin [EMAIL PROTECTED]
To: Kawai,Takanori [EMAIL PROTECTED]; Poulson, Shawn
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Friday, August 17, 2001 6:30 AM
Subject: RE: Connection to SQL Server from Linux
How about reading the POD documentation in ODBC.pm?
On Thu, Aug 16, 2001 at 01:49:28PM -0700, Rob McMillin wrote:
Tim Bunce wrote:
Try a $update-bind_param_inout(..., { ora_type = ORA_RSET }) so
oracle knows you're passing a cursor. Use trace to see more detail.
Okay, specifics? While I got the select to work okay, I have yet to see
a
the following code appears to leak memory with
DBI-1.19, but not with DBI-1.18. i tried with
perl-5.6.1.
can anyone confirm this?
# ---
use DBI;
use Getopt::Std;
getopts('n:', my $opt = {}) or die usage: $0 [-n loops]\n;
my $loops = $opt-{n} || 1;
for (1 .. $loops) {
my $dbh = DBI-connect(
Hi,
I have oracle 8.1.7 DB/perl 5.6 . I need to read a blob content column
into perl ( using DBI/DBD). While reading i get an error stating
LOB value truncated from 2562677 to 80. DBI attribute LongReadLen too small
and/or LongTruncOK not set. How can i set these
values. ( I presume even
Buenos Dias:
Utilizando ORACLE 8.1.7 y PERL 5.003
Al utilizar sentencias en PERL : Set Transaction read only / Set
transaction use rollback segment , y no lo aplica en el programa
donde lo utilizo, Y por supuesto siempre termina con SNAP SHOT TOO OLD
Hugo Gonzalez.
- Original Message -
From: "venkat satya" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 16, 2001 4:11 PM
Subject: blob in DBI
Hi,
I have oracle 8.1.7 DB/perl 5.6 . I need to read a blob content
column
into perl ( using DBI/DBD). While reading i get an error
Hi
I'm on Win32 connecting to Access2000 using DBI. I have no problems when I
run this query in directly in Access. I have tested my connection with other
querys and it seems to work.
My problem is if I run the query from perl I get no response - the program
runs to completion with no errors
hi,
I'm using Apache::DBI in a site using modperl and mason. Most of
my database connections use Apache::DBI, and I wnat to keep them
that way. However, I'm finding special cases where I need to be
able to open a database connection only temporarily- the standard
DBI way- as opposed to using
Thanks for the response Neil.
It did in 97. I think this has changed in Access2000. I tried 'A%' via Perl
and directly both with no success.
Regards
CCJ
- Original Message -
From: Neil Lunn [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, August 17, 2001 3:25 PM
Subject: RE:
You must recompile DBD::Oracle with OCI8 libs, if not already done. You can
then set LongReadLen to any number you want.
To set LongReadLen and LongTruncOk see perldoc DBI.
The only time you need to set LongTruncOk is if you want your data truncated
past LongReadLen number, otherwise set
Turn on your error checking. RaiseError and possibly use trace() at level 2
if RaiseError does not provide enough insight. See perldoc DBI if you are
not familiar with the above.
Ilya
-Original Message-
From: Clinton [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 17, 2001 1:11 AM
71 matches
Mail list logo