RE: DBD-Oracle.1.12

2002-05-13 Thread Fox, Michael
Paul, I have: Perl 5.6.0 DBI 1.21 DBD-Oracle 1.12 Oracle 8.1.7 on both Compaq Tru64 Unix versions 4.0 and 5.1 They both work fine. I have noticed I get the same error as you if LD_LIBRARY_PATH is not set to $ORACLE_HOME/lib - don't know if this is your problem?? Michael Fox -Original Me

Proxy problem

2002-05-13 Thread Andrew Hamilton
All, I am at the end of my rope. I have searched the web and the archives and have seen no solution to this posted, but I have seen some similar posts out there. My proxy seems to be working just fine as long as I connect from the local host. It fails when I try to connect from anywhere els

INSERT/SELECT with ODBC/M$ Access

2002-05-13 Thread Snethen, Jeff
Hi. I'm new to the mailing list and fairly new to DBI. I looked for an answer from what I thought was the DBI home page (http://www.symbolstone.org/technology/perl/DBI/index.html), but I couldn't seem to access it. My problem is that I'm inserting data into a table in M$ Access with one $dbh/

Re: DBD::Informix on HPUX 11.00

2002-05-13 Thread Waldemar Żurowski
On Mon, 13 May 2002 13:22:15 -0700 [EMAIL PROTECTED] wrote: > Thanks for the tip. That patch was already installed, and after setting > LD_PRELOAD all tests passed. That's good. But keep in mind, that this LD_PRELOAD is somewhat buggy (as says HPUX own manpages) so set LD_PRELOAD only when need

Re: DBD::Informix on HPUX 11.00

2002-05-13 Thread aaron . brice
> You hit exactly the same problem as with DBD::Oracle. Basically this is > due to shortcomings of HPUX's shl_load function. > > Your options: > 1) install patch PHSS_24303 and use LD_PRELOAD environment variable. > 2) compile your own perl, linked with -lcl -lpthread (which is some sort > of rec

Re: DBD::Informix on HPUX 11.00

2002-05-13 Thread Waldemar Żurowski
[..] > I tried setting the environment variable DBD_INFORMIX_HPUX_USELIBCL so > that libcl would be linked, but then I get the following error messages > during make test: > > /usr/lib/dld.sl: Can't shl_load() a library containing Thread Local > Storage: /usr/lib/libcl.2 > /usr/lib/dld.sl: Exec f

[DBI-USERS] Multiple side-by-side DBD::Pg/PostgreSQL installs

2002-05-13 Thread Ed Loehr
We have a box running multiple versions of PostgreSQL (7.0, 7.1, 7.2, etc.), each with different client apps running against them using DBD::Pg. We want the 7.1 clients to use a DBD::Pg linked with 7.1 libraries, while 7.2 clients use a DBD::Pg linked with 7.2 PostgreSQL libraries. We've talk

DBD::Informix on HPUX 11.00

2002-05-13 Thread aaron . brice
Having trouble getting DBD::Informix to work on HP-UX 11.00. It make's ok, but make test fails for virtually every test with the following unresolved symbols: /usr/lib/dld.sl: Unresolved symbol: __ismt (data) from /usr/lib/libnsl_s.2 /usr/lib/dld.sl: Unresolved symbol: _ktepv (data) from /usr/

DBD-Oracle.1.12

2002-05-13 Thread Rogerson, Paul
<> Please help The make test phase of the installation fails for me under TRU64 UNIX. I've attached the output from the various steps. The platform shown is: Digital UNIX 4.0d Oracle 8.1.7 Perl 5.6 I have also tried to perform this same operation on Compaq TRU6

RE: Multiple SQL's in one statement

2002-05-13 Thread Ho, Tony
Hi Michael, Hi Paul Thanks for the email. I am using DBD::Sybase. Thanks very much Tony -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: 13 May 2002 16:33 To: Michael Peppler; Ho, Tony Cc: '[EMAIL PROTECTED]' Subject: Re: Multiple SQL's in one statement At 6:20 -070

Re: Multiple SQL's in one statement

2002-05-13 Thread Paul DuBois
At 6:20 -0700 5/13/02, Michael Peppler wrote: >On Mon, 2002-05-13 at 05:24, Ho, Tony wrote: >> Hi guys >> I was wondering if you could help me. >> I am currently using DBI against a Sybase Database. >> Is it possible to execute multiple SQL statements in a given statement >> handle ? > >Assum

Re: Could you help me, please?

2002-05-13 Thread aglef . stuewe
Hi, it seems that yoou don't have gcc installed. You need a C-Compiler to install the programs. schöne Grüsse / best regards / med venlig hilsen aglef -- A. Stüwe Mobile:+49 (0)163-5479406 Telephon: +49 (0)5132-885659 Kolding: +45 7633 6750

Re: Multiple SQL's in one statement

2002-05-13 Thread Michael Peppler
On Mon, 2002-05-13 at 05:24, Ho, Tony wrote: > Hi guys > I was wondering if you could help me. > I am currently using DBI against a Sybase Database. > Is it possible to execute multiple SQL statements in a given statement > handle ? Assuming you use DBD::Sybase - then the answer is "yes". For ex

Multiple SQL's in one statement

2002-05-13 Thread Ho, Tony
Hi guys I was wondering if you could help me. I am currently using DBI against a Sybase Database. Is it possible to execute multiple SQL statements in a given statement handle ? For example, I would like to multiple views in a database. I would be most grateful. Thanks in advance Tony

Could you help me, please?

2002-05-13 Thread Beatriz Molina
Instalar DBI-1.18 -- root DBI-1.18]make test gcc -c -fno-strict-aliasing -I/local/include -02 -march=i386 -mcpu=i686 -DVERSION="\1.18\" -DXS_VERSION="\1.18\" -fPIC -I/usr/lib/perl5/5.6.0/i386-linux/CORE -Wall - make: gcc

Re: DBI docs on binding NULL/undef values

2002-05-13 Thread Tim Bunce
On Mon, May 13, 2002 at 01:57:01AM -0700, Michael Peppler wrote: > On Sun, 2002-05-12 at 13:11, Tim Bunce wrote: > > [I've come back to look at this thread that I filed a while ago...] > > > > On Wed, Feb 13, 2002 at 01:04:15PM -0800, Michael Peppler wrote: > > > Hi, > > > > > > The DBI docs sta

Re: DBI docs on binding NULL/undef values

2002-05-13 Thread Michael Peppler
On Sun, 2002-05-12 at 13:11, Tim Bunce wrote: > [I've come back to look at this thread that I filed a while ago...] > > On Wed, Feb 13, 2002 at 01:04:15PM -0800, Michael Peppler wrote: > > Hi, > > > > The DBI docs state the following: > > However this syntax does NOT work with DBD::Sybase bec

Re: adding a field

2002-05-13 Thread Felix Geerinckx
on Mon, 13 May 2002 00:25:36 GMT, [EMAIL PROTECTED] (Todd Derenne) wrote: > I'm using dbi with Mysql and want to add a field to an existing > table while maintaining the data in the table. How is this done? To add a CHAR(20) field, you could use: $dbh->do( qq{ ALTER TABLE mytable