Date: Sat, 8 Apr 2000 10:51:55 -0700 (PDT) From: Tom <tom@sdf.com> To: Richard Grace <rgrace@itworks.com.au> Cc: database@FreeBSD.org Subject: Re: MS SQL and ODBC drivers Message-ID: <Pine.BSF.4.05.10004081049060.7244-100000@misery.sdf.com> In-Reply-To: <NDBBILBEBIHJBLOEIKKCAEKGCCAA.rgrace@itworks.com.au>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?Pine.BSF.4.05.10004081049060.7244-100000>