To clarify - connecting 'internally' (ie, forcing users to provide username & passwords on the GUI ) is not an option - all connections must be 'external'.
-------- Forwarded Message -------- From: jeff <j...@roqc.no> To: dbi-users@perl.org <dbi-users@perl.org> Subject: Looking for clever solution: Different versions of Oracle .so files within single Perl build Date: Mon, 14 Dec 2009 07:18:41 -0500 I need to connect simultaneously to both Oracle 8 and oracle 10 from the same script using 'external' connection (ie, no username or password). The Oracle libraries, from my experimentations, are not compatible for external connections. Oracle 8 uses system ID and Oracle 10 uses wallet and they do not overlap. I need to stress that this is NOT an option. I have no say in this regardless of how insecure it may sound. Anyway, since Oracle DBD can only be built against 1 at a time , this presents a problem. I have been trying to use DBI Proxy in a PAR standalone for Oracle 8 connections and the usual setup for Oracle 10 connections with some limited success. What would be ideal would be to have 2 different Oracle DBD connections from within the same perl build. Any suggestions or ideas for potential solutions out there ? Thanks. Jeff
