From owner-freebsd-questions@FreeBSD.ORG Tue Jul 22 11:15:22 2003 Return-Path: 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 1B78E37B401 for ; Tue, 22 Jul 2003 11:15:22 -0700 (PDT) Received: from mail3.panix.com (mail3.panix.com [166.84.1.74]) by mx1.FreeBSD.org (Postfix) with ESMTP id 3023443F3F for ; Tue, 22 Jul 2003 11:15:21 -0700 (PDT) (envelope-from stanb@panix.com) Received: from panix.com (brillig.panix.com [166.84.1.76]) by mail3.panix.com (Postfix) with ESMTP id 71B3F9823F for ; Tue, 22 Jul 2003 14:15:20 -0400 (EDT) Received: from teddy.fas.com (pcp01010374pcs.mplsnt01.sc.comcast.net [68.58.176.69]) by panix.com (Postfix) with ESMTP id 3F6AB2AA3D for ; Tue, 22 Jul 2003 14:15:20 -0400 (EDT) Received: from stan by teddy.fas.com with local (Exim 3.36 #1 (Debian)) id 19f1fT-0003mc-00; Tue, 22 Jul 2003 14:15:19 -0400 Date: Tue, 22 Jul 2003 14:15:19 -0400 From: stan To: Free BSD Questions list Cc: Free BSD Questions list Message-ID: <20030722181519.GA14476@teddy.fas.com> Mail-Followup-To: Free BSD Questions list References: <20030721154725.GA17079@teddy.fas.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030721154725.GA17079@teddy.fas.com> X-Editor: gVim X-Operating-System: Debian GNU/Linux X-Kernel-Version: 2.4.21 X-Uptime: 14:10:35 up 36 days, 1:13, 2 users, load average: 0.03, 0.02, 0.00 User-Agent: Mutt/1.5.4i Sender: Stan Brown Subject: Re: Need example of accessing MS Access via perl on FreeBSD X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 22 Jul 2003 18:15:22 -0000 On Mon, Jul 21, 2003 at 11:47:25AM -0400, stan wrote: > I need to get some information that is stored on a windows amchine, in an > Access "database" via a perl script with FreeBSD. > > I'v installed teh DBI::ODBC port. I've alos got working code that accesses > a remote Oracle instance using Perl's DBD::Oracle. I've got access to a > person who has admin access on the remote windows box, but is not really > understanding what I'm trying to do. > > A sample snipet of working code would be a wonderful thing. > > Can anyone help? > > It _appears_ that in addition to DBD and DBI::Oralce, I may need a "ODBC > manager", and an "ODB driver". Is this correct? If so where can I get them? > I thought I'd follow up with a bit more progress on this, in the hpe that some helpful soul will come to my aid. I found thta id I run iodbc-odbctest _as root_ it does not exit imediatl. I still don;t know why this is, but for the moent I thoguht I'd plunge ahead. So my odbc.ini file _now looks like this: ; ; odbc.ini ; [ODBC Data Sources] OpenLink = OpenLink (MT) Test = Test [OpenLink] Driver = /usr/local/lib/libiodbc.so Description = Sample OpenLink MT DSN Host = localhost ServerType = Oracle 8 FetchBufferSize = 99 UserName = Password = Database = ServerOptions = ConnectOptions = Options = ReadOnly = no [Test] Driver = /usr/local/lib/libiodbc.so Description = Test Host = localhost Server = xxx.xxx.xxx.xx ServerType = Odbc DataBase = AlarmHist062203 UserName = Password = Database = ServerOptions = ConnectOptions = Options = ReadOnly = no [Default] Driver = /usr/local/lib/libiodbc.so Obviouslu with a real IP address. Now her's what I get: pm1al# iodbc-odbctest iODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): ? DSN | Description --------------------------------------------------------------- OpenLink | OpenLink (MT) Test | Test Enter ODBC connect string (? shows list): Test [iODBC][Driver Manager]Dialog failed, SQLSTATE=IM008 So what am I doing wrong here? -- "They that would give up essential liberty for temporary safety deserve neither liberty nor safety." -- Benjamin Franklin