RE: Sybase.dll Load Error

2001-08-15 Thread Neil Lunn
That's the fourth time. Enough is enough. Stop posting this. Someone will answer [maybe] in their own time. Perhaps you may think that prodding a tiger with a stick is also a wise thing to do? --Neil >-Original Message- >From: Falk [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 16,

Sybase.dll Load Error

2001-08-15 Thread Falk
Hi, I used to use DBD:Oracle and it worked fine. I'm using ActivePerl 5.6.1. Now I switched to DBD:Sybase. I installed the Sybase module via ActiveState ppm. So far ok. When I tried to execute a perl script connecting to a sybase db I get the following error: install_driver(Sybase) failed_ Can't l

RE: DBD-1.08 & DBD-Oralce-1.01

2001-08-15 Thread Sterin, Ilya
www.cpan.org > -Original Message- > From: Veeresh [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 16, 2001 12:56 AM > To: [EMAIL PROTECTED] > Subject: DBD-1.08 & DBD-Oralce-1.01 > > > Hi, > > I need DBD-1.08 and DBD-Oralce-1.01. > Can you please suggest me where i can get these. >

Re: Database connection

2001-08-15 Thread Konstantin
Hi Gopi I had the same problem with windows 2000 and Oracle 8.1.4. After I installed Oracle 8.0.1 instead of Oracle 8.1.4 the problem was gone. I hope that it helped - Original Message - From: gopinath r <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday

Re: Problems with INSERT

2001-08-15 Thread Jonathan Leffler
Andreas-Schmitz wrote: > my $dbh = DBI->connect($dsn, $user, $passwort,{RaiseError => 1}); > > > > $dbh->do("INSERT INTO bearbeiter (funktionID, redakteurID) ". > > "VALUES ('$funktionID', '$redakteurID')"); > > better $sth = ( "INSERT INTO bearbeiter (funktionID, redakteurID) VALUES >

DBD-1.08 & DBD-Oralce-1.01

2001-08-15 Thread Veeresh
Hi, I need DBD-1.08 and DBD-Oralce-1.01. Can you please suggest me where i can get these. Thanks in advance, Regards, Veeresh.

RE: Database connection

2001-08-15 Thread Neil Lunn
>-Original Message- >From: gopinath r [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, August 15, 2001 4:52 PM >To: [EMAIL PROTECTED] >Cc: [EMAIL PROTECTED] >Subject: Database connection > > >Hello > >I have some doubts about connecting oracle 8.4 >database from perl 5 > >I installed Indigoper

DBD::Oracle

2001-08-15 Thread Aleksandr Vladimirskiy
Hi all, I am installing DBD::Oracle v. 1.08 on Solaris 2.6, with perl 5.6.1. At make I recieve the following error : cc: P,/lib:/usr/lib:/usr/local/lib:/oracle/u01/oracle/product/8.05/lib:/opt/SUNWcluster/lib:/usr/ccs/lib:/usr/lib: No such file or directory cc: unrecognized option `-Y' make: ***

Database connection

2001-08-15 Thread gopinath r
Hello I have some doubts about connecting oracle 8.4 database from perl 5 I installed Indigoperl(perl 5) in widows NT system.The directory G:/Indigoperl/site/lib contains DBI.pm if i try to connect to database ,it showing error "Can't locate DBI.pm in @INC (@INC contains: G:/Perl/lib G:/Perl/si

Database connection

2001-08-15 Thread gopinath r
Hello I have some doubts about connecting oracle 8.4 database from perl 5 I installed Indigoperl(perl 5) in widows NT system.The directory G:/Indigoperl/site/lib contains DBI.pm if i try to connect to database ,it showing error "Can't locate DBI.pm in @INC (@INC contains: G:/Perl/lib G:/Perl/si

change column type

2001-08-15 Thread Konstantin
Hi. I have changed the type of column in some table from number(10) to varchar2(50). If I update the column manualy, I mean by SQL+, it's OK. But if I try to update the above column via Perl DBI with some string, I get the error 984 - cloumn not allowed here. If I update it via Perl DBI with s

Binding cursors: what's going wrong here?

2001-08-15 Thread Rob McMillin
Revisions: Oracle 8.1.7.1.1 (8i release 3) RedHat 6.2 Perl 5.6.0 DBD::Oracle 1.07 I'm trying to bind a cursor so I can use the "FOR UPDATE OF" clause to do updates and deletions. However, I can't even get the select working correctly! Here's my Perl code: #!/usr/bin/perl use DBD::Oracle qw(:

Re: 1.19 breaks simple @ISA stuff?

2001-08-15 Thread Tim Bunce
On Wed, Aug 15, 2001 at 02:32:04PM -0400, Phil R Lawrence wrote: > The following simple tests show something changed from 1.15 to 1.19 when it > comes to inheriting and ultimately subclassing the DBI. Can anyone help me > see what it is? > > This simple script works fine with our new Perl 5.6.1

Re: Problems with INSERT

2001-08-15 Thread Andreas-Schmitz
my $dbh = DBI->connect($dsn, $user, $passwort,{RaiseError => 1}); > $dbh->do("INSERT INTO bearbeiter (funktionID, redakteurID) ". > "VALUES ('$funktionID', '$redakteurID')"); better $sth = ( "INSERT INTO bearbeiter (funktionID, redakteurID) VALUES ('$funktionID', '$redakteurID')" );

1.19 breaks simple @ISA stuff?

2001-08-15 Thread Phil R Lawrence
The following simple tests show something changed from 1.15 to 1.19 when it comes to inheriting and ultimately subclassing the DBI. Can anyone help me see what it is? This simple script works fine with our new Perl 5.6.1 and DBI 1.19 install, thus I know that our sysadmin put everything in corre

Re: Query tha returns nothing

2001-08-15 Thread Erick Nelson
ingore the "use ORA;" in my example Erick Nelson wrote: > you can if you prepare and use fetchrow_hashref and rows... > > use DBI; > use ORA; > > my $dbh = DBI->connect(...connect stuff here...)) || die $DBI::errstr; > my $sql = "select * from sfile"; > my $sth = $dbh->prepare($sql) || die $dbh-

Re: Query tha returns nothing

2001-08-15 Thread Erick Nelson
you can if you prepare and use fetchrow_hashref and rows... use DBI; use ORA; my $dbh = DBI->connect(...connect stuff here...)) || die $DBI::errstr; my $sql = "select * from sfile"; my $sth = $dbh->prepare($sql) || die $dbh->errstr; $sth->execute || die $sth->errstr; while (my $href = $sth->fet

Sybase.dll Load Error

2001-08-15 Thread Falk
Hi, I used to use DBD:Oracle and it worked fine. I'm using ActivePerl 5.6.1. Now I switched to DBD:Sybase. I installed the Sybase module via ActiveState ppm. So far ok. When I tried to execute a perl script connecting to a sybase db I get the following error: install_driver(Sybase) failed_ Can't l

RE: DBI and DBD

2001-08-15 Thread Sterin, Ilya
Yes, I guess they haven't updated yet. You can compiler yourself if you have Visual C++ on your PC, since this is what was used to compile ActivePerl. perl Makefile.PL nmake nmake test nmake install Ilya -Original Message- From: Sanjay Perl To: Sterin, Ilya; [EMAIL PROTECTED]; [EMAIL

RE: DBI and DBD

2001-08-15 Thread Sanjay Perl
On a similar topic - are the Win32 binaries available for these (new) versions of the DBI/DBD? If so, where may they be available for download. I've checked ActiveState, and they still carry older versions (pre 1.18). TIA Sanjay >From: "Sterin, Ilya" <[EMAIL PROTECTED]> >To: Harsh Pandey <[EM

Re: Problems with INSERT

2001-08-15 Thread Hardy Merrill
See my comments below... Marcus Willemsen [[EMAIL PROTECTED]] wrote: > Hi all, > > I am having troubles with the script below. (I hope nobody minds that the > names of the variables and params are in German) > > The script reads data coming from a form and inserts it inot the > appropriate ta

Query tha returns nothing

2001-08-15 Thread Rozengurtel, Daniel
Hello, I am executing a query that in some cases dont have an entry for the instrument_id I am using to retrieve by. I.e there is no physically record in there (NVL wouldnt work). This is a peice of code i am struggking with: undef $ticker; $sql="SELECT SUBSTR(ISS_ID,1, INSTR(ISS_ID,' ',1

Problems with INSERT

2001-08-15 Thread Marcus Willemsen
Hi all, I am having troubles with the script below. (I hope nobody minds that the names of the variables and params are in German) The script reads data coming from a form and inserts it inot the appropriate tables. Well it works for almost all values except for $ueberschrift and $text. The f

change of column type

2001-08-15 Thread Konstantin
Hi. I have changed the type of column in some table from number(10) to varchar2(50). If I update the column manualy, I mean by SQL+, it's OK. But if I try to update the above column via Perl DBI with some string, I get the error 984 - cloumn not allowed here. If I update it via Perl DBI with s

change column type

2001-08-15 Thread Konstantin
Hi. I have changed the type of column in some table from number(10) to varchar2(50). If I update the column manualy, I mean by SQL+, it's OK. But if I try to update the above column via Perl DBI with some string, I get the error 984 - cloumn not allowed here. If I update it via Perl DBI with s

Sybase.dll Load Error

2001-08-15 Thread Falk
Hi, I used to use DBD:Oracle and it worked fine. I'm using ActivePerl 5.6.1. Now I switched to DBD:Sybase. I installed the Sybase module via ActiveState ppm. So far ok. When I tried to execute a perl script connecting to a sybase db I get the following error: install_driver(Sybase) failed_ Can't l