From owner-freebsd-questions Thu Feb 25 8:45:38 1999 Delivered-To: freebsd-questions@freebsd.org Received: from mailhub.ainet.com (mailhub.ainet.com [204.30.40.29]) by hub.freebsd.org (Postfix) with ESMTP id E69B814D15 for ; Thu, 25 Feb 1999 08:45:33 -0800 (PST) (envelope-from jmscott@ainet.com) Received: from shell.ainet.com (jmscott@shell.ainet.com [204.30.40.108]) by mailhub.ainet.com (8.9.1/8.9.1) with SMTP id IAA10056; Thu, 25 Feb 1999 08:45:05 -0800 (PST) Received: from localhost by shell.ainet.com (4.1/SMI-4.1) id AA29090; for FreeBSD-Questions@FreeBSD.ORG; Thu, 25 Feb 99 08:47:41 PST Date: Thu, 25 Feb 1999 08:47:40 -0800 (PST) From: "Joseph M. Scott" To: Peter McGarvey Cc: FreeBSD Questions Subject: Re: Q: FreeBSD -> SQL Server with ODBC In-Reply-To: <000001be5fec$af1d34c0$24603fc1@brick.it-dept.rncm.ac.uk> Message-Id: Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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 I believe this will work, ( although if I recall the DBD-ODBC was still pretty early in development ) however you will still need some sort of ODBS service. > > The first installed okay, the second started moaning about driver managers > and drivers. > > I'm new-ish to FreeBSD and to unix and unfortunately I'm at the limit of my > knowlege. > > Can some kind person take pity and give me some help? Well I can try, but I haven't actually used any of these products so I can't say how well they do or don't work. First check out : http://metalab.unc.edu/freetds/ Read throught the site completely, especially the faq. I believe this will begin to point you in the right direction. Also if you are not too attached to perl you can take a look at php, which if you go through enough loops may provide you with an ability to access your MS SQL server from FreeBSD. PHP can be found at : http://www.php.net/ Their faq also has info in this regard and may prove useful, see : http://www.php.net/FAQ.php3 Again, I haven't actually used this programs in this way so this should be taken with a grain of salt :-) * Joseph M. Scott * jmscott@ainet.com * American InfoMetrics * Modesto, CA To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message