From owner-freebsd-gnome@FreeBSD.ORG Fri Jun 27 18:34:46 2008 Return-Path: Delivered-To: gnome@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 7A262106564A for ; Fri, 27 Jun 2008 18:34:46 +0000 (UTC) (envelope-from jklowden@freetds.org) Received: from oak.schemamania.org (dsl254-083-208.nyc1.dsl.speakeasy.net [216.254.83.208]) by mx1.freebsd.org (Postfix) with ESMTP id 34D7B8FC16 for ; Fri, 27 Jun 2008 18:34:45 +0000 (UTC) (envelope-from jklowden@freetds.org) Received: by oak.schemamania.org (Postfix, from userid 1012) id C54A150D47; Fri, 27 Jun 2008 14:16:21 -0400 (EDT) Received: from oak.schemamania.org (localhost [127.0.0.1]) by oak.schemamania.org (Postfix) with SMTP id 7A14E50A98; Fri, 27 Jun 2008 14:16:21 -0400 (EDT) Date: Fri, 27 Jun 2008 14:16:21 -0400 From: "James K. Lowden" To: FreeTDS Development Group Message-Id: <20080627141621.4e3f615f.jklowden@freetds.org> In-Reply-To: <72EBB5FADDA71343B78E1F09FF471F6E4528D5@OBOMEXO02.omnitel.it> References: <200806251750.27791.mi+mill@aldan.algebra.com> <200806260824.13215@aldan> <72EBB5FADDA71343B78E1F09FF471F6E4528D1@OBOMEXO02.omnitel.it> <200806270705.57567@aldan> <72EBB5FADDA71343B78E1F09FF471F6E4528D5@OBOMEXO02.omnitel.it> X-Mailer: Sylpheed version 1.0.4 (GTK+ 1.2.10; i386--netbsdelf) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Bogosity: No, tests=bogofilter, spamicity=0.000000, version=0.92.8 Cc: gnome@freebsd.org, ale@freebsd.org, mi+kde@aldan.algebra.com Subject: Re: [freetds] msdblib (Re: Troubles upgrading to freetds-0.82) X-BeenThere: freebsd-gnome@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: GNOME for FreeBSD -- porting and maintaining List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 27 Jun 2008 18:34:46 -0000 ZIGLIO, Frediano, VF-IT wrote: > > = Mmmm... yes, try to use version 4.2 to detect protocol > > version, however > > = every time you'll have 2 connections instead of one > > > > Strange -- does not the server identify itself at the initial > > "handshake" or > > something? Nothing similar to SMTP's "HELO", for example? > > no, initial handshake is quite different for different protocol > versions... Cf. http://www.freetds.org/tds.html#login TDS is an ancient binary protocol; my db-lib manual is copyright January 1988. Yes, RFC 821 dates from 1982, but Sybase didn't face the multiple-implementation quandry that Mr. Postel did. In fact, Microsoft only recently added a "pre-login" handshake that does approximately that. But of course only SQL Server 2008 understands it; it won't help distinquish a Sybase server from a Microsoft one, or a TDS 7.0 server from a TDS 8.0 one. I did work out a trial-and-error sequence that gets the right protocol version, but I never finished adding it to the configuration file parser and to the documentation. It's on my TODO for version 1.0. > > And the same application (or a toolkit like Sybtcl) can not > > talk to both types > > of servers /at once/, unless it is hacked to change a connection's > > settings->msdblib itself, which means, it has to be > > FreeTDS-aware, rather > > than simply use the vendor's API. Not at all. Sybase's and Microsoft's implementations of the db-lib API are *slightly* different. If you're accustomed to one or the other, you can specify through --enable-msdblib which one you want. That option does *not* affect the kind of server you can connect to. FreeTDS can connect to any TDS server, regardless of how compiled. HTH. --jkl P.S. Hey, join the list! I'm a NetBSD guy myself, but I'm more than happy to help FreeBSD ports to their thing!