From owner-freebsd-database Thu Apr 6 21:30:13 2000 Delivered-To: freebsd-database@freebsd.org Received: from iserver.itworks.com.au (iserver.itworks.com.au [203.32.61.10]) by hub.freebsd.org (Postfix) with SMTP id 4ED2B37B62A for ; Thu, 6 Apr 2000 21:30:03 -0700 (PDT) (envelope-from rgrace@itworks.com.au) Received: (qmail 47801 invoked from network); 7 Apr 2000 04:29:50 -0000 Received: from maybe.itworks.com.au (203.36.209.235) by iserver.itworks.com.au with SMTP; 7 Apr 2000 04:29:50 -0000 Received: (qmail 61955 invoked from network); 7 Apr 2000 04:29:50 -0000 Received: from dhcp8.itworks.com.au (HELO paranoia) (203.36.209.217) by maybe.itworks.com.au with SMTP; 7 Apr 2000 04:29:50 -0000 From: "Richard Grace" To: Subject: MS SQL and ODBC drivers Date: Fri, 7 Apr 2000 14:30:23 +1000 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) In-Reply-To: <20000407013116.96135.qmail@hotmail.com> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Importance: Normal Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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. 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. 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. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Apr 6 23:18:33 2000 Delivered-To: freebsd-database@freebsd.org Received: from ns1.aktrad.ru (ns1.aktrad.ru [195.218.140.4]) by hub.freebsd.org (Postfix) with ESMTP id 5235337C2AC for ; Thu, 6 Apr 2000 23:18:11 -0700 (PDT) (envelope-from hook@aktrad.ru) Received: from sloth (sloth.aktrad.ru [195.218.140.13]) by ns1.aktrad.ru (8.9.3/8.9.3) with SMTP id KAA03742 for ; Fri, 7 Apr 2000 10:18:06 +0400 (MSD) Message-ID: <11ff01bfa059$0bf2fab0$0d8cdac3@aktrad.ru> From: "Gene Sokolov" To: References: Subject: Re: MS SQL and ODBC drivers Date: Fri, 7 Apr 2000 10:18:09 +0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG http://www.freetds.org From: "Richard Grace" > I'm trying to find out if there are any MS SQL ODBC drivers for FreeBSD. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Apr 7 4:50:19 2000 Delivered-To: freebsd-database@freebsd.org Received: from news.IAEhv.nl (news.IAE.nl [194.151.64.4]) by hub.freebsd.org (Postfix) with ESMTP id B5E3537B8D2 for ; Fri, 7 Apr 2000 04:50:16 -0700 (PDT) (envelope-from marc@bowtie.nl) Received: (from uucp@localhost) by news.IAEhv.nl (8.9.1/8.9.1) with IAEhv.nl id NAA10991; Fri, 7 Apr 2000 13:50:06 +0200 (MET DST) Received: from localhost (localhost [127.0.0.1]) by bowtie.nl (8.8.8/8.8.8) with ESMTP id NAA00577; Fri, 7 Apr 2000 13:49:29 +0200 (CEST) (envelope-from marc@bowtie.nl) Message-Id: <200004071149.NAA00577@bowtie.nl> X-Mailer: exmh version 2.1.1 10/15/1999 To: "Richard Grace" Cc: database@freebsd.org Subject: Re: MS SQL and ODBC drivers In-reply-to: rgrace's message of Fri, 07 Apr 2000 14:30:23 +1000. Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Date: Fri, 07 Apr 2000 13:49:29 +0200 From: Marc van Kempen Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG > 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. > > 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. > Why don't you use JDBC? Marc. -- ---------------------------------------------------- Marc van Kempen BowTie Technology Email: marc@bowtie.nl WWW & Databases tel. +31 40 2 43 20 65 fax. +31 40 2 44 21 86 http://www.bowtie.nl ---------------------------------------------------- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message 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 From owner-freebsd-database Sat Apr 8 16:11:37 2000 Delivered-To: freebsd-database@freebsd.org Received: from game.over.net (game.over.net [193.189.189.100]) by hub.freebsd.org (Postfix) with ESMTP id 0E06E37B58D for ; Sat, 8 Apr 2000 16:11:35 -0700 (PDT) (envelope-from tomaz.borstnar@over.net) Received: from [212.30.93.57] ([212.30.93.57]:11818 "EHLO user.over.net") by mail.over.net with ESMTP id ; Sun, 9 Apr 2000 01:11:15 +0200 Message-Id: <4.3.1.2.20000409000941.0543dbe0@193.189.189.100> X-Sender: tmail@193.189.189.100 X-Mailer: QUALCOMM Windows Eudora Version 4.3.1 Date: Sun, 09 Apr 2000 00:13:25 -0100 To: "Richard Grace" From: Tomaz Borstnar Subject: Re: MS SQL and ODBC drivers Cc: In-Reply-To: References: <20000407013116.96135.qmail@hotmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG At 03:30 AM 07/04/00, Richard Grace wrote the following message: >I'm trying to find out if there are any MS SQL ODBC drivers for FreeBSD. http://www.easysoft.com/ There you have ODBC-ODBC bridge and JDBC-ODBC bridge. 3-client license is free even for commercial use. Works great. Tomaz ---- Tomaz Borstnar "Love is the answer to the final question you ask" - Unknown To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message