From owner-freebsd-database@FreeBSD.ORG  Sat Jul 29 11:40:15 2006
Return-Path: <owner-freebsd-database@FreeBSD.ORG>
X-Original-To: freebsd-database@freebsd.org
Delivered-To: freebsd-database@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 7099F16A4DD
	for <freebsd-database@freebsd.org>;
	Sat, 29 Jul 2006 11:40:15 +0000 (UTC)
	(envelope-from mark@sauerpuss.net)
Received: from 10base-t.com (qtss.10base-t.com [216.254.71.80])
	by mx1.FreeBSD.org (Postfix) with ESMTP id F401243D53
	for <freebsd-database@freebsd.org>;
	Sat, 29 Jul 2006 11:40:14 +0000 (GMT)
	(envelope-from mark@sauerpuss.net)
Received: from localhost (localhost [127.0.0.1])
	by 10base-t.com (Postfix) with ESMTP id E280318EFFBB
	for <freebsd-database@freebsd.org>;
	Sat, 29 Jul 2006 07:40:13 -0400 (EDT)
Received: from 10base-t.com ([127.0.0.1])
	by localhost (10base-t.com [127.0.0.1]) (amavisd-new,
	port 10024) with ESMTP
	id 29403-08 for <freebsd-database@freebsd.org>;
	Sat, 29 Jul 2006 07:39:59 -0400 (EDT)
Received: from [192.168.1.106] (cpe-72-229-166-64.nyc.res.rr.com
	[72.229.166.64]) by 10base-t.com (Postfix) with ESMTP id 14CD018EFF94
	for <freebsd-database@freebsd.org>;
	Sat, 29 Jul 2006 07:39:57 -0400 (EDT)
Mime-Version: 1.0 (Apple Message framework v752.2)
To: freebsd-database@freebsd.org
Message-Id: <96859CA7-B439-4743-A0BB-3920529CD827@sauerpuss.net>
From: Mark McCray <mark@sauerpuss.net>
Date: Sat, 29 Jul 2006 07:40:01 -0400
X-Mailer: Apple Mail (2.752.2)
X-Virus-Scanned: by amavisd-new at 10base-t.com
Content-Type: text/plain;
	charset=US-ASCII;
	delsp=yes;
	format=flowed
Content-Transfer-Encoding: 7bit
X-Content-Filtered-By: Mailman/MimeDel 2.1.5
Subject: question about oracle and odbc
X-BeenThere: freebsd-database@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: Database use and development under FreeBSD
	<freebsd-database.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-database>
List-Post: <mailto:freebsd-database@freebsd.org>
List-Help: <mailto:freebsd-database-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-database>, 
	<mailto:freebsd-database-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 29 Jul 2006 11:40:15 -0000

Hello,
I'm trying to connect my freebsd machine to oracle via odbc (I'm  
using this in PHP.)

I've got iODBC reading my odbc.ini and odbcinst.ini files ok. But  
it's saying that:
[iODBC][Driver Manager]Specified driver could not be loaded,

I've checked the iODBC website and followed some hints there. The  
permissions seem to be correct.

My odbc.ini file is:
[Pirate]
Driver      = Oracle
Description = Pirate via Oracle
Server      = 10.10.2.131
Database    = PPIRATE
Port        = 1526

My odbcinst.ini file is:
[Oracle]
Driver = /usr/local/lib/liboraodbcS.so


Am I not using the right driver?

Any help would be appreciated.
Thanks,
Mark