> That's undetermined: Of course everyone assumes unless we hear
> otherwise that Edmund will continue the great work he's done on
> DBD::Pg.
No news?
> So here's a call for patches: if anyone else knows of patches to
> DBD::Pg 0.95 send them to me (along with some sort of explanation :)
> an
Hello all --
I'm sorry if this is off topic, but does anybody know of a way to find the most
common entry in a database using an SQL query? I'm using MySQL to cache search
engine terms and want to find the 5 most common terms
I can do it in perl pretty easily using a hash to store the count
Kalkunte Arun writes:
> Hello,
>
> I am trying to insert a binary object into a SQL Server table field of type
>IMAGE,
> using Perl and DBI. I have been unsuccessful so far, though I have tried all the
> solutions suggested in the various lists on the internet. Could anyone
Javier -
I have not had any luck on Solaris or Win2000 with DBI 1.15 and
DBD::Oracle. DBD::Oracle fails some of the same tests for me as you
described in your e-mail, even though DBI installs and tests fine. The only
solution for me was backing up to DBI 1.14. I don't have the patience to
rebu
Hello,
I am trying to insert a binary object into a SQL Server table field of type
IMAGE,
using Perl and DBI. I have been unsuccessful so far, though I have tried all
the
solutions suggested in the various lists on the internet. Could anyone who has
implemented s
On Fri, Apr 06, 2001 at 05:11:38PM -0400, Phil R Lawrence wrote:
> Since I posted the test scripts yesterday I also ran the trace at level three...
>There is no additional info that I can make out in
> the trace scripts because DBI never recieves the call to the disconnect method.
>Perl interc
On Fri, 6 Apr 2001, Michael A. Chase wrote:
> Setting LD_LIBRARY_PATH inside a Perl script works in some platforms and
> doesn't in others. I'm not sure which are which, so I try real hard to have
> all the environment variables set before the script starts.
It does not seem to work under x86 L
I can connect to SQL Server from Solaris using following perl script. This
uses DBD::Sybase with freetds.
I installed following components on solaris box
DBI-1.14
freetds-0.51
DBD-Sybase-0.91
Perl script
===
use DBI;
$ENV{SYBASE} = "/usr/local/freetds";
$ENV{LD_LIBRARY_PATH} = "/usr/l
This isn't the problem. I'm coming in through an Exceed session (XDMCP I
think). The .xsession is loaded from my homedir, but .profile is not. It
is loading some system .profile that I cannot override. I have no idea
how the sysadmin has this thing set up. We looked at it for a while when
I f
Make sure, if you're running .profile manually, that you run it as
". .profile". ("source .profile" in csh*)
If you execute a shellscript from the prompt, any environment variables it
sets, even if it exports them, will only be applicable to subshells
started "under" that script. If you source
Hi All,
I have a very similar problem to Bob Reuss where my script works ok on the
DOS command line but fails in the browser. My working environment is just
like his (using Perl/CGI on a windows2000 machine running IIS to connect to
an Oracle DB on a Sun WkStation) except that I use the Oracle Dr
On Fri, 6 Apr 2001, Aguztyn Garcia-Cruz wrote:
> I tryng to import data from ascii file
>
> intercun=# copy clientes from '/home/aguztyn/archivo/' using delimiters
> '|'
>
> but I see this error:
>
> ERROR: COPY command, running en backend with effective uid 26, could not
> open file
> '/home/ag
Since I posted the test scripts yesterday I also ran the trace at level three...
There is no additional info that I can make out in
the trace scripts because DBI never recieves the call to the disconnect method. Perl
intercepts the invocation and dies:
Uncaught exception from user code:
I tryng to import data from ascii file
intercun=# copy clientes from '/home/aguztyn/archivo/' using delimiters
'|'
but I see this error:
ERROR: COPY command, running en backend with effective uid 26, could not
open file
'/home/aguztyn/archivo' for reading. error = Permission Denied
What Im do
Well, perhaps since most of the accounts already have LD_LIBRARY_PATH set,
the ENV assignment is being overridden. I'm new to this set up
here... it's an odd setup since my .profile seems to have no effect on my
environment even if I execute .profile explicitly. I've just been setting
LD_LIBRARY
Curt Russell Crandall writes:
> That's interesting. The platform we use is Solaris w/ Sybase... so at
> least I know it works there... or at least appears to work there.
Actually it's very surprising - I've never seen that work on Solaris
before.
Michael
> On Fri, 6 Apr 2001, Michael A. Cha
Jamie Orzechowski writes:
> I just upgraded DBI to 1.15 and got the same error ... I have also tried
> this on a seperate box and gotten the same error ... are there any other DBD
> modules out there that can connect to MS SQL 7.0 databases??
Are you using the Sybase client or FreeTDS?
Michae
That's interesting. The platform we use is Solaris w/ Sybase... so at
least I know it works there... or at least appears to work there.
On Fri, 6 Apr 2001, Michael A. Chase wrote:
> Setting LD_LIBRARY_PATH inside a Perl script works in some platforms and
> doesn't in others. I'm not sure which
That would explain it. Thanks.
On Fri, 6 Apr 2001, Ronald J Kimball wrote:
> On Fri, Apr 06, 2001 at 03:03:30PM -0400, Curt Russell Crandall wrote:
> > It doesn't appear that this should happen, though, since $dbh is the
> > database handle ($dbh = DBI->connect()) and disconnect is called b
Have you tried running this through the debugger to see where exactly the
problem is occurring. Have you also tried running the stored proc in isql
(or what ever M$SQL calls it) to make sure the stored proc is OK?
The error message below indicates that your statement handle is still
active... yo
On Fri, Apr 06, 2001 at 03:17:39PM -0400, Jamie Orzechowski wrote:
> Whoops ... Yes I am calling $dbh->disconnect ... I sent the script when I
> was trying out some things ...
>
Okay, that should fix the error message for the disconnect method. I'm
afraid I can't help with the problem of callin
Whoops ... Yes I am calling $dbh->disconnect ... I sent the script when I
was trying out some things ...
- Original Message -
From: "Ronald J Kimball" <[EMAIL PROTECTED]>
To: "Jamie Orzechowski" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 3:13 PM
Subject: Re:
Setting LD_LIBRARY_PATH inside a Perl script works in some platforms and
doesn't in others. I'm not sure which are which, so I try real hard to have
all the environment variables set before the script starts.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Gi
On Fri, Apr 06, 2001 at 02:59:02PM -0400, Jamie Orzechowski wrote:
> can you give me a quick snippet of code to disconnect on the database
> object?
>
Instead of calling $sth->disconnect, you should call $dbh->disconnect.
(Assuming you've used those variable names. :)
Ronald
On Fri, Apr 06, 2001 at 03:03:30PM -0400, Curt Russell Crandall wrote:
> It doesn't appear that this should happen, though, since $dbh is the
> database handle ($dbh = DBI->connect()) and disconnect is called by
> $dbh->disconnect. From the code given, the DBI::st should not be
> complaining
I just upgraded DBI to 1.15 and got the same error ... I have also tried
this on a seperate box and gotten the same error ... are there any other DBD
modules out there that can connect to MS SQL 7.0 databases??
- Original Message -
From: "Curt Russell Crandall" <[EMAIL PROTECTED]>
To: "R
It doesn't appear that this should happen, though, since $dbh is the
database handle ($dbh = DBI->connect()) and disconnect is called by
$dbh->disconnect. From the code given, the DBI::st should not be
complaining about this. This is an error similar to what I received a
while ago using Syba
same error
Name "main::charge" used only once: possible typo at ./test line 11.
DBI::db=HASH(0x81ce7d8) trace level set to 9 in DBI 1.15-nothread
-> disconnect for DBD::Sybase::db (DBI::db=HASH(0x81ce82c)~0x81ce7d8)
DBI::db=HASH(0x81ce7d8)->disconnect invalidates 1 active statement handle
(either
can you give me a quick snippet of code to disconnect on the database
object?
- Original Message -
From: "Ronald J Kimball" <[EMAIL PROTECTED]>
To: "Curt Russell Crandall" <[EMAIL PROTECTED]>
Cc: "Jamie Orzechowski" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, April 06, 2001 2:
I don't know if this will help, but try changing
$dbh->disconnect || print "$DBI::errstr $DBI::err\n";
to
$dbh->disconnect() or die("$DBI::errstr $DBI::err\n");
I'm probably wrong, but if something is wrong with disconnect, but not
'die'ing, you might be causing it to hang on the print. Since
On Fri, Apr 06, 2001 at 02:26:31PM -0400, Curt Russell Crandall wrote:
> If Perl DBI is saying it can't find disconnect, then I would think either
Perl is saying that it can't find the disconnect method in the DBI::st
package. That's the statement handle package. The disconnect method
is in the
On Fri, Apr 06, 2001 at 02:13:17PM -0400, Jamie Orzechowski wrote:
> I tried sthX->finish and I get the same hangs ...
>
> I am split the script into seperate scripts and I run each part manually ...
>
> Even with the following script I get a hang ... if I insert sth->finish;
> then the script w
Looks like it's parts of the script that execute stored procedures ...
This works fine
$dbh = DBI->connect("dbi:Sybase:database=xxx", "",
"x");
$sql = <<_ENDSQL;
SELECT Customers.CustomerID, Plans.PlanID, Emails.PopName,
Emails.EmailAddress, Emails.Password
FROM Plan
Hello all,
I have been attempting to use DBI::ODBC on a windows 2000 machine running
IIS to connect to an Oracle database on a Unix machine. I have set up the
DSN for the ODBC connection and I can actually get a connection to the
database and retrieve data when I call cgi page from a command lin
If Perl DBI is saying it can't find disconnect, then I would think either
$dbh somehow gets undef'd or maybe your disconnect method is
missing. I've run into this before where my disconnect method was
"missing". It may be you just need to reinstall DBI, which is what my
sysadmin did. Why discon
I tried sthX->finish and I get the same hangs ...
I am split the script into seperate scripts and I run each part manually ...
Even with the following script I get a hang ... if I insert sth->finish;
then the script will hang ... If I remove it then script will run but I get
the error
DBI::db=H
Yes I did the COMMIT in SQLPLUS. Odd.. ! Anyhow, inexpliquably when I came
in this morning the code worked fivers. No problems at all..
Go figure! This "Oracle" is more like a game of chance then a predictable
engine.
Thanks for the tips!
-PG
>From: Ronald J Kimball <[EMAIL PROTECTED]>
>T
try $sthX->finish after execute when you do not need the $sthX anymore.
-Original Message-
From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]]
Sent: 6. april 2001 19:25
To: Jamie Orzechowski
Cc: DBI-Users
Subject: Re: Script Hangs when executing ...
Still just hangs after the last destory
Still just hangs after the last destory? (Also, keep the dbi-users
mail list in the replies, the Sybase gurus are there.)
Tom
On Fri, Apr 06, 2001 at 01:03:52PM -0400, Jamie Orzechowski wrote:
> with tace 9 I get
>
> DBI::db=HASH(0x80efd9c) trace level set to 9 in DBI 1.14-nothread
> -> discon
What does trace say? ($dbh->trace(1-9) just before the disconnect).
Tom
On Fri, Apr 06, 2001 at 12:25:51PM -0400, Jamie Orzechowski wrote:
> Hello ... I have a script which connected to a MS SQL database ... it hangs
> right at the end of the script ... if I check my database it DOES insert all
Hello ... I have a script which connected to a MS SQL database ... it hangs
right at the end of the script ... if I check my database it DOES insert all
the information correctly ... it just hangs and never exits ... any ideas??
here is the script ...
!/usr/bin/sybaseperl
$ENV{'SYBASE'}="/opt/s
Yes, you can set LD_LIBRARY_PATH within the script and it should pick
up the correct path. It is standard with
all of the DBI scripts accessing Sybase in our shop... normally the path
is in an ini file, the ini file is read and the ENV variable set. We do
this since the same account may be exec
Yeah, I finally figured that out a little while ago.I always thought
DESCRIBE was part of SQL. Go figure. Doesn't matter though.I had
DBI debugging turned on, and poring through the output helped me realize that
a prepare statement pulls in everything I'm looking for. All I had to d
> > fukushi wrote:
> > > #! /good_directory_for_perl/perl -w
> > > $ENV{SYBASE} = "/good_direcroty_for_freetds/freetds";
> > > $ENV{LD_LIBRARY_PATH} = $ENV{SYBASE}."/lib";
> >
> > I believe, that you can't set the LD_LIBRARY_PATH variable this way
> > (just from within of you Perl-script and wi
It is exactly what the error message says. DESCRIBE is not a valid SQL
statement, it is a SQL*Plus command.
--
Mac :})
** I normally forward private database questions to the DBI mail lists. **
Give a hobbit a fish and he'll eat fish for a day.
Give a hobbit a ring and he'll eat fish for an age.
Hi. this is fukushi struggling with FreeTDS/DBD-Sybase.
From: "Alexander Farber \(EED\)" <[EMAIL PROTECTED]>
Subject: Re: DBD::Sybase with freetds -- no statement executing???
Date: Fri, 06 Apr 2001 15:43:27 +0200
Message-ID: <[EMAIL PROTECTED]>
> fukushi wrote:
> > #! /good_directory_for_perl/p
When reporting problems with using the FreeTDS client libraries you
should in general start with asking your questions on the FreeTDS
mailing list.
See http://www.freetds.org for details.
Michael
fukushi writes:
> Hi again.
>
> From: fukushi <[EMAIL PROTECTED]>
> Subject: DBD-Sybase make
I recently upgraded Oracle from 8.0.4 -> 8.1.6 and OAS from 3.0.2 -> 4.0.8.2
(configuration: Solaris 2.6, Perl 5.004_03, DBI 1.13 and DBD 1.03).
I then tried to re-install DBD 1.03 (in order to link it with the 8.1.6
libraries) and I got the famous message:
"You must install a Solaris patch to r
Never mind on the variable substitution question. I found my problem.
I wasn't using the q and qq functions properly to make sure the variable
was set up correctly. I am still curious about the DESCRIBE call,
though.
Thanks!
Dave Tamillow
Original Message
Subject: Passing
fukushi wrote:
> #! /good_directory_for_perl/perl -w
> # fttest -- access MS-SQL7 using freetds
>
> use strict;
> use DBI;
>
> $ENV{SYBASE} = "/good_direcroty_for_freetds/freetds";
> $ENV{LD_LIBRARY_PATH} = $ENV{SYBASE}."/lib";
I believe, that you can't set the LD_LIBRARY_PATH variable this w
It would seem that after I recompiled perl as 64 bit instead of 32, the
problems I was having with binding of NULLs in DBD::Oracle disappeared.
David Nicklay
Systems Engineer II
[EMAIL PROTECTED]
CNN - SW1025J
On Fri, Apr 06, 2001 at 08:12:55AM -0400, Dave Tamillow wrote:
> Hi,
>
> I'm new to the list and to the DBI in general. I have "Programming the
> PERL DBI" -- I'm about 1/2 way through it. I've read the documentation
> that comes with the DBD::Oracle source, but in both I've yet to find an
> a
On Thu, Apr 05, 2001 at 10:53:40PM +, sara starre wrote:
> We use the DBI for all sorts of MYSQL and Oracle queries, but today
> something happened I never saw before. I do a prepare of a legitimate UPDATE
> query (I tested it on thew SQLPLUS> prompt and it ran fine). But when I call
> it f
Hi ,
A simple query.
If Oracle is very much required for DBD installtion on a HPUX box, is it possible to
run old oraperl scripts to access
a remote oracle database (on a different machine) using DBD::Oracle and local Oracle
libraries ?
If yes , then what are the Oracle components are necessar
Hi,
I'm new to the list and to the DBI in general. I have "Programming the
PERL DBI" -- I'm about 1/2 way through it. I've read the documentation
that comes with the DBD::Oracle source, but in both I've yet to find an
answer to something. In experimenting with the DBI, I can pass a
literal s
*
Those who do not understand Unix are condemned to reinvent it, poorly.
-- Henry Spencer
Unix is user-friendly (it only choose its friends carefully)
It
Hi, someone please help me.
I've just installed freetds, DBI, and DBD::Sybase and this is the
first program.
---
#! /good_directory_for_perl/perl -w
# fttest -- access MS-SQL7 using freetds
use strict;
use DBI;
$ENV{SYBASE} = "/good_direcroty_for_freetds/freetds";
$ENV{LD_LIBRARY_PATH}
57 matches
Mail list logo