From owner-freebsd-database Tue Aug 22 21:33:40 2000 Delivered-To: freebsd-database@freebsd.org Received: from server.bitmcnit.bryansk.su (bitmcnit.bryansk.ru [195.239.213.9]) by hub.freebsd.org (Postfix) with ESMTP id 61D0437B423 for ; Tue, 22 Aug 2000 21:33:28 -0700 (PDT) Received: (from uucp@localhost) by server.bitmcnit.bryansk.su (8.9.3/8.9.3) with UUCP id IAA05762; Wed, 23 Aug 2000 08:15:44 +0400 Received: (from alex@localhost) by kapran.bitmcnit.bryansk.su (8.9.3/8.9.3) id WAA01148; Tue, 22 Aug 2000 22:54:54 +0400 (MSD) (envelope-from alex@kapran.bitmcnit.bryansk.su) X-Authentication-Warning: kapran.bitmcnit.bryansk.su: alex set sender to alex@kapran.bitmcnit.bryansk.su using -f Date: Tue, 22 Aug 2000 22:54:53 +0400 From: Alex Kapranoff To: Tom Samplonius Cc: "Sergey A. Ivanov" , freebsd-database@FreeBSD.ORG Subject: Re: =?us-ascii?Q?linuxOracle+DBI+DBD::Oracle_=3D=3F?= Message-ID: <20000822225453.A357@kapran.bitmcnit.bryansk.su> References: <7892914098.20000822143852@pd.chel.ru> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2i In-Reply-To: ; from tom@sdf.com on Tue, Aug 22, 2000 at 09:06:24AM -0700 X-Operating-System: FreeBSD 5.0-CURRENT i386 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Tue, Aug 22, 2000 at 09:06:24AM -0700, Tom Samplonius wrote: > > Is there any how-to connect to remote Oracle server from FreeBSD using Perl > > with modules? > > Now i have installed ports/emulators/linux-base, ports/devel/linux_devtools > > as described in handbook (ch.23.4), Oracle 8.0.5.0.0 for linux (client and > > Pro*C), ports/databases/DBI, and trying to install DBD::Oracle by hands: > > perl Makefile.PL - ok > > make - ok > > make test - fail with diagnostics: > > You will not be able to link the Linux Oracle client into a FreeBSD perl > binary. The emulation system can not handle this, and it is one of the > reasons why native Oracle client libs would be much appreciated on > FreeBSD. We managed to handle this situation in our pure FreeBSD shop. What we have is an Oracle 8.0.5 EE running ALONG with a Linux perl (installed from a binary rpm taken from RedHat ftp) which is used to run dbiproxy(1). This very perl (situated of course under /compat/linux) has a DBD::Oracle installed. So we now connect to our brand Oracle database server from all FreeBSD boxen via DBI->connect('DBI:Proxy:host=xxx;port=3334;dsn=DBI:Oracle:....) without even bothering about some obscure sets of Oracle client libraries. This works only for perl connectivity due to a brilliant DBI::ProxyServer+DBD::Proxy interface by Jochen Wiedmann. -- Alex Kapranoff, Voice: +7(0832)791845. 131 days till brand new millenium... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message