Re: building DBI and DBD::Informix and move it to other machine

"Mahdi A. Sbeih" wrote: > I made a Perl DBI script on Solaris 2.7, I want to send this script to a > customer who has also Solaris 2.7, > do the customer need to install and build DBI and DBD::Informix on that > machine? Or I can just send him the > compiled files that were built on my machine? I

re: Re: perl data structure for Oracle "index-by table"

Tony, Disregard that last e-mail of mine. I'm doing this work via internet cafe(while re-locating) and did not entirely digest your last copious response before I sent my reply. Let me noodle with this and see how I can fit it to my task. I think you have explained it great. Thanks again Marty

Re: SQL statement.

Dear all, Yes, $ID_Code is numeric field. I tried using $sth->bind_param(1,undef,SQL_INTEGER), the result some came out some didn't. But I used to use placeholder to insert records into Access database. It didn't care about the field type. Krung. > -Original Message- > From: Brose, E

RE: Help- DBI::Proxy and RPC::PlClient problems

Try looking at the output from the Proxy Server using --debug and use DBI trace on the client. This should tell you some more. --Neil >-Original Message- >From: Douglas Smith [mailto:[EMAIL PROTECTED]] >Sent: Friday, June 15, 2001 4:25 AM >To: [EMAIL PROTECTED] >Subject: Help- DBI::Prox

RE: works in sqlplus but not through script

use trace() level 2 or higher, depending on the info you get from two. You can send the output to us. Ilya > -Original Message- > From: Laurie Gennari [mailto:[EMAIL PROTECTED]] > Sent: Thursday, June 14, 2001 8:16 PM > To: Dbi-Users (E-mail) > Subject: works in sqlplus but not through

RE: Error installing DBI

Hi, I think I have a similar problem as Mehdi. The problem is my script does not run and gives me this error: Can't locate DBI.pm in @INC at qf_system_blast.pl line 14. BEGIN failed--compilation aborted at qf_system_blast.pl line 14. I took your advise and checked /usr/local/lib and I found this

RE: Error installing DBI

It sounds like there might be a problem with you perl install. I say that because if you look at the output of the perl -V you won't see /usr/local/lib/perl5/site_perl/5.005/sun4-solaris/ any where in the @INC: (the last line of that output) I also see that it has versions 5.002. which must be up

RE: Error installing DBI

thanks again. I have another question. I don't know that much on DBI and I have copied most of the lines from another script. I just want to know the procedure in accessing databases(in my case Sybase). For example what does suppose to go in @INC. And what else do we need, such as `use DBI`, etc.

works in sqlplus but not through script

Hey gang- I'm sure I must be missing something obvious (it's been one of those weeks), but I can't for the life of me figure out why this doesn't work. It just hangs and never finishes. Any help would be much appreciated. ltg #!/usr/local/bin/perl use DBI; $ENV{ORACLE_HOME} = '/opt/oracle/pro

re: re: perl data structure for Oracle "index-by table"

t. This is great, especially the data structures cookbook tip. I know perl can do what I need. Regarding my last question-- You're right, I am trying to change one of the values in one of the arrays while maintaining the data structure. Let me tell you a little bit more about what I need to do. T

RE: Error installing DBI

Nina, I recomend getting your perl install or environment problem fixed first. when you have good perl install you will need to build DBI module first then DBD::Sybase the version of the perl that is used to in your script is 5.002 I'm not sure if this modules will even build under that versio

Re: select column headers

On Thu, 14 Jun 2001 15:16:05 -0700, traja wrote: >How do I get the headers (column names) when I do a select thro' DBI. >fetchrow will fetch only the data. I need to display the headers as >well. Simple. A statement handler has several attributes. See perldoc DBI for a rather complete list. Amon

RE: select column headers

