Can you recomend a DBMS?

2001-03-05 Thread Barry Jeapes
Hi All, Im in the very early stages of developing an intranet website where I have scope to choose which DBMS software I want to install and use. Since this is a new area of web development for me I have little/no experience of which DBMS' are good and bad. Of course I could just try a few,

RE: Can you recomend a DBMS?

2001-03-05 Thread Joe Chernysh
Barry, Technologically, Oracle would be a good choice. It is pretty costly, though. Joe. -Original Message- From: Barry Jeapes [mailto:[EMAIL PROTECTED]] Sent: Monday, March 05, 2001 6:22 AM To: [EMAIL PROTECTED] Subject: Can you recomend a DBMS? Hi All, Im in the very

Re: Can you recomend a DBMS?

2001-03-05 Thread Simon Oliver
Hardy Merrill wrote: Consider * MySQL(www.mysql.com) * PostgreSQL(postgresql.readysetnet.com) And make yourself aware of their limitations such as lack of transactions in MySQL, blobs, tuple size, etc. -- Simon Oliver

Re: Can you recomend a DBMS?

2001-03-05 Thread Peter J . Holzer
On 2001-03-05 14:16:03 +, Simon Oliver wrote: Hardy Merrill wrote: Consider * MySQL(www.mysql.com) * PostgreSQL(postgresql.readysetnet.com) And make yourself aware of their limitations such as lack of transactions in MySQL, blobs, tuple size, etc. MySQL has transactions in

RE: Oracle 8 objects....

2001-03-05 Thread David M. Davisson
Lars, I have built several Oracle objects and thoroughly tested them with DBI. So I am sure that the Perl DBI mechanism works with them. However the biggest issue that I have with Oracle objects is data integrity. Column level nullability is not a guarantee that the object is fully populated.

Re: Can you recomend a DBMS?

2001-03-05 Thread Corey D. Herbel
To piggy back on what Steve said, I would add, where is the current level of DB experience in the organization. If everyone is familiar w/ Sybase and you have a Sybase DBA then why would you use Oracle? The point is unless your requirements are specialized, each DB has pluses and minuses, you

DBD::Oracle on HPUX

2001-03-05 Thread Bowman, Brent A
With the help of many of you, I've been able to get this far. I have had difficulty installing the DBD::Oracle module on the following system for the past couple months. I believe that my problem was with Oracle 8.1.7 because I have just gotten much further when I tried it with 8.1.6. My

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

2001-03-05 Thread Tim Bunce
- Forwarded message from Luis Colon [EMAIL PROTECTED] - Date: Mon, 5 Mar 2001 07:44:29 -0800 (PST) From: Luis Colon [EMAIL PROTECTED] Subject: "Can't call method execute" error "undefined value" To: [EMAIL PROTECTED] Please assist: I'm trying to create an interactive HTML that will Post

RE: DB2 connection release level not support error

2001-03-05 Thread Warden, Ronald MCF:EX
Robert, Thanks for the update. Since I have no control over the mainframe I am going to have to try an downgrade my client side. The mainframe is running DB2/MVS 5.1, my client is UDB DB2 V7.1. Is there any client libraries for anything that will let me compile DBD::DB2 so I could access the

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

2001-03-05 Thread Luis Colon
Here is the code in question: #!/usr/local/bin/perl use DBI; parse; connect; sub parse { (parses data code) } sub connect { $host = "$nameofmyserver"; $sid = "$sid"; $user = "lcolon"; $password = "time2fly"; $|=1; BEGIN { $ENV{ORACLE_HOME} = "/apps/oracle/product/8.1.6";

RE: DB2 connection release level not support error

2001-03-05 Thread db2perl
Hi Ronald. As I said, the DBD::DB2 version has nothing to do with your problem so I don't understand what kind of a map you're requesting. The version that the message is referring to is the DB2 client version not the DBD::DB2 version. DBD::DB2 works with any DB2 client from v5.2 onward.

How to?

2001-03-05 Thread Nguyen, David M
Hi all, I am tasked to design a database so people can open a ticket, modify/close as need. Does someone ever do this with DBI and Oracle database? Is there any good resource I can go for demo? Thanks, David

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

2001-03-05 Thread Ian Macdonald
I think the problem is that the connect method failed. Use the double pipe || version of the 'or' operator instead of the word 'or' here: $dbh= DBI-connect("DBI:Oracle:host=$host;sid=$sid;port=1521",$user, $password) -- || die "Can't connect:$DBI::errstr\n"; (If you use 'or' perl is

Re: How can i execute a Oracle function from Perl code.

2001-03-05 Thread Mark Vandenbroeck
This is explained very well in the DBD::Oracle documentation, complete with examples. If you installed DBD::Oracle, you have this documentation. Just type 'man DBD::Oracle'. Otherwise, you can download it form www.cpan.org. Mark - Original Message - From: "I.Sals - Listn.com" [EMAIL

DB2 server Connection from WEB server

2001-03-05 Thread TomoFujimoto
Hi, all I have a question about how to connect from perl-CGI program on a WEB server to a DB2 on another server. I really use a DBD::DB2 module to develop some program to a local DB2 in a same BOX(machine). However, I have no Idea which I should use DBD::? on a separate server environment, what

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

2001-03-05 Thread Bodo Eing
Date sent: Mon, 5 Mar 2001 10:04:44 -0800 (PST) From: Luis Colon [EMAIL PROTECTED] Subject:Re: (Fwd) "Can't call method execute" error "undefined value" To: Bodo Eing [EMAIL PROTECTED], [EMAIL PROTECTED] Hi Luis, meanwhile there