DBI Make error
I am trying to install DBI module on AIX 5.3 for perl 5.8.2 64bit. During software build I am getting error. Does anyone has any idea? Thanks DBI.log Description: Binary data
Re: DBI Make error
On Thu, May 14, 2009 at 2:28 PM, Ritesh patel rpatel...@yahoo.com wrote: I am trying to install DBI module on AIX 5.3 for perl 5.8.2 64bit. During software build I am getting error. Does anyone has any idea? /bin/sh: cc_r: not found. You don't have a C compiler (or the correct C compiler) installed. -- Jonathan Leffler jonathan.leff...@gmail.com #include disclaimer.h Guardian of DBD::Informix - v2008.0513 - http://dbi.perl.org Blessed are we who can laugh at ourselves, for we shall never cease to be amused.
RE: unable to write from a select into outfile
All: I'm running on a windows XP box with latest MS updates, ActiveState perl (v5.10.0 built for MSWin32-x86-multi-thread) DBI (1.607) DBD-ODBC (1.21) SQL Server 2005 (SP3) Seems like all of a sudden queries against my database are not returning the correct data. First noticed when executing a query like Select a, b, c from vtbl where a like 'test%' And nothing was returned. I've got a record where a is 'test.' After playing with that for a while, for example trying select a,b,c from vtbl where a='test.', I tried select a,b,c from vtbl where a like 'a%' and got back 9 out of 8013 expected records. Most of the records that I did not get back have embedded periods or single quotes or dashes. Note that the same queries executed in the sql server enterprise manager and sqlcmd return the correct results. Also, I have not tried with earlier versions of dbd-odbc yet. Any light that can be shed on this would be greatly appreciated. E. Scott Stricker Senior Software Engineer Northrop Grumman - Information Systems - C2SD MailStop 4S02 2340 Dulles Corner Blvd. Herndon, VA 20171 703-561-3671 703-713-1601 (fax)
Re: unable to write from a select into outfile
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stricker, Scott E (IS) wrote:
All:
I'm running on a windows XP box with latest MS updates,
ActiveState perl (v5.10.0 built for MSWin32-x86-multi-thread)
DBI (1.607)
DBD-ODBC (1.21)
SQL Server 2005 (SP3)
Seems like all of a sudden queries against my database are not returning
the correct data. First noticed when executing a query like
Select a, b, c from vtbl where a like 'test%'
And nothing was returned. I've got a record where a is 'test.'
After playing with that for a while, for example trying select a,b,c
from vtbl where a='test.', I tried select a,b,c from vtbl where a like
'a%' and got back 9 out of 8013 expected records. Most of the records
that I did not get back have embedded periods or single quotes or
dashes.
Note that the same queries executed in the sql server enterprise manager
and sqlcmd return the correct results.
Also, I have not tried with earlier versions of dbd-odbc yet.
Any light that can be shed on this would be greatly appreciated.
E. Scott Stricker
Senior Software Engineer
Northrop Grumman - Information Systems - C2SD
MailStop 4S02
2340 Dulles Corner Blvd.
Herndon, VA 20171
703-561-3671
703-713-1601 (fax)
If you enable a DBI trace at level 15 and send it to me I'll take a
look. It would also be good if you can add the following to the start of
your test script as it enables extra logging that would be useful:
use DBD::ODBC;
DBI-trace(DBD::ODBC-parse_trace_flags('odbcconnection|odbcunicode'));
Perhaps you could explain what you mean by all of a sudden. Before
this happened what was happening correctly with what versions?
Martin
- --
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFKDaAchd1KVpsamNgRAgQLAJ98VUcsp6uFJpJ7RhTw5xe84XmbYwCfc4SG
XE1lPlcVEkTx+jwVNRKv5p8=
=qz+a
-END PGP SIGNATURE-
RE: unable to write from a select into outfile
Apologies for the email. I've got about a dozen web sites in my dev
environment. Changed IIS params for one and apparently hosed up all.
Fixed the params and all is well again. Found it by tracing and not
connecting to the database I thought I was connecting to. Enough
overlap in the DBs that I did not pick up on it right away.
E. Scott Stricker
Senior Software Engineer
Northrop Grumman - Information Systems - C2SD
MailStop 4S02
2340 Dulles Corner Blvd.
Herndon, VA 20171
703-561-3671
703-713-1601 (fax)
-Original Message-
From: Martin Evans [mailto:martin.ev...@easysoft.com]
Sent: Friday, May 15, 2009 1:02 PM
To: Stricker, Scott E (IS)
Cc: dbi-users@perl.org
Subject: Re: unable to write from a select into outfile
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stricker, Scott E (IS) wrote:
All:
I'm running on a windows XP box with latest MS updates,
ActiveState perl (v5.10.0 built for MSWin32-x86-multi-thread)
DBI (1.607)
DBD-ODBC (1.21)
SQL Server 2005 (SP3)
Seems like all of a sudden queries against my database are not
returning
the correct data. First noticed when executing a query like
Select a, b, c from vtbl where a like 'test%'
And nothing was returned. I've got a record where a is 'test.'
After playing with that for a while, for example trying select a,b,c
from vtbl where a='test.', I tried select a,b,c from vtbl where a like
'a%' and got back 9 out of 8013 expected records. Most of the records
that I did not get back have embedded periods or single quotes or
dashes.
Note that the same queries executed in the sql server enterprise
manager
and sqlcmd return the correct results.
Also, I have not tried with earlier versions of dbd-odbc yet.
Any light that can be shed on this would be greatly appreciated.
E. Scott Stricker
Senior Software Engineer
Northrop Grumman - Information Systems - C2SD
MailStop 4S02
2340 Dulles Corner Blvd.
Herndon, VA 20171
703-561-3671
703-713-1601 (fax)
If you enable a DBI trace at level 15 and send it to me I'll take a
look. It would also be good if you can add the following to the start of
your test script as it enables extra logging that would be useful:
use DBD::ODBC;
DBI-trace(DBD::ODBC-parse_trace_flags('odbcconnection|odbcunicode'));
Perhaps you could explain what you mean by all of a sudden. Before
this happened what was happening correctly with what versions?
Martin
- --
Martin J. Evans
Easysoft Limited
http://www.easysoft.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFKDaAchd1KVpsamNgRAgQLAJ98VUcsp6uFJpJ7RhTw5xe84XmbYwCfc4SG
XE1lPlcVEkTx+jwVNRKv5p8=
=qz+a
-END PGP SIGNATURE-
selecting a bigint
I'm trying to use DBI and DBD::mysql with perl-5.8.8 on a 64bit Redhat host: Linux host 2.6.9-67.0.20.ELsmp #1 SMP Wed Jun 18 12:35:02 EDT 2008 x86_64 x86_64 x86_64 GNU/Linux I need to do table lookups based on a column of type bigint. I don't generate or manipulate the bigint value myself - I actually read it in from the database. But when I turn around and try to select on the bigint value, it is not found. I scanned the web etc and have tried use bigint, quoting the value, forcing it to be string, etc. Testing shows that defining a large int as a string and inserting it into the database works fine (I pass $query to prepare() and $token to execute()): my $token = 18288286186892797895; $query = insert into table (uid, token) VALUES (9, ?); But I cannot figure out a way to turn around and select on that same token. For instance, these do nothing: $query = UPDATE table set uid = 8 where (uid = 9) and (token = ?); OR $query = SELECT * from table where (uid = 9) and (token = ?); If I try a smaller number for token, everything works as expected. Tod Sandman Sr. Systems Administrator Middleware Development Integration Rice University Voice: 713.348.5816
