Re: Design a place to open/modify/close a ticket

2001-03-06 Thread David Adams
See: http://www.perl.com/pub/1998/11/article.html It doesn't use Oracle, but it does seem to have a good interface, which is probably the hardest part of the design. -- David Adams Computing Services Southampton University - Original Message - From: "Nguyen, David M" [EMAIL PROTECTED]

mSQL problem similar to morning bug but not quite...

2001-03-06 Thread John Reid
Hi Guys I have been through the guide and the archives and have solved part of the problem but not all. A client wanted an old web site updated to run on mod_perl. We sorted this out but we have a problem with his mSQL database. The error given is as follows: Socket read on 3 for length failed

Re: (Fwd) Can't call method execute error undefined value

2001-03-06 Thread Michael A. Chase
The value of an assignment operation is the value assigned; in this case the result from DBI-connect(). The 'or' version is generally preferred in this sort of situation to be sure all operations to the left have been performed before the 'or'. -- Mac :}) ** I normally forward private database

Database Discovery Conference - Geek Cruise - Special Offer

2001-03-06 Thread Tim Bunce
Many of you will have read about the wildly successful Perl Whirl cruise http://www.geekcruises.com/perl/perl_fromtheboat.html and http://www.wired.com/wired/archive/8.10/cruise.html Well, time is running out to sign-up for the unique Geek Cruise conference experience applied to databases, in...

Re: DB2 server Connection from WEB server

2001-03-06 Thread db2perl
Hi Tomo. Read the DBD::DB2 documentation (perldoc DBD::DB2), the section "Data Source Names (DSNs)" tells you what you need to know and refers you to the proper books for additional information. Regards, Robert "TomoFujimoto" [EMAIL PROTECTED] on 05/03/2001 06:57:18 AM Please respond to

Re: DBD::Sybase: syb_do_proc_status not working?

2001-03-06 Thread Michael Peppler
Alexander Farber (EED) writes: I have a web page for deleting so-called OWNER's with the help of this stored procedure: snip if @@error != 0 or @@rowcount = 0 return -1 You should probably return a positive non-0 value. Negative values are used by Sybase (e.g. -4 is

DBI::Proxy : Win98 - Unix

2001-03-06 Thread Scott T. Hildreth
I have a couple of questions, 1) I got DBI::Proxy working on a Unix box connecting to another Unix Box, running Oracle. I had to alter Proxy.pm to get it to run. I added the following, $dsn =~ s/dbi:Proxy://i; ..when DBD::Proxy was parsing the connect string,

RE: DBI::Proxy : Win98 - Unix

2001-03-06 Thread Scott T. Hildreth
Okay, I missed the NUMEROUS archives about Storable! Version on the Win98 is 1.001 and the one on the Linux Box is 1.010. I cannot find version 1.001 to install on the Linux Box, to see if that will work. Does anyone know where to get it or should 1.001 1.010 be compatiable? On 06-Mar-01

RaiseError on and off

2001-03-06 Thread Kamp, Rolf F, ALSVC
Hi: I see the example in the Perl DBI book dealing with setting RaiseError OFF when connecting, then turning it ON in a block. I am trying to do the opposite, with no success. I connect to the database with RaiseError ON: my $dbh = DBI-connect(undef, 'login', 'passwd',

DBI-connect(dbi:Oracle SUCCESS

2001-03-06 Thread John Kolvereid
Hi all, I would like to heartly thank all of you for your assistance, esp David Davisson and Michael Chase. I am finally able to DBI connect to Oracle 8.0.5 running on Linux 2.1.14-5.0 (RedHat 6.2). In the end it was something as simple as configuring the DBI-connect statement correctly.