From owner-freebsd-database Sat Apr 8 10:56:42 2000 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id 0E0BC37B59E for ; Sat, 8 Apr 2000 10:56:32 -0700 (PDT) (envelope-from tom@sdf.com) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 12dzOn-0005o9-00; Sat, 8 Apr 2000 10:51:57 -0700 Date: Sat, 8 Apr 2000 10:51:55 -0700 (PDT) From: Tom To: Richard Grace Cc: database@FreeBSD.org Subject: Re: MS SQL and ODBC drivers In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Fri, 7 Apr 2000, Richard Grace wrote: > I'm trying to find out if there are any MS SQL ODBC drivers for FreeBSD. > > So far I've installed the iODBC driver manager, but it seems there is no > driver to support connection to a MS SQL server by ODBC. iODBC is just a manager, it includes no drivers. > Ideally I would like to be able to test the connectivity before we commit to > buy any particular product, as we are not sure this is the best way to > implement things. > > The application is a web page, running Java servlets with ODBC connection to > the database. The database must be a MS SQL server running ODBC, but I'd > also welcome any suggestions regarding other (cheap) ways to connect to MS > SQL from a Java servlet, or anything else which can be generated from an ASP > development. Since the product is Java, you probably want to stay away from ODBC. ODBC will require the JDBC to ODBC bridge. You don't want to use the bridge if you don't have to do. Instead get a type 4 (all Java) JDBC driver. The FreeTDS driver JDBC driver is ok (www.freetds.org) for everything I've thrown at it. There are several other venders with type 4 JDBC drivers for MS-SQL. Since they are type 4, they work on all OSes. > The web stuff is being developed in ASP but can be converted to another > format if required (has already been converted to Java servlets for > testing). > > Thanks, > > Richard Grace > > ITworks Consulting Pty. Ltd. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message