DBI and Sybase opening multiple connections.

Hi, I have a perl script that talks to a Sybase database through DBI to DBD::Sybase. The insert or update queries seems to open up an new TCP connection for each update or insert that the script has to perform. Once the statement has been executed it leaves the port in TIME_WAIT and will

Re: DBI, Oracle and Jobs

Don't forget to include a $dbh->commit; DBMS_JOBS requires it. Jared On Monday 15 April 2002 04:28, Job Miller wrote: > $dbh=DBI->connect(..); > > $sth=$dbh->prepare('BEGIN > DBMS_JOB.SUBMIT(...); > END;'); > $sth->execute; > > create a stored pr

Re: DBD and Oracle 8 and 9i

Alex, The simple answer is don't change your environment. There's really no need change the environment unless you want to take advantage of different features of the a database depending on version. Just change the database you are going to connect to in the DBI connect string. You can conne

Re: Syntax for Driver Specific attributes

That did it! Thanks Jose! "Nyimi Jose" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > -Original Message- > From: Dave K [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 19, 2002 4:16 PM > To: [EMAIL PROTECTED] > Subject: Re: Syntax for Driver Specifi

thank you, but another thing...

> > my $sql = < > select > > > ROUND((total_blocks-unused_blocks)/total_blocks*100), > > ROUNDhwm+1)- > > last_used_block)/total_blocks)*100) > > from M_stats_tab_us > > where M_stats_tab_us.Tabelle = ? > > and m_stats_tab_us.dp_nr = ? > > and

Re: Keyword "date" instigating error

"Pepin, Joseph D (Joe), SOLCM" wrote: > > > It would be nice if there was something like: my @quote_these = >$dbh->reserved_words; > I ran into this with CSV a while back, where TEXT was a reserved word in CSV but not >in Oracle. I'm not sure of the wisdom of such a method, but here's how to

Seeking Freelancer

Will K. writes: : Greets Folks, : : I need help with some too-involved-for-me CGI stuff, and I'd like to work : with a freelance programmer/consultant. put in a post at http://jobs.perl.org as well as here

Re: Keyword "date" instigating error

Thanks Dave. Worked like a charm. Next up is my 'update' question, but that will have to wait :) -R- - Original Message - From: David Kirol <[EMAIL PROTECTED]> To: robert pimentel <[EMAIL PROTECTED]> Sent: Friday, April 19, 2002 2:32 PM Subject: RE: Keyword "date" instigating error > Tr

RE: Keyword "date" instigating error

>From: Dave K [mailto:[EMAIL PROTECTED]] >Sent: Friday, April 19, 2002 3:47 PM >To: [EMAIL PROTECTED] >Subject: Re: Keyword "date" instigating error > >Not sure about other RDBMs but Oracle allows: >create table nonos("date" date, "More bad things" varchar2(20)); >but the columns with 'bad' name c

Re: Keyword "date" instigating error

Not sure about other RDBMs but Oracle allows: create table nonos("date" date, "More bad things" varchar2(20)); but the columns with 'bad' name can only be accessed the same way ie select "date", "More bad things" from nonos; "Karyn Ulriksen" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]

RE: Keyword "date" instigating error

The 'date' keyword issue usually occurs at the database level. Most SQL databases I have worked with wont even allow you to create a field with this name. It's possible that DBI does a "sanity check" on some of the keywork fields. The feedback on this issue should be interesting... K -Ori

Keyword "date" instigating error

Hello, Windows NT (sp6) Access 2000 (9.0.3821 SR-1) Access Driver 4.00.4403.02 (May be slightly outdated (8/8/99)) Perl 5.6.1 DBI 1.1.4 DBD-ODBC 0.28 The following error occurs when I attempt an insert... [ Couldn't execute insert statement: [Microsoft][ODBC Microsoft Access Driver] Syntax err

Re: its still a problem.

On Fri, 19 Apr 2002 15:14:20 +0200 (CEST) Michael Spellbrink <[EMAIL PROTECTED]> wrote: > my $sql = < select > ROUND((total_blocks-unused_blocks)/total_blocks*100), > ROUNDhwm+1)- > last_used_block)/total_blocks)*100) > from M_stats_tab_us > where M_st

Re: Question about logging in without username and password

On Fri, 19 Apr 2002 11:56:36 -0600 Ian Harisay <[EMAIL PROTECTED]> wrote: > I am moving one of my programs to be run on a different box. The rules > are a > bit different on the other box. One of those things is that the > username and > password can not be hardcoded into the program. I don't

RE: Question about logging in without username and password

