Create a dummy table and try :)
José.
-Original Message-
From: Brian Avis [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 2:52 AM
To: dbi-users
Subject: Dropping tables
Can I do this via DBI connecting to a PostgreSQL database?
$dbh-do(DROP TABLE $tablename);
I
Hi,
Maybe there's someone here who can help answer this...
If so Thanks in Advance
-Chris
Begin forwarded message:
From: Chris Hinrichs [EMAIL PROTECTED]
Date: Thu Mar 6, 2003 10:44:29 AM America/Chicago
To: [EMAIL PROTECTED]
Subject: MyODBC, DBD::ODBC
Hi,
I'm looking for causes as to why
Bob, I just upgraded my version of DBI and DBD::ODBC to those available on
Ilya's repository and now DSN-less connections work again :-)
ppm2 --location=http://www.xmlproj.com/PPM/
PPM verify --upgrade DBI DBD-ODBC
--
Simon Oliver
The main problem is that you have built a .dylib which cannot be dynamically
loaded by unixODBC or iODBC with dlopen(). It should be a .so (you need the cc
bundle command to product .so files). Apparently there is a README for MySQL
and MAC OSX somewhere that will tell you how to do this.
In
On Thu, Mar 06, 2003 at 06:20:07PM +, Tim Bunce wrote:
: On Wed, Mar 05, 2003 at 08:13:00AM -0600, Philip Molter wrote:
: I have a very long running Perl process. I recently upgraded the
: DBI from 1.32 to 1.33 (and then 1.34) and now, the process is leaking
: memory. Given the complexity
Simon Oliver [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
snip
Easiest route is to set up a system DSN via the ODBC
administrator and
then just specify the DSN name in the connection string.
Alternatively, use a DSN-less connection string:
my $dsn =
How do I trap the db server messages that result from the sql
I pass to the database?
What database are you using?
Which perl module are you using?
For example, Oracle and DBD::Oracle had/has a way to get dbms_output data.
perldoc DBD::Oracle, looking for dbms_output should be a
What's this error?
The DBI package is not installed?
Software error:
[Thu Mar 6 15:01:54 2003] DBI.pm: Can't locate DBI.pm in @INC (@INC
contains: /usr/local/lib/perl5/5.00503/i386-freebsd
/usr/local/lib/perl5/5.00503 /usr/local/lib/site_perl
/usr/local/lib/site_perl .) at
hi,
How can i connect to an Oracle database with an oracle user where the
authentification were set to externaly.
is it possible ?
thanks
Christophe
I am using ActivePerl 5.8 and DBD::ODBC, ODBC is connecting
to Microsoft Access Driver.
At the end of my Perl program, I want to DROP all tables just
created for tempory use. However, it caused error. The error
message is about the table xxx is being used by other
applications
Messages like Rows returned, system altered, database altered.
Specifically all ~*ORA errors*~
How better to describe it? feedback from the database.
That's what I'm looking for.
Oracle DB 8.1.7.4
ActiveState Perl 5.6.1
not sure how to retreive DBI version...
-Original Message-
From:
On 06 Mar 2003 11:11:15 -0600, Rob Benton
[EMAIL PROTECTED] wrote:
INSTALLED:
apache 1.3.27
perl 5.6.1
redhat 7.3
For some reason perl is mangling the environment variables
set in the
httpd.conf file:
Hi
i am using Red Hat Linux 8 as a server for a project i am working on.
i have installed MySQL automatically with the install of the OS. and then i
installed Apache Server.
i would like to install DBI in order for me to be able to use a script that
i have in perl to insert data into MySQL
Hmmm...I did that. And now I get a different error:
Argument isn't numeric in repeat (x) at
/Library/Perl/darwin/DBD/Proxy.pm line 63.
DBD::Proxy::db STORE failed: Can't store CODE items at
blib/lib/Storable.pm (autosplit into blib/lib/auto/Storable/_freeze.al)
line 282, at
On Wed, Mar 05, 2003 at 08:13:00AM -0600, Philip Molter wrote:
I have a very long running Perl process. I recently upgraded the
DBI from 1.32 to 1.33 (and then 1.34) and now, the process is leaking
memory. Given the complexity of the project, it's not possible to
reduce it to a simple test
On Fri, Mar 07, 2003 at 09:24:51AM -0500, Cory Rau wrote:
Hmmm...I did that. And now I get a different error:
Argument isn't numeric in repeat (x) at /Library/Perl/darwin/DBD/Proxy.pm line
63.
Change the
5 x ' '
to
' ' x 5
on the line with the error. It's
Try to dynamically build a query and then bind based on the number of comma
seperated values:
example $_[2] contains 55,44
~~~
@sid = split /,/, $_[2];
$tempq=select s.sid,s.serial#, s.osuser, s.status, s.username, s.module,
s.action
from v\$process v, v\$session s
where
Hello,
I need some guidance on how to best handle the scenario on having several
remote servers (slaves)in other countries contact the main mysql server in
the U.S. The remote connections are moderately good, but sometimes the
connections break, so my $dbh isn't any good and of course the program
On Fri, Mar 07, 2003 at 12:13:37PM -0500, Markham, Richard wrote:
Try to dynamically build a query and then bind based on the number of comma
seperated values:
example $_[2] contains 55,44
~~~
@sid = split /,/, $_[2];
$tempq=select s.sid,s.serial#, s.osuser, s.status, s.username,
Messages like Rows returned, system altered, database
altered. Specifically all ~*ORA errors*~ How better to
describe it? feedback from the database.
That's what I'm looking for.
$sth-rows (after all rows have been received) gives you the rows.
$dbh-do() returns the number of rows
Hi,
I am sorry if this question was asked before. i tried searching through the
archieve but couldn't find the exact answer I was looking for.
I need to use the DBI module for Perl to connect to a MSSQL database. The
machine is a Unix AIX machine, and my company installed the Perl in it so it
I just installed DBI v1.34 and DBD-ODBC v1.04 on my AS build 633, and
have a question about a query that I tried to test the ODBC connection
to our SQL Server database:
my $sth = $dbh-prepare(SELECT a, b, c FROM table WHERE (c 'XYZZY')
ORDER BY a);
will return 109,000 rows in four seconds. All
- Forwarded message from gmei [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
From: gmei [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: RE: perl DBI question: fetchrow_array
Date: Fri, 7 Mar 2003 13:39:14 -0500
In-Reply-To: [EMAIL PROTECTED]
Hi, Tim:
Thanks for your reply. I have
Hi All,
First, thanks for taking the time to view this post.
The problem: Use Perl, DBI and DBD-Oracle to deal with Oracle collections.
My OS is WinNT with cygwin, Oracle 8.1.5, Perl 5.8.0, DBI 1.32, DBD-Oracle
1.12
Also, ActiveState Perl 5.6.1 DBI 1.30, DBD-Oracle 1.12
Two Perl installs - no
Is anyone working on (or is there a way to tell) the driver to pass ODBC
2.x state returns instead of 3.x (given the current DBD::ODBC driver is a
3.x 'app')? I have thousands of testcase that verify the $h-state() along
with other returns such as $h-err. Once I upgraded to newer DBI and
http://www.cpan.org/modules/INSTALL.html
On Fri, 2003-03-07 at 14:58, Poon, Kelvin (Infomart) wrote:
Hi,
I am sorry if this question was asked before. i tried searching through the
archieve but couldn't find the exact answer I was looking for.
I need to use the DBI module for Perl to
26 matches
Mail list logo
