DBI.pm DBD::Oracle::db

From: Mei Chang (MChang_at_tiaa-cref.org)
Date: 10/23/03

  • Next message: Ron Savage: "Re: how to copy a database" 
    To: "'dbi-users@perl.org'" <dbi-users@perl.org>
Date: Thu, 23 Oct 2003 15:23:10 -0600

    Users,

    I wrote a perl script and compiled it by perl2exe. I placed the exe file to
    different machines, the results were different:

    Procedures:

    1. ran from my pc, it worked fine (my PC is Win2K) - My pc has DBI module
    and perl 5.6 installed
    2. placed the executable on server A (Win NT)and ran on it, it worked fine.
    - This server happened to have perl 5.0.1 and oracle client installed.
    3. placed on Server B (W2k) and ran on it, it failed on db-connect (please
    see the attached trace file)
    4. Mapped to server B's drive with the executable there, and ran it from my
    pc, and it worked.
    5. Logged onto server B, and ran the executable on Server B again, it still
    failed with the same error.
            
        The only problem seemed to be on the server B. but looking I could not
    figure out what's wrong?
        (Note: The dsn, sid, db name, user id, password are all the same. )

         With the executable, I should not need the perl.exe on server B, and
    with DBI and DBD, I should not need Oracle client. What did I miss?

    Thanks in advance.

    M. Chang

    The two trace files were from server B .

    procedure #3's results
     <<trace.notworking.txt>>

    procedures #4 results
     <<trace.working.txt>>

    **************************************************************
    This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, please contact sender immediately by reply e-mail and destroy all copies. You are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
    TIAA-CREF
    **************************************************************

  • Next message: Ron Savage: "Re: how to copy a database"

    Relevant Pages

    • ANNOUNCE: UnixODBC 0.31
      ... UnixODBC provides a toolkit for writing Perl ODBC clients. ... - Installing and Configuring the Bridge Server ... UnixODBC.pm provides Perl programs with a subset of the X/Open ... Bridge Server," below. ...
      (comp.lang.perl.modules)
    • POP3 Mail Client in PERL using IO::Socket module only and regular expressions
      ... I am writing a POP3 Client program in Perl. ... Server and have a running conversation with the mail server using ... print $socket "STAT",CRLF; ...
      (comp.lang.perl.misc)
    • Solved: Perl/NFS "Text File Busy" Error And Related Problems
      ... Â That means I am actually editing the Perl file on ... and I am running it on another (my server). ... The first problem I had was that when I saved my script through NFS, ... apt-get install nfs-kernel-server ...
      (Debian-User)
    • Perl on Linux and SQL Server 2000 on Windows
      ... There was a time when I did a lot of searching on ways to use Perl ... sitting on Linux to connect SQL Server 2000 sitting on Windows. ... cpan> install DBI ... Install FreeTDS ...
      (comp.os.linux.misc)
    • SOLVED: "Text File Busy" And Other Frustrating NFS/Perl Errors
      ... Perl file on one computer, ... and I am running it on another (my server). ... The first problem I had was that when I saved my script through NFS, ... searched newsgroups on Usenet and mailing lists and general Google searches ...
      (comp.lang.perl.misc)