From owner-freebsd-gnome@FreeBSD.ORG Fri Jun 27 11:06:06 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 A567E1065672; Fri, 27 Jun 2008 11:06:06 +0000 (UTC) (envelope-from mi+kde@aldan.algebra.com) Received: from aldan.algebra.com (aldan.algebra.com [216.254.65.224]) by mx1.freebsd.org (Postfix) with ESMTP id 22D298FC15; Fri, 27 Jun 2008 11:06:04 +0000 (UTC) (envelope-from mi+kde@aldan.algebra.com) Received: from aldan.algebra.com (localhost [127.0.0.1]) by aldan.algebra.com (8.14.2/8.14.1) with ESMTP id m5RB5x8Y011035 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 27 Jun 2008 07:05:59 -0400 (EDT) (envelope-from mi+kde@aldan.algebra.com) Received: from localhost (localhost [[UNIX: localhost]]) by aldan.algebra.com (8.14.2/8.14.1/Submit) id m5RB5vX1011034; Fri, 27 Jun 2008 07:05:57 -0400 (EDT) (envelope-from mi+kde@aldan.algebra.com) From: Mikhail Teterin To: "ZIGLIO, Frediano, VF-IT" Date: Fri, 27 Jun 2008 07:05:56 -0400 User-Agent: KMail/1.9.9 References: <200806251750.27791.mi+mill@aldan.algebra.com> <200806260824.13215@aldan> <72EBB5FADDA71343B78E1F09FF471F6E4528D1@OBOMEXO02.omnitel.it> In-Reply-To: <72EBB5FADDA71343B78E1F09FF471F6E4528D1@OBOMEXO02.omnitel.it> X-Face: %UW#n0|w>ydeGt/b@1-.UFP=K^~-:0f#O:D7whJ5G_<5143Bb3kOIs9XpX+"V+~$adGP:J|SLieM31VIhqXeLBli" Cc: gnome@freebsd.org, freetds@lists.ibiblio.org, ale@freebsd.org Subject: 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 11:06:06 -0000 = > http://www.freshports.org/databases/libgda3-freetds = > http://www.freshports.org/databases/php5-sybase_ct = I don't understand these pages... are there some kind of automatic = build system?? Yes, all software ported to FreeBSD is periodically autobuilt, so as to verify "buildability" and provide fresh binary packages to users. There is a freshports-page for ever port, showing the port's history, dependencies (such as on freetds) and other details. = > So, will there be a 0.83 sime time soon? = no, a 0.82.1 probably Ok, awaiting :-) = 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? = Mmm.... I think you are confusing server with client needs... msdblib means = that client wants some msdblib thing, not that you are connecting to = mssql... Yes, I may well be confusing things. My information comes from simply searching through the freetds code looking for what exactly is affected by specifying the --enable-msdblib configure-flag. The only thing I found is the default value of msdblib-field a DBPROCESS struct (tds_dblib_dbprocess). It appears to me, that in order for a freetds-build configured with the msdblib-flag to be usable against a Sybase server the application needs to change the connection's setting explicitly at run-time. What I'd like to be possible is for the same application (or a higher-level toolkit such as Sybtcl) using the same FreeTDS-library to be usable against servers of different types... In addition to automatically figuring out the actual server's type, the fields of dbdaterec need to be aliased... For example, where I work, I have to connect to a SQL Server for some data and to a Sybase for other. I'd rather implement that in TCL, but I can't mix server-types in Sybtcl due to this problem and so am forced to use Java... Bottom line: I'd like the "--enable-msdblib" to turn from a build-time to a run-time (per connection) option. Preferably -- autoinitialized based on the type of the server as detected during establishment of each connection. There are plenty of heterogenious environments and having to decide (per computer), whether to enable only Sybase or only MS SQL connectivity at build-time is too restricting... Yours, -mi