DBD for DataDirect (Sequelink) ??

2002-11-06 Thread Michael . Hartmann
Does anybody have experience with perl and DataDirect (formerly known as Sequelink) on LINUX platforms ? At the moment i am using DBI and DBD::DB2 to connect to DB2 on a mainframe via DB2Connect Enterprise. But i have also Sequelink available. This could save the license for registered user for

RE: Script Running well as Root user but not as Apache user ?

2002-11-06 Thread Luis Garcia
If you have enviroment variables problem?. try to run .profile at the begining of your script (if you are using UNIX) or try to insert them at the beginin of your script. example in Perl: $ENV{ORACLE_HOME} = /ora/ora01/app/oracle/product; $ENV{ORA_NLS33} =

FW: :Oracle install snag on Compaq Tru64 (9i) [BREAKTHROUGH]

2002-11-06 Thread Rose, Bill
I tried putting this statement in my Perl code: $ENV{LD_LIBRARY_PATH} = /st0501/app/oracle/product/9.0.1/lib; It works fine. FYI. -Original Message- From: Rose, Bill Sent: Wednesday, November 06, 2002 10:04 AM To: '[EMAIL PROTECTED]' Subject: FW: :Oracle install snag on Compaq

Re: encoding

2002-11-06 Thread Guillaume Rousse
Le Mardi 5 Novembre 2002 17:51, Gaul, Ken a écrit : Set your NLS_LANG environement variable before execution of your script and it should work as expected. This doesn't seems to be the most portable construct among different systems/dbms... According to postgresql manual, the following is SQL

Re: encoding

2002-11-06 Thread dams
Guillaume Rousse [EMAIL PROTECTED] said: Le Mardi 5 Novembre 2002 17:51, Gaul, Ken a écrit : Set your NLS_LANG environement variable before execution of your script and it should work as expected. This doesn't seems to be the most portable construct among different systems/dbms...

Re: use DBD::Oracle qw(:ora_types); - from cron

2002-11-06 Thread shildreth
or set LD_LIBRARY_PATH in the cron. On 06-Nov-2002 Darin McBride wrote: On November 5, 2002 04:41 pm, you wrote: When I need to have a use DBD::Oracle qw(:ora_types); in my program, and I am running from cron, I get a message like: Can't load 'long path/auto/DBD/Oracle/Oracle.so' for

Connection to remote DB

2002-11-06 Thread Juan David Fernández Garrido
At this moment,I only have done connections to local DB. But, can I do connections from a host without a DB, installing into the client the correct DBD, to a host DB server? Does the S.O. must be the same into client and server? Thanks

Re: Connection to remote DB

2002-11-06 Thread Michael A Chase
On Wed, 6 Nov 2002 17:40:53 +0100 Juan David Fernández Garrido [EMAIL PROTECTED] wrote: At this moment,I only have done connections to local DB. But, can I do connections from a host without a DB, installing into the client the correct DBD, to a host DB server? Does the S.O. must be the same

Re: encoding

2002-11-06 Thread Guillaume Rousse
Le Mercredi 6 Novembre 2002 17:26, [EMAIL PROTECTED] a écrit : Guillaume Rousse [EMAIL PROTECTED] said: Le Mardi 5 Novembre 2002 17:51, Gaul, Ken a écrit : Set your NLS_LANG environement variable before execution of your script and it should work as expected. This doesn't seems to be

Re: use DBD::Oracle qw(:ora_types); - from cron

2002-11-06 Thread Darin McBride
On November 6, 2002 02:42 pm, Fox, Michael wrote: Thanks Darin, Actually, because I 'use strict', option 2 failed with compile errors like: Bareword ORA_RSET not allowed while strict subs in use at That's easy: { no strict 'subs'; eval 'use DBD::Oracle qw(:ora_types)'; die

DBD::Informix - With Informix SDK 2.80

2002-11-06 Thread Brett Dunstan
Hi, I was trying to get DBD-Informix-1.00.PC2 to work with the Informix Client SDK 2.80.UC2-1. I saw in the DBD Tech Note this version is not supported, and that the esql -V will return a value that cannot be parsed. However once past this I am getting the error at the end of this email, and

Re: Script Running well as Root user but not as Apache user ?

2002-11-06 Thread Armand Brisson
Thank you Luis I am setting in place an Apache Web server and I want to get access to a remote Oracle 8 database. Here are the step I did 1) I set up Linux RedHat 7.3 (Kernel 2.4.18-3 2) I updated OS through RHN (Kernel 2.4.18-17.7.x) 3) I installed Oracle Client 8.1.5 for Linux in

help: linux perl5.6.1+freetds0.53+DBI1.21 +DBD::Sybase0.95 instal lation errors

2002-11-06 Thread Frank Wu
Hi, I'm trying to upgrade DBD::Sybase from 0.91 to 0.95, and get the following errors, ubdefined cs_ctx_global . Can someone point me where the missing lib is, how to specify it in CONFIG? Many thanks Frank [roottest001 DBD-Sybase-0.95]# echo $SYBASE /usr/local/freetds-0.53 [roottest001

Re: DBD::Informix - With Informix SDK 2.80

2002-11-06 Thread Jonathan Leffler
Brett Dunstan wrote: I was trying to get DBD-Informix-1.00.PC2 to work with the Informix Client SDK 2.80.UC2-1. I saw in the DBD Tech Note this version is not supported, and that the esql -V will return a value that cannot be parsed. I'm working hard (too hard) on getting a version released.

Re: Script Running well as Root user but not as Apache user ?

2002-11-06 Thread Armand Brisson
Thank's to all of you It is working now. I change file permission to the /home/oracle directory to 755 and now everything work well Thank you again Armand Brisson Armand Brisson wrote: Thank you Luis I am setting in place an Apache Web server and I want to get access to a remote Oracle 8