Jim, ODBC is not the way to go for Oracle if you can. Early on I tried using ODBC and I had crashes and hang-ups. Performance is substantially better also. The modules below and the oci libraries in the Oracle install will get it for you. This version works with the 9i Release 2 for me.
DBD-Oracle-1.12.tar.gz DBI-1.32.tar.gz Using separate boxes works fine. Chuck -----Original Message----- From: Jim Morrison [Mailing-Lists] [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 25, 2003 10:13 AM To: [EMAIL PROTECTED] Subject: Oracle9.2 and mod_perl - advice sought Hello all, Quick request for advice/direction... I'm about to take receipt of an Oracle 9.2 server - for the development of a site/product/service.. I'm happiest writing Perl - under mod_perl - so I'd like to stick to that, but most importantly I need the solution with the lowest transaction overheads.. (The webserver and OracleDB are going to be on different boxes..) I'm told the best solution is to use SQLNet(?) rather than ODBC.. ?? I've managed to get my XML'ing to a level that allows me to avoid databases thus far ;-) So I have little experience of what the best direction is... Any recommendations of modules, other lists etc.. would be very much appreciated.. Thank you kindly :-) Jimbo