With Microsoft SQL Server, you could use Windows authentication instead of SQL Server authentication. All you have to do is create a Windows user in SQL Server, then eliminate the username and password when connecting via DBI, like so: my $dbh = DBI->connect("dbi:ODBC:DRIVER={SQL Server

Re: its still a problem.

On Fri, 19 Apr 2002 09:42:32 -0400 [EMAIL PROTECTED] wrote: > I would change the first argument in bind_columns() to "undef" > > hence > $sth->bind_columns( \$statist,\$differ); > should be written: > $sth->bind_columns(undef, \$statist,\$differ); > > I'm not sure why this makes

RE: Question about logging in without username and password

Ian, Which environment and which kind of database? If you have unix with Oracle there's a really nice feature called "ops id" which allows the user to logon to the database provided his Oracle login name is the same as his unix login name. I'm not sure if it works going from one server to another

Question about logging in without username and password

Hi All, I am moving one of my programs to be run on a different box. The rules are a bit different on the other box. One of those things is that the username and password can not be hardcoded into the program. I don't have all the information yet, but does anyone know if the way to do this is

Seeking Freelancer

Greets Folks, I need help with some too-involved-for-me CGI stuff, and I'd like to work with a freelance programmer/consultant. The consulting will be for a mature themed site, and I am running on a limited budget, so open minds only please. The project is for a paid membership site using Per

Re: (Fwd) Do you know how to select * from a.table1@oracle_database1 then insert them into b.table2.@oracle_database2

On Fri, 19 Apr 2002 11:11:16 +0200 "NYIMI Jose (BMB)" <[EMAIL PROTECTED]> wrote: > http://otn.oracle.com/doc/server.815/a66736/ch63.htm#307 If you are trying to say INSERT from SELECT should be used between Oracle databases. I don't really disagree. Unfortunately, using INSERT or CREATE from S

RE: So far..

Hi Lee: You must have the DB2 client environment installed on any machine where you expect to run DBD::DB2 perl applications. That driver is dependent on the client libraries. You will also get this error when the client is installed, but you have failed to set the DB2INSTANCE environment vari

RE: :DB2 pod2man

Lee, you asked about pod2man: Well, pod2man is part of the standard Perl installation (but I think it can be turned off, if you don't want to install the documentation). It is used to read the POD documentation from a Perl source module and convert it into man page format. The program is usually

Re: urgent beginners problem!

Michael, Without seeing the exact error messages, it's hard to know exactly what your problem is. However one issue that I can point out is that you probably need to specify from which table you want column a, i.e. select y.a, b, c from x,y where x.a ... Hope that helps. -Joe On Fri, 2002-04

how to parse field properties

hi my name is oguz i am trying to parse field properties (using mysql) but get blob instead of text __ Free Email - http://www.lycos.co.uk

RE: Syntax for Driver Specific attributes

> -Original Message- > From: Dave K [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 19, 2002 4:16 PM > To: [EMAIL PROTECTED] > Subject: Re: Syntax for Driver Specific attributes > > > Jose, > Tried that, no good! > Upgraded to DBI 2.01 same result (access violation) Try upgrading yo

RE: urgent beginners problem!

Could you post your code? Gordon Dewis Production Officer Geography Division Statistics Canada (613)951-4591 -Original Message- From: Michael Spellbrink [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 8:37 AM To: [EMAIL PROTECTED] Subject: urgent beginners problem! dear expert

Re: Response to: 'Cleaned up local space -- still can't load db-4-1~1.gz"Disk quoa exceeded" '

Ed Sickafus wrote: > I > know that my project needs a flat table of a dozen columns and a few hundred > rows; it also needs to accomodate multiple client access. I plan to create a > CSV file that can be imported/exported to/from Access/Excell for > unsophisticated data processing. All of that ca

Re: Syntax for Driver Specific attributes

Jose, Tried that, no good! Upgraded to DBI 2.01 same result (access violation) Thanks for the suggestion (the book is in my lap...) "Nyimi Jose" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > -Original Message- > From: Dave K [mailto:[EMAIL PROTECTED

Problem / BUG with blob_read and DBI v1.21 and DBD::Oraclev1.12

I am trying to read from an oracle CLOB. When i call blob_read with 5 parameters then my script dies with a usage error; DBI blob_read: invalid number of parameters: handle + 5 Usage: $h->blob_read($field, $offset, $len [, \$buf [, $bufoffset]]) at test.pl line 112. It works correctly when only

Response to: 'Cleaned up local space -- still can't load db-4-1~1.gz"Disk quoa exceeded" '

> So why do you need the DB modules? If you want to construct a simple > database, you've already got the tools and don't need anything else. If > you want something more robust, you are probably better off with MySQL > or PostgresSQL or SQLite. But for simple testing and experimentation or > l

"MySQL and Perl for the Web" now available in Dutch

I'm pleased to announce that MySQL and Perl for the Web (New Riders, by me) is now available in a Dutch translation (MySQL en Perl voor het web). Not that I can read a word of it ... :-) Information is available on the translations page at the book's Web site: http://www.kitebird.com/mysql-perl/

So far..

Dear All, I have finally managed to install Perl DBI and then DBD:DB2, after realising there was another copy of Perl installed! Anyway onto my next problem:- On box 'A' I have Perl and DB2 V6.1 and I need to connect to box 'B' which is running DB2 7.1. When I run my Perl script on box 'A' it

RE: its still a problem.

Michael, I would change the first argument in bind_columns() to "undef" hence $sth->bind_columns( \$statist,\$differ); should be written: $sth->bind_columns(undef, \$statist,\$differ); I'm not sure why this makes it work better, and I think in some cases it's not necessary, but

its still a problem.

sub create_image { my $p= shift; my $dbh = shift; my $node = $p->{'node'}; my $tabelle = $p->{'tabelle'}; my $owner = $p->{'besitzer'}; $node =~ /(\d\d\d)/; my $heather =

Re: Getting types from statement handle (DBD::Pg)

Try the latest version (1.12). Tom On Thu, Apr 18, 2002 at 03:49:39PM -0400, Jeff Boes wrote: > According to the DBI dox, this: > > @names = map { scalar $dbh->type_info($_)->{TYPE_NAME} } > @{ $sth->{TYPE} } > > should return the datatype of each column of a SELECT statement. All I > e

Re: (Fwd) Do you know how to select * from a.table1@oracle_database1 theninsert them into b.table2.@oracle_database2

You have 2 choices for how to do this. If you have a database link between the two databases, it's really easy: $dbh->do('insert into table2 select * from table1@dblink_name'); Otherwise you need to loop it something like this: my $sth2 = $dbh2->prepare('select * from table2'); $sth2->execute()

RE: Syntax for Driver Specific attributes

> -Original Message- > From: Dave K [mailto:[EMAIL PROTECTED]] > Sent: Friday, April 19, 2002 2:07 PM > To: [EMAIL PROTECTED] > Subject: Syntax for Driver Specific attributes > > > Hi All, > I'm trying to use driver specific attributes, > specifically pg_type: > > my @tables = $

Re: urgent beginners problem!

Much of this does not make sense! > select a,b,c from x,y > where x.a = ? and > and y.a = ? and > and y.a (+) = ? > the statement is okay but when i try to fetchrow_array no it's not - duplicate and junctions > (to get columns a and b in @a and @b), that's not what fetchrow_array does! Send u

Re: urgent beginners problem!

on Fri, 19 Apr 2002 12:36:38 GMT, [EMAIL PROTECTED] (Michael spellbrink) wrote: > [...] > but when i try to fetchrow_array > (to get columns a and b in @a and @b), > i get only errors. could anyone help? What errors? Could you post the offending code and the error messages? That way it will be

urgent beginners problem!

dear experts, im farly new to dbi and have serious trouble while trying to get this this sql statement parsed select a,b,c from x,y where x.a = ? and and y.a = ? and and y.a (+) = ? the statement is okay but when i try to fetchrow_array (to get columns a and b in @a and @b), i get only erro

Syntax for Driver Specific attributes

Hi All, I'm trying to use driver specific attributes, specifically pg_type: my @tables = $dbh->tables; foreach $table (@tables) { print"Table: $table\n"; $sql = "SELECT * FROM $table"; $sth = $dbh->prepare($sql) or print"Prepare fails\n"; $sth->execute or print"Execute fai

DBD::DB2 pod2man

Dear All, I am installing the DBD::DB2 bundle (On solaris)and I get the following error when I execute perl Makefile.PL :- Warning: I could not locate your pod2man program. Can someone please tell me what this program is for and how I fix the problem. Thanks in advance. Lee

RE: (Fwd) Do you know how to select * from a.table1@oracle_database1 then insert them into b.table2.@oracle_database2

http://otn.oracle.com/doc/server.815/a66736/ch63.htm#307 José. -Original Message- From: Michael A Chase [mailto:[EMAIL PROTECTED]] Sent: Friday, April 19, 2002 7:03 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: (Fwd) Do you know how to select * from a.table1@oracle_database1