>On Mon, Mar 31, 2003 at 02:01:30PM -0800, Michael Peppler wrote:
>> On Mon, 2003-03-31 at 11:36, Karyn Ulriksen wrote:
>> > This worked pretty well before. But, now, it appears that if the
result of
>> > the query is a null set, it pukes with a:
>> >
>> >Can't get DBI::st=HASH(0x811cfa8)->{N
This is a test release - available at http://www.peppler.org/downloads/
If you have the time (and if you use DBD::Sybase!) please download this
version and build it, and let me know of any problems.
I've not incorporated all the fixes/requests that I have in the
pipeline, but most of them are in.
>
> I'm running ActiveState perl 5.8.0 on a WIN2K box with MS SQL
> Server 2000.
>
> Recently I updated DBD-ODBC to v1.05 and DBI to v1.35
>
> Now I get the following errors executing some sql commands
>
> CREATE SQLSTMT:[CREATE DATABASE POMS_SER ON (NAME =
> 'POMS_SER_DAT', FILENAME =
> 'd:
>
>
> Strangely enough, splitting the request into 2, first is Use
> db and second is whatever else still seems to work. Not sure
If someone can send me a small example of this not working under the latest
DBD::ODBC, I'll be happy to look at it. Preferrably something generic that
can be run
Is it logging in the same way as the prior version?
Jeff
>
> hello everyone,
>
> i recently downloaded the latest version of perl which came
> with the following that i installed via the ppm.
> new:
> activestate perl 5.6.1
> ppm 2.20
> dbi 1.34
> dbd odbc 1.04
>
> old:
> activestate perl 5.6
Try the appended patch. Please let me know if it works.
Tim.
--- oci8.c 2003/03/27 16:44:15 1.38
+++ oci8.c 2003/03/31 23:28:46
@@ -1630,7 +1630,7 @@
"Unable to parse table name for LOB refetch");
OCIHandleAlloc_ok(imp_sth->envhp, &dschp, OCI_HTYPE_DESCRIBE,
On Mon, Mar 31, 2003 at 02:01:30PM -0800, Michael Peppler wrote:
> On Mon, 2003-03-31 at 11:36, Karyn Ulriksen wrote:
> > This worked pretty well before. But, now, it appears that if the result of
> > the query is a null set, it pukes with a:
> >
> >Can't get DBI::st=HASH(0x811cfa8)->{NAME}:
I've seen similar problems with the newer versions of the dbi and odbc
software on my WIN2K box running MS SQL Server. Have not seen any reported
workarounds or fixes yet.
E. Scott Stricker - NGIT @ Smartlink
- Original Message -
From: "Adam Peterson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTE
Michael,
Yes. It's FreeTDS.
In researching this issue, I ran across this in the archives:
http://aspn.activestate.com/ASPN/Mail/Message/perl-DBI/299919
I'm on Redhat and using fetchrow_hashref, but the issue is the same as
this 2000 issue.
I saw reference to the issue in t
hello everyone,
i recently downloaded the latest version of perl which came with the
following that i installed via the ppm.
new:
activestate perl 5.6.1
ppm 2.20
dbi 1.34
dbd odbc 1.04
old:
activestate perl 5.6.1
ppm 2.1.6
dbi 1.27
dbd odbc .28
the below code runs fine on my older version but ge
Are you trying to scroll through the data? If you are trying to scroll
through the data, inner joins are quite handy (if MySQL supports the
construct). I use a really ugly looking inner join to accomplish the
scrolling. This is formatted for MSSQL and Sybase, so adjust accordingly:
my($q) =
On Mon, 2003-03-31 at 11:36, Karyn Ulriksen wrote:
> Hi All,
>
>I recently upgraded one of my machines to DBD::Sybase 0.95. I am seeing
> a new behavior that is causing me problems and wondered if anyone could help
> me out.
>
>Also, I'm seeing that "$self->{DBH}->{LongReadLen} = 65536;"
Hello,
Here's an excerpt from the build output
$ perl Makefile.PL
[...]
8.0.6.0.1ORACLE Common RDBMS Libraries and Utilities
8.0.6.0.0ORACLE PL/SQL Libraries
8.0.6.0.1ORACLE Common Precomp Libraries
8.0.6.0.0PL/SQ
Ron Stephan wrote:
> The way I understand it, it will select all 100,000 and then try and
> display them all. Between the server and the browser something is bound
> to break or get stupefying slow. Am I wrong? Most of the time people
> are going to have filter criteria in the display - maybe
I got the following message (see also in attached) during "perl
Makefile.PL":
Argument "8.107.0.0" isn't numeric in ge at Makefile.PL line 669
The "make" seems ok.
(See attached file: DBD-Oracle-1.14_perl_Makefile-PL.txt)(See attached
file: DBD-Oracle-1.14_make.txt)(See attached file: perl-V.txt
On Mon, 31 Mar 2003 21:13:41 +0100
Tim Bunce <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote:
> >
> > I have discovered that it is the placement of single quotes around
> > the key value in the query:
> >
> > > my $rth = $dbh->prepare("SELECT * FR
On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote:
>
> I have discovered that it is the placement of single quotes around the
> key value in the query:
>
> > my $rth = $dbh->prepare("SELECT * FROM demographics_1 WHERE
> > KEY1=$key");
>
> that makes the difference. The abov
On Mon, 2003-03-31 at 11:35, Jesse Erlbaum wrote:
> Hi Michael --
>
> > Please send me (not the list!) a stack trace from the core dump.
>
>
> I think I may have fixed the problem. The solution was one or both of
> two things:
>
> 1. Recompiled Perl. Using the suggestion on your FAQ
> (http
Hi All,
I recently upgraded one of my machines to DBD::Sybase 0.95. I am seeing
a new behavior that is causing me problems and wondered if anyone could help
me out.
Also, I'm seeing that "$self->{DBH}->{LongReadLen} = 65536;" is being
complained about in the logfiles, so I've remarked the
Hi Michael --
> Please send me (not the list!) a stack trace from the core dump.
I think I may have fixed the problem. The solution was one or both of
two things:
1. Recompiled Perl. Using the suggestion on your FAQ
(http://www.mbay.net/~mpeppler/linux.html#q1.4), I compiled as follows:
On Mon, 31 Mar 2003, Michael A Chase wrote:
> > Anyway, you should probably be using placeholders.
>
> Or if placeholders are absolutely unavailable, $dbh->quote().
> Both are described in the fine DBI manual.
Just curious. Are there any drivers that don't support placeholders? If
so which on
On March 31, 2003 10:41 am, Ronald J Kimball wrote:
> On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote:
> > I have discovered that it is the placement of single quotes around the
> >
> > key value in the query:
> > > my $rth = $dbh->prepare("SELECT * FROM demographics_1 WHERE
> >
On Mon, 31 Mar 2003 12:41:48 -0500 Ronald J Kimball <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote:
>
> > I have discovered that it is the placement of single quotes around the
> > key value in the query:
> >
> > > my $rth = $dbh->prepare("SELECT
On Mon, 31 Mar 2003, MedanKia - Han Lin wrote:
> Hi guys,
Hi.
>
> I have a problem with DBD-Pg when try to talk to Postgresql. I always get
> this error :
>
> Undefined subroutine &Pg::connectdb called at test.pl line 4.
>
> Below is my code ?
>
> 1.#!/usr/bin/perl -w
> 2.
> 3.use Pg;
> 4.
On Mon, Mar 31, 2003 at 11:42:37AM -0600, Michael Muratet wrote:
> I have discovered that it is the placement of single quotes around the
> key value in the query:
>
> > my $rth = $dbh->prepare("SELECT * FROM demographics_1 WHERE
> > KEY1=$key");
>
> that makes the difference. The above
On Mon, 31 Mar 2003 17:05:28 +0100
Tim Bunce <[EMAIL PROTECTED]> wrote:
> On Mon, Mar 31, 2003 at 09:40:24AM -0600, Michael Muratet wrote:
> > On Mon, 31 Mar 2003 10:07:55 +0100
> > Tim Bunce <[EMAIL PROTECTED]> wrote:
> > > > The same query from the command line takes 0.02 seconds. A
> > > > fact
On Sun, 2003-03-30 at 07:53, Jesse Erlbaum wrote:
> > On Wed, 2003-03-19 at 06:19, Jesse Erlbaum wrote:
> > > Hi All --
> > >
> > > I'm having a problem trying to get a site which uses Sybase::Dblib
> > > working. Simply using the module will cause a segfault.
> > >
> > > $ perl -MSybase::DB
I would normally store the connection info in 3 separate variables.
For example, assuming you have a module that will return them:
my $dsn = $pkg->get_dsn($schema_id);
my ($user,$pass) = $pkg->get_connect_info($schema_id);
Otherwise just set them explicitly.
then:
my $dbh = DBI->connect($dsn, $
MedanKia - Han Lin [EMAIL PROTECTED] wrote:
> Hi guys,
>
> I have a problem with DBD-Pg when try to talk to Postgresql. I always get
> this error :
>
> Undefined subroutine &Pg::connectdb called at test.pl line 4.
If DBD::Pg is really what you have, then do
perldoc DBD::Pg
at a command promp
On Mon, Mar 31, 2003 at 09:40:24AM -0600, Michael Muratet wrote:
> On Mon, 31 Mar 2003 10:07:55 +0100
> Tim Bunce <[EMAIL PROTECTED]> wrote:
> > > The same query from the command line takes 0.02 seconds. A factor of
> > > 5,000 tells me I've made a stupid blunder somewhere, but I've read
> > > and
Hi guys,
I have a problem with DBD-Pg when try to talk to Postgresql. I always get
this error :
Undefined subroutine &Pg::connectdb called at test.pl line 4.
Below is my code ?
1.#!/usr/bin/perl -w
2.
3.use Pg;
4.$conn = Pg::connectdb("dbname=template1");
5.$res = $conn->exec("SELECT *
On Mon, 31 Mar 2003 10:07:55 +0100
Tim Bunce <[EMAIL PROTECTED]> wrote:
> > The same query from the command line takes 0.02 seconds. A factor of
> > 5,000 tells me I've made a stupid blunder somewhere, but I've read
> > and reread the documentation and it all looks OK to me.
> >
>
> During the 93
The first example passes 3 parameters to connect() while the second example
only passes one. Besides which, I wouldn't recommand storing user/pass into
such an array (which is what you would need). Better store the $dbh and
clone that as needed. No need for user/pass to float around that way.
Als
On Mon, Mar 31, 2003 at 09:44:37AM -0500, Jefferies, Brian wrote:
> Why does this example work...
>
> $dbh = DBI->connect("DBI:mysql:database=$database:host=$hostname",
> $user, $password)
>
> ...but this doesn't...
>
> $connect_string = qq("DBI:mysql:database=$database:host=$hostna
Why does this example work...
$dbh = DBI->connect("DBI:mysql:database=$database:host=$hostname",
$user, $password)
...but this doesn't...
$connect_string = qq("DBI:mysql:database=$database:host=$hostname",
$user, $password);
$dbh = DBI->connect($connect_string)
ERROR> Can't
[dbi-dev isn't the right place for this, so I've removed it from the CC list.]
On Fri, Mar 28, 2003 at 12:43:50PM -0600, Michael Muratet wrote:
> Greetings
>
> my $rth = $dbh->prepare("SELECT * FROM demographics_1 WHERE KEY1=$key");
> $rth->execute();
> while (my $ref2 = $rth->fetchro
Try changing this line in Makefile.PL
($inspdver{rdbms_ver} = $inspdver{RDBMS}) =~ s/^(\d+\.\d+)\.(\d+)/${1}0$2/;
to
($inspdver{rdbms_ver} = $inspdver{RDBMS}) =~ s/^(\d+\.\d+)\.(\d+).*/${1}0$2/;
Please let me know if that works okay.
Thanks.
Tim.
On Mon, Mar 31, 2003 at 12:37:40
You can ignore those errors.
Tim.
On Fri, Mar 28, 2003 at 03:57:39PM -0500, Steven Todesco/Cambridge/IBM wrote:
> iI,
> When installing the DBI 1.35 I had errors on the make test. I bolded the
> errors below.
>
> Thanks,
>
> STeve
>
>
>
>
> This is everything starting with the Makefile.P
38 matches
Mail list logo