Perl/Gui DB software

Hi All I'm currently writing a db application based on Oracle with Perl batch processing, and am intending to implement a GUI front end. Perl/Tk looks like a possible option. I'm reasonably new to Perl but feel confident enough in it to create a functional app, even if the code is not written in

Re: DBI XML:putting it all together

Vittorio [debian-user] 01/10/01 09:42 +: I'm using perl and the DBI stuff to deal with Oracle databases on a LAN. Now, I need to extract data from XML docs and put them in the databases. I've read the book Learning XML by Erik T.Ray where XSLT, XPATH and XPOINTER are discussed and

Re: Perl/Gui DB software

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, Oct 01, 2001 at 07:31:35PM +1200, Dan Horne wrote: I'm currently writing a db application based on Oracle with Perl batch processing, and am intending to implement a GUI front end. Perl/Tk looks like a possible option. I'm reasonably new

Re: DBI XML:putting it all together

On 1 Oct 2001, at 9:42, Vittorio wrote: I'm using perl and the DBI stuff to deal with Oracle databases on a LAN. Now, I need to extract data from XML docs and put them in the databases. I've read the book Learning XML by Erik T.Ray where XSLT, XPATH and XPOINTER are discussed and

Re: Accented contents

The accents are fine when outputted in the ms-dos window from mySQL only. They are not whowing up when using them on Internet Explorer or Netscape using a perl script and DBI. Etienne - Original Message - From: Sterin, Ilya [EMAIL PROTECTED] To: Mr_SpAcE [EMAIL PROTECTED]; [EMAIL

Re: Installing DBD-ODBC

Abhra, Hello I am facing problem while installing DBD-ODBC. I have downloaded DBD-ODBC and trying to install the module in WIN NT Machine. I have used following command perl Makefile.pl nmake nmake test But it is not recognizing nmake command and throw following error

RE: Installing DBD-ODBC

On Monday 1st October, Abhra wrote: I am facing problem while installing DBD-ODBC. [snip] But it is not recognizing nmake command and throw following error : Why can't you use the ppm? [from the command line] ppm install DBD It's a lot easier then having to download nmake from

Re: Installing DBD-ODBC

1. Do I need VC ++ compiler installed for installing DBD-ODBC by above mention method ? Yes - for this particular module - some others only require the nmake utility (see the PPM docs for how to get it) 2. Can I install DBD-ODBC by PPM ? Yes. See the PPM docs, but ... ppm install DBI

Re: Prepare/Exec statement reuse

Although the perldocs(perldoc DBI) indicate that a finish is rarely required: (snippet) When all the data has been fetched from a SELECT statement, the driver should automatically call finish for you. So you should not normally need to call it

RE: DBI XML:putting it all together

This will better be addressed by the activestate's perl xml email list. I'll reply to you in private with a few pointers. Ilya -Original Message- From: Vittorio De Martino [mailto:[EMAIL PROTECTED]]On Behalf Of Vittorio Sent: Monday, October 01, 2001 5:43 AM To: dbi-users;

RE: DBI XML:putting it all together

That's nice, but XML::Simple has little to do with DBI, so please don't post OT responses. Ilya -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 5:26 AM To: [EMAIL PROTECTED] Subject: Re: DBI XML:putting it all together On 1

Re: Exporting Tables using DBD::DB2

Hi Mike, The reason you're getting the error is because 'export' is not a SQL statement. It is actually a DB2 command and thus, you can treat it as: $rc = system( db2 export ); The userid running this perl script must have already sourced the ~/sqllib/db2profile file (initializes the DB2

(Fwd) DBD::Oracle

- Forwarded message from Mauricio Amorim [EMAIL PROTECTED] - Delivered-To: [EMAIL PROTECTED] From: Mauricio Amorim [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: DBD::Oracle Date: Sat, 29 Sep 2001 19:52:36 -0300 Hi Tim My name is Mauricio I am using DBI with DBD::Oracle.

Installing DBI on Windows 2000

I have installed Perl manually on a Windows 2000 server, but am having trouble with the DBI module. So far I've done: perl Makefile.pl nmake nmake gives me the following error : 'nmake' is not recognized as an internal or external command, operable program or batch file. I used

Re: Installing DBI on Windows 2000

This is not a DBI question. Look at the PPM man pages that came ActivePerl. file:///C:/Perl/html/faq/ActivePerl-faq2.html -- Simon OLiver

DBD::Oracle on AIX 4.3.3

Hello, we want to install DBI and DBD::Oracle on lots of Oracle servers running on AIX 4.3.3. When compiling the latest CPAN sources everything works well. There are, however, precompiled DBI and DBD::Oracle packages for AIX offered by Bull, and installing these packages is much faster. But

Re: Perl/Gui DB software

Hi Dan, I'm currently writing a db application based on Oracle with Perl batch processing, and am intending to implement a GUI front end. Perl/Tk looks like a possible option. I'm reasonably new to Perl but feel confident enough in it to create a functional app, even if the code is not

RE: DBD::Oracle with Oracle client on Redhat Linux 7.1

I downloaded the Oracle 9i installation for Linux from Oracle.com and installed the Client Administrator (which seems to include everything I need plus some extra). I did get a couple errors while installing but everything seems to have worked (I think). Now when I try to install DBD::Oracle

ANNOUNCE: DBD::Chart 0.42 available

DBD::Chart 0.42 is now available from either http://www.presicient.com/dbdchart/ or from CPAN (shortly). Changes from 0.41: - fix to support 'X-ORIENT=HORIZONTAL' on candlestick charts and symbolic domains FYI: DBD::Chart is a Perl DBI driver abstraction for rendering charts and graphs

DBI on Win2K

ActivePerl Build 629 Oracle 8.1.5 on Solaris DBI.pm,v 10.32 2000/06/14 20:04:03 After upgrading my Oracle client software from v8.05 to 8.1.5, I get the following error when trying to run *any* perl script which used to run flawlessly before: Can't connect to : Error while trying to retrieve

RE: DBD::Oracle with Oracle client on Redhat Linux 7.1

I installed Oracle Client Administrator from the Oracle.com download (Oracle 9i) and it seems to have installed correctly. However, when I try to install DBD::Oracle I get the following error: The ORACLE_HOME environment variable must be set. It must be set to hold the path to an Oracle

Correct Oracle environment Needed for DBI

I have a program that sets the Oracle environment for 8.1.7 and connects to the database just fine. If I resent the environment to 8.0.5 and try to connect to an 8.0.5 database, it fails with a OCIEnvInit error. If I leave the environment at 8.1.7 and connect to the 8.0.5 database, it succeeds.

RE: DBD::Oracle with Oracle client on Redhat Linux 7.1

Look at installing DBD::Oracle8 and see if this clears the problem up. Oracle changed some standards recently that regular DBD::Oracle got lost in. -Original Message- From: Philip Daggett [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 12:38 PM To: [EMAIL PROTECTED] Cc:

Error retrieving data from MS_SQL from solaris

Folks, Here is the DBI trace of trying to get data from an MS-SQL Database from solaris8. Note that it gets the field names, but no data. keith DBI::db=HASH(0x109d64) trace level set to 9 in DBI 1.19-nothread Note: perl is running without the recommended perl -w option -

RE: Prepare/Exec statement reuse

Thanks Hardy. That's the method that I couldn't remember. (finish) Ron -Original Message- From: Hardy Merrill [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 9:12 AM To: Ron Rohrssen Cc: Dbi-Users Subject: Re: Prepare/Exec statement reuse Although the perldocs(perldoc DBI)

porting error

I'm currently working on porting an application from a system that used isqlperl, to one that uses perl, DBI, and DBD-Oracle. I'm getting the following error. System 'znshs003' (8) is not configured in 'scat.cfg' Does anyone know what this is refering to? znshs003 is the node I'm porting

RE: DBI on Win2K

ORA 3121 means that your interface interface driver cannot be found. Does SQL*Plus work from the MS-DOS/command window? If not, it could be that the ORACLE_HOME is not set correctly Dan -Original Message- From: Jose Aguayo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 02, 2001 5:38

Re: Perl/Gui DB software

Dan Horne wrote: Also, I am considering porting the app to an opensource db. Because MySQL does not support transactions, it is out of the running. Wrong. Newer versions of MySQL do support transactions. I don't really like the way they're implemented, but it's a *fast* way for sure. However

date format in Oracle

Does anybody know if Oracle can take the date format as 'Thu Sep 20 15:03:10 PDT 2001') ? Thanks in advance, Jie

RE: date format in Oracle

I believe you will need to figure out the format string for it and it should work Anton -Original Message- From: jie zhang [mailto:[EMAIL PROTECTED]] Sent: Monday, October 01, 2001 3:59 PM To: [EMAIL PROTECTED] Subject: date format in Oracle Does anybody know if Oracle can take the

Re: date format in Oracle

I figured out every element of it except TIMEZONE. Does anybody know if Oracle has a format string for timezone ? select to_char(sysdate, 'dy mon dd hh24:mi:ss') from dual; TO_CHAR(SYSDATE,'DY --- mon oct 01 16:07:54 Thanks, Jie Kokarski, Anton wrote: I believe you will

Re: date format in Oracle

Use Oracle's to_date function. Example: select ename, hiredate from emp where hiredate = TO_DATE('Thu Sep 20 15:03:10 PDT 2001','DY MON DD HH24:MI:SS TZ '); At 03:58 PM 10/01/2001 -0700, jie zhang wrote: Does anybody know if Oracle can take the date format as 'Thu Sep 20 15:03:10 PDT

Re: date format in Oracle

Somehow, TZ is not recognized in my system. I am using oracle 8.1.7 on solaris 5.8. Did you actually tried out in your system ? Do I need to set up any NLS variable in order to use the 'TZ' keyword ? Thanks, Jie Anna Fong wrote: Use Oracle's to_date function. Example: select ename,

RE: DBI on Win2K

Actually yes - c:\sqlplus $user@$sid works fine. Also, registry indicates: MyComputer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 -- Oracle_Home variable is set to the proper filesystem path. Any other ideas? Jose -Original Message- From: Dan Horne [mailto:[EMAIL PROTECTED]] Sent:

Re: DBI on Win2K

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, Oct 01, 2001 at 10:37:59AM -0700, Jose Aguayo wrote: Can't connect to : Error while trying to retrieve text for error ORA-03121 This virtually always means that $ENV{ORACLE_HOME} is set wrong. Either it's incorrect altogether, or the

DBI-Installation

when I want to build the module with nmake I always get the message: fatal error U1034: Syntaxfehler: Trennzeichen fehlt which means in english: Seperator is missing OS: Windows 2000 perl v5.6.1 built for MSWin32-x86 hope sbdy can help thanx

Re: DBI on Win2K

The error message is: Can't connect to : Error while trying to retrieve text for error ORA-03121 The source is: use DBI; $db = DBI-connect(dbi:Oracle:$sid, $username, $password, {AutoCommit = 0, PrintError = 0}) || die Can't connect to $data_source: $DBI::errstr;

Informix client diferent to the Informix server

Hi: I have to write some Perl scripts that will reside on a Linux Intel machine, with RedHat 7.1. The Informix server will be a Unixware 7.1 server with Informix IDS 7.3. What do I need on the Linux machine so I'd be able to compile the DBD driver to acces the Unixware/Informix server? TIA.

RE: DBI-Installation

You must use the same utility from the compiler which was used to build your perl. If you are using ActiveState's ActivePerl, then VC++ nmake utility is what you should use, though in your case it looks like you don't have ActivePerl, so you must depending on the compiler you used, you must use