From owner-freebsd-questions@FreeBSD.ORG  Sun Jan 29 19:45:28 2006
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
X-Original-To: freebsd-questions@FreeBSD.ORG
Delivered-To: freebsd-questions@FreeBSD.ORG
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 9411716A420
	for <freebsd-questions@FreeBSD.ORG>;
	Sun, 29 Jan 2006 19:45:28 +0000 (GMT)
	(envelope-from fbsd_user@a1poweruser.com)
Received: from mta11.adelphia.net (mta11.adelphia.net [68.168.78.205])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3458843D45
	for <freebsd-questions@FreeBSD.ORG>;
	Sun, 29 Jan 2006 19:45:27 +0000 (GMT)
	(envelope-from fbsd_user@a1poweruser.com)
Received: from barbish ([69.172.31.117]) by mta11.adelphia.net
	(InterMail vM.6.01.05.02 201-2131-123-102-20050715) with SMTP
	id <20060129194526.QQQL7811.mta11.adelphia.net@barbish>
	for <freebsd-questions@FreeBSD.ORG>; Sun, 29 Jan 2006 14:45:26 -0500
From: "fbsd_user" <fbsd_user@a1poweruser.com>
To: "freebsd-questions@FreeBSD. ORG" <freebsd-questions@FreeBSD.ORG>
Date: Sun, 29 Jan 2006 14:45:22 -0500
Message-ID: <MIEPLLIBMLEEABPDBIEGAEFEHMAA.fbsd_user@a1poweruser.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0)
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
Importance: Normal
Cc: 
Subject: mysql & unixodbc
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
Reply-To: fbsd_user@a1poweruser.com
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sun, 29 Jan 2006 19:45:28 -0000

I installed unixodbc & mysql2odbc from the ports system.

The /usr/local/etc files odbc.ini & odbcinst.ini were empty.

A mysql reference says odbcinst.ini should look like this

[MySQL]
Description       = MySQL Driver
Driver            = /usr/local/lib/libmyodbc.so
Setup             = /usr/local/lib/libodbcmyS.so
FileUsage         = 1

Problem is locate does not find any libmyo* files any where on my
system.

Reviewing the mysql2odbc install log I see these files were added.

/usr/local/mysql2odbc/libmysqlclient.a
/usr/local/mysql2odbc/libmysqlclient.la
/usr/local/mysql2odbc/libmysqlclient.so
/usr/local/mysql2odbc/libmysqlclient.so.10

Are these my mysql driver files or what?
If so which ones do I use for driver and setup?
Have I selected the wrong ports to install?

Thanks