Date: Fri, 26 Feb 1999 21:45:52 +1100 (EDT) From: Andrew MacIntyre <andymac@bullseye.apana.org.au> To: Peter McGarvey <Networks.Manager@rncm.ac.uk> Cc: FreeBSD Questions <FreeBSD-Questions@FreeBSD.ORG> Subject: Re: Q: FreeBSD -> SQL Server with ODBC Message-ID: <Pine.OS2.3.95.990226210840.190B-100000@CENTRAL> In-Reply-To: <000001be5fec$af1d34c0$24603fc1@brick.it-dept.rncm.ac.uk>
next in thread | previous in thread | raw e-mail | index | archive | help
On Wed, 24 Feb 1999, Peter McGarvey wrote: {...} > We also have another NT machine running SQL Server. The current WebServer > is able to query the SQL server via ODBC using a perl module (WIN32::ODBC). > So, I need to access the SQL Server in a similar manner. I did some looking > around and came to the conclusion that ODBC on FreeBSD was indeed possible. > Having previously installed Perl5, I downloaded and attempted to install the > following perl modules: > > DBI-1.06.tar.gz > DBD-ODBC-0.20.tar.gz > > The first installed okay, the second started moaning about driver managers > and drivers. This may not help you, but if not it may help someone else.... OpenLink Software (sorry can't give you the URL - its at work :-( ) has commercial ODBC support for all sorts of RDBMS servers, although no specific support yet for FreeBSD (coming IIRC from their website). They are also hosting the ongoing development of the iODBC open source ODBC driver manager. I have succeeded in getting a demo version of their software working in the following configuration: client: SQL test program from iODBC linked against the OpenLink MultiTier ODBC driver on a FreeBSD 2.2.7 system. server: OpenLink MultiTier network communication daemon linked against CA-Ingres 6.4 on a Solaris 2.4 system. I was able to create tables, insert rows, select, and drop tables (with appropriate login on Ingres server of course). I have also managed to link this driver into an Apache-PHP web server, although I've not yet confirmed that this is functional. In order to get this to work: - I used the BSDI 2.1 OpenLink client kit. - I dropped the iODBC library from the equation altogether, and created symlinks from the OpenLink libraries to simulate the iODBC libraries. This means I can only use the OpenLink MultiTier driver (adequate for my purposes), and I think I have to fully specify the connection details, rather than naming a DSN in an ODBC.INI file (again not a major drama for me at the moment). As another possibility to research - I seem to recall hearing of a Sybase client library for Linux which may/may not work against MS SQL Server (which is essentially Sybase). If this were the case, you might be able to use a Linux version of Perl (+extensions as you've mentioned) with this library under Linux emulation. -- Andrew I MacIntyre "These thoughts are mine alone..." E-mail: andrew.macintyre@aba.gov.au (work) | Snail: PO Box 370 andymac@bullseye.apana.org.au (play) | Belconnen ACT 2616 Fido: Andrew MacIntyre, 3:620/243.18 | Australia To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.OS2.3.95.990226210840.190B-100000>