Either use fetchrow_hashref, or use $sth->{NAME} (or NAME_lc or NAME_uc). See the DBI perldocs. -Original Message- From: traja [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 3:16 PM To: [EMAIL PROTECTED] Subject: select column headers How do I get the headers (column names) w

RE: select column headers

in that case use fetchrow_hashref. Regards, Anton Kokarski -Original Message- From: traja [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 3:16 PM To: [EMAIL PROTECTED] Subject: select column headers How do I get the headers (column names) when I do a select thro' DBI. fetchro

select column headers

How do I get the headers (column names) when I do a select thro' DBI. fetchrow will fetch only the data. I need to display the headers as well. Thanks for any help.

Struggling to use DBIx

My original post from a few days ago was apparently too vague, because no one responded, so I'll try to be a bit more concise this time. I'm trying to use the DBIx::AnyDBD library. From its documentation it is evident that the library really doesn't do much, since much of the library is left of

Re: Error installing DBI

ExtUtils::MakeMaker is one of the modules that comes with Perl, so if it can't be found in the standard @INC list, you have a seriously damaged Perl installation. See if the file exists anywhere under /usr/local/lib/perl5. Perl is looking for modules under /usr/local/lib because that's where the

Help- DBI::Proxy and RPC::PlClient problems

I am trying to get a distributed app going using DBI:Proxy to connect to an Oracle database. The problem is there are many remote sites which need to get the Bundle::DBI installed so DBI::Proxy will work for them. I finally got someone to install it for me, and when I try to use DBI::Proxy on

re: Re: perl data structure for Oracle "index-by table"

> "Marty" == m keane <[EMAIL PROTECTED]> writes: Marty> This is what I'm looking for. My point about the Marty> foreach/fetchall_arrayref was only to indicate my Marty> limited experience using fetchall_arrayref. That's the Marty> only programming context in which I've used it. Fair enough.

RE: DBI/DBD mysql freebsd4 __errno_location problem

For kicks, why don't you try upgrading to the lastest version, I am running Msql-Mysql-modules-1.2215 and I can't seem to find __errno_location. On 14-Jun-01 Rich Caller wrote: > I'm reinstalling DBI/DBD (Msql-Mysql-modules-1.2204) in an odd > location after a system rebuild and am having a pro

RE: libclntsh.so

You'll need more that just libclntsh.so. You need to install the Oracle client to be able to compile, it's freely available from Oracle. Ilya -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 06/14/2001 9:17 AM Subject: libclntsh.so I'm trying to build DBD::Oracle

libclntsh.so

I'm trying to build DBD::Oracle for oracle 8i on IRIX 6.5. Is there anyway to get libclntsh.so without having to install Oracle? Oracle is already set up on another machine, I just need to build the driver to connect to it.

RE: Error installing DBI

Well do you have a MakeMaker.pm file? That's what it is telling you, it needs this file, you should have it unless you purposefully deleted it. Perl is installed with some core modules and you @INC should point to it. Ilya Sterin -Original Message- From: Mahdi A. Sbeih To: [EMAIL PROTEC

odd behavior with $DBI::errstr and Sybase (bug?)

While experimenting with subclassing DBI, I came across an odd behavior for $DBI::errstr. I was doing things like: *MyClass::errstr = \$DBI::errstr; So that I could use $MyClass::errstr as an alias for $DBI::errstr. (By the way, it would be nice if the init_rootclass() method did somet

Error installing DBI

Hi All, While I am trying to install DBI 1.15 on Solaris, perl Makefile.PL PREFIX=$HOME INSTALLSITELIB=$HOME INSTALLSITEARCH=$HOME/sun4-solaris I got this error: Can't locate ExtUtils/MakeMaker.pm in @INC (@INC contains: lib /usr/local/lib/perl5/sun4-solaris/5.00404 /usr/local/lib/perl5 /usr/l

RE: What are the results of compiling

Hi Michael, I mean what files I will have and where they will reside? Thanks in advance. Mahdi. -Original Message- From: Michael A. Chase [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 14, 2001 1:10 PM To: Mahdi A. Sbeih; [EMAIL PROTECTED] Subject: Re: What are the results of compilin

Re: What are the results of compiling

If all goes well, you have working DBI and DBD::Informix modules. If you had problems, you need to read the README files and send us what they suggest for us to be able to help. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll ea

DBI/DBD mysql freebsd4 __errno_location problem

I'm reinstalling DBI/DBD (Msql-Mysql-modules-1.2204) in an odd location after a system rebuild and am having a problem that I am having difficulty in finding a solution to. Everything seems to build fine but when I make test the tests I get. install_driver(mysql) failed: Can't load '../blib

DBD-Oracle-1.06 HPUX problems lib -lnbeq8

Hi there, Can you check this installation procedure to see if I 'm doing something wrong or forgetting something. Thanks. Environment OS: HP-UX 11 Oracle: 8.1.6.1 Perl : 5.6 These are the steps I followed: * Config.pm * adjust /opt/perl5/lib/5.6.0/PA-RISC1.1/Config.pm

RE: How can I get insert_id from DBD::Oracle?

All, Using a sequence and trigger as discussed will allow the following to work : INSERT INTOtab (value) VALUES ('foo'); SELECT MAX(id) FROM tab; as long as these two statements are within the same transaction block. I do however like the Oracle 8 returning clause a l

What are the results of compiling

Hi All, When Compiling DBI and DBD::Informix, What are the results exactly from the compiling? Regards, Mahdi.