cannot install DBI--please help

Hi, I am having a problem with installation of DBI. I am installing it on Solaris 5.8 . I downloaded the tar file from CPAN. I am getting the following error when i run the "make test" as asked in the docs: Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1:

RE: help, help

Hi, I don't know if your question has been answered yet. I see two problems: I think that the error is fairly clear on how to correct it. You can fix it by either destroying the statement handle (a good way is to use "my" and then when it leaves its scope it's automatically destroyed) or use:

Re: Re: DBD::Oracle on NT; OCI directory not found error

Thanks Is OCI or Pro*C is avail free? atleast shareware! If yes? URL please.. Thanks again... From: "Michael A. Chase" [EMAIL PROTECTED] Date: 2001/04/16 Mon PM 12:56:43 EDT To: "Prasanna Gopalakrishna" [EMAIL PROTECTED], [EMAIL PROTECTED] Subject: Re: DBD::Oracle on NT; OCI directory not

newbie question to sysdate

Hi, I am new to this list and am looking for some help. I have tried finding my problem with perldoc DBI and the FAQ, but without luck... 8( I am trying to execute the following statement: $query = $dbhandle-prepare("select FAXID from GMX.FAX_DIR where PROCESSLEVEL=2 and (sysdate -

Re: Oracle-DBI-Win2k-Apache- MUST AUthenticate

On Mon, Apr 16, 2001 at 07:44:57PM -0400, Sterin, Ilya wrote: I am afraid that's wrong, the arrow - is resolved in the string context since it's the same as dereferencing the object in the string context. The problem is that the user which is executing the script does not have the

Re: newbie question to sysdate

On Tue, Apr 17, 2001 at 04:11:53PM +0200, jmb wrote: Hi, I am new to this list and am looking for some help. I have tried finding my problem with perldoc DBI and the FAQ, but without luck... 8( I am trying to execute the following statement: $query = $dbhandle-prepare("select FAXID from

dbd and odbc...blobs

Hey there, I am new at this here, I was just wondering did anyone have any pointers on what to look for or how best to implement Blobs using ODBC...this is how I currently use it with Pg...but I need to port this to ODBC... any help pointers would be appriciated! Cliff. Pg Blob Export #

Re: newbie question to sysdate

Thanks to everybody for the tips! As pointed out the problem was an undef handle. I forked before connecting and so the child didn't have the handle, while the parent's had it. Thanks again! Joachim On Tuesday 17 April 2001 16:11, you wrote: Hi, I am new to this list and am looking for

cannot install DBI--please help

Hi, I am having a problem with installation of DBI. I am installing it on Solaris 5.8 . I downloaded the tar file from CPAN. I am getting the following error when i run the "make test" as asked in the docs: Can't load 'blib/arch/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: ld.so.1:

Error trying to access Oracle from Perl

We are getting the following error after we've installed Oracle 8.1.7, Perl, DBI 1.15, and DBD 1.06. DBD::Oracle initialisation failed: Can't locate auto/DBD/Oracle/ORA_OCI.al in @I NC (@INC contains: /usr/local/lib/perl5/5.6.1/i686-linux /usr/local/lib/perl5/5. 6.1

Bugs in DBI::Shel

Hello Tim and DBI hackers, I have started using dbish, because I am programming a device which has very small storage, and dbish is smaller than the msql binary (in a jffs2 filesystem). I have found some bugs in the DBI/Shell.pm. I cannot send patch, because I needed to cut some

Error in DBD::Oracle Installation

Hi DBI-USERS, Tim, Ilya, ... I'm trying install DBD::Oracle on Solaris machine and tried all options as mentioned in the README.xxx files. Still having same problem when running make test. SQLPLUS works good on this machine. Any suggestions appreciated. Thanks Find an log for 'make' and

Re: RE: Error in DBD::Oracle Installation

Thanks! I don't where I have to put Oracle.so file Please let me know to which directory I supposed to put from where?? Thanks again From: Jayanta Banerjee [EMAIL PROTECTED] Date: 2001/04/17 Tue AM 09:33:29 EDT To: 'Prasanna Gopalakrishna' [EMAIL PROTECTED] Subject: RE: Error in

Re: Complex SQL statments - Do they work?

Kutler, Christopher writes: I've tried the following SQL statement which does work via SQL Server 6.5. However, it does't seem to work when I run the same statment through DBI: snip It would help if you told us *what* doesn't work, and what DBD driver you are using. Off hand I don't see

RE: Complex SQL statments - Do they work?

You sure that's an ANSI SQL statement. Looks like a procedure. I am not familiar with SQL Server, but some functions here might be also dependent on the tool used to execute this procedure. You should run as a stored procedure, see docs. Also what error message are you getting and some code

RE: Error in DBD::Oracle Installation

Make sure your LD_LIBRARY_PATH is set correctly for the username which is installing DBD::Oracle Ilya Sterin -Original Message- From: Prasanna Gopalakrishna To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Sterin, Ilya Sent: 04/17/2001 10:29 AM Subject: Error in DBD::Oracle Installation

Re: RE: Error in DBD::Oracle Installation

LD_LIBRARY_PATH environment set as LD_LIBRARY_PATH=/home/oracle/lib:/usr/lib:/usr/ucblib The whole environment variable for the user found in the bottom of this files... Jayantha Banerjee suggested that Oracle.so is not in proper directory. Is it right? I don't know where to put this

Funny Error at DBD::ADO

Hi There, I sent an email a few days ago, I received some precious help regarding Access DB connection, I am using DBI:ADO in order to get it done, thanks to some clues you gave me I was able to make it work, but in the middle I think I messed up something. Let me clarify this point, I have

uninitialized value in concatenation?

when i run a script that has the following bit of code I get an warning: use of uninitialized value in concatenation (.) at I get it for the line: if (($sth_display-{NAME}-[$c]) !~ /id/i) Is my syntax correct here.? The program runs (occasionally) and i get appropriate results...I just

RE: Unsuscribe

Some users are 'subscribed' by friends playing 'games'.

Re: Unsuscribe

I'm not sure I'd call them friends. In any case, you should have received instructions that included how to unsubscribe. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat

update multi row when i meant update single row

Dear all: I tried to update a single row for the database, however, the query here update multiple rows my $sql = "UPDATE uptime SET up_time=$new_uptime WHERE hostname = '$host' and startdate= (select MAX(startdate) from uptime where hostname

Re: update multi row when i meant update single row

- Original Message - From: Xiaoxia Dong [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, April 17, 2001 10:47 PM Subject: update multi row when i meant update single row Dear all: I tried to update a single row for the database, however, the query here update multiple rows

RE: Complex SQL statments - Do they work?

-Original Message- From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 18, 2001 2:56 AM To: 'Kutler, Christopher '; ''DBI User Group' ' Subject: RE: Complex SQL statments - Do they work? You sure that's an ANSI SQL statement. Looks like a procedure. I am not

RE: Complex SQL statments - Do they work?

Neil Lunn writes: From: Sterin, Ilya [mailto:[EMAIL PROTECTED]] You sure that's an ANSI SQL statement. Looks like a procedure. I am not Yes it's a Transact SQL statement. Should work directly against Sybase as well but it's not valid ANSI SQL. Either it needs to be

RE: Complex SQL statments - Do they work?

Chris, There are a lot of possibilities there. If you are using ODBC the first thing that comes to mind is whether or not one of the columns you are querying is a text data type. I've used queries with similar complexity on SQL 6.5 and 7.0, so complexity is not the issue. If you are getting an

Re: Bugs in DBI::Shel

Upgrade to DBI 1.15. Tim. On Mon, Apr 16, 2001 at 11:40:11PM +0200, dLux wrote: Hello Tim and DBI hackers, I have started using dbish, because I am programming a device which has very small storage, and dbish is smaller than the msql binary (in a jffs2 filesystem). I have

Querying a database

Hello everyone!! Does any of you know how I can query a database? I have a database on a windows machine and I want to be able to perform some simple queries to it using perl. Can anyone help? Thank you in advance. _ Get

(Fwd) precompiled Oracle DBD?

- Forwarded message from John West [EMAIL PROTECTED] - Date: Tue, 17 Apr 2001 08:00:30 -0700 (PDT) From: John West [EMAIL PROTECTED] Subject: precompiled Oracle DBD? To: [EMAIL PROTECTED] Is it possible to get a precompiled NT Oracle.pm for Oracle equivalent to ODBC 8.01.06.0? I can't

Re: make test fails at plsql #55

Tim has said that there is a problem with test 55 in plsql.t. Since the following tests depend on it, they should also be ignored. If you had no other failed tests, you may install DBD::Oracle. -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a

Re: Querying a database

Buy and read "Programming the Perl DBI". -- Mac :}) ** I normally forward private database questions to the DBI mail lists. ** Give a hobbit a fish and he'll eat fish for a day. Give a hobbit a ring and he'll eat fish for an age. - Original Message - From: "Sumic Leonard" [EMAIL

CPAN, DBD and DBI::Pg

Maybe you can help ;-) I'm having bad problems being that I am a newbie...Put it this way - we have a SysAdmin that is CCNA/CCDA/CCNP certified, but he wants me to learn how to do this on my ownHere's what I need: Someone on the dbi-users list yesterday told me to use CPAN and first install

RE: CPAN, DBD and DBI::Pg

You don't need to uninstall the second Perl installation, you can just install modules for that install. My machine has 4 different Perls, although I use the most recent one, the other ones don't really bother me or the server. Just make sure when you execute: perl Makefile.PL etc... you use

Re: CPAN, DBD and DBI::Pg

On Tue, 17 Apr 2001 21:01:57 -0500, Jay Fitzgerald alluded: Maybe you can help ;-) I'm having bad problems being that I am a newbie...Put it this way - we have a SysAdmin that is CCNA/CCDA/CCNP certified, but he wants me to learn how to do this on my ownHere's what I need: Those

Re: RE: Error in DBD::Oracle Installation

Still running around with the same problem. I wonder this could be the problem! not sure... i) Do I need to set ORACLE_USER along with ORACLE_HOME, ORACLE_SID, LD_LIBRARY_PATH environment before install DBD::Oracle If yes who? admin or any db-user? ii) also, do need to install any other

Re: RE: Error in DBD::Oracle Installation

running behind the same problem fromlast couple of days! I wonder any of following could causing the problem! not sure... Any thoughts? i) Do I need to set ORACLE_USER along with ORACLE_HOME, ORACLE_SID, LD_LIBRARY_PATH environment before install DBD::Oracle If yes who? admin or any db-user?