From owner-freebsd-database Tue Nov 17 19:05:59 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id TAA07451 for freebsd-database-outgoing; Tue, 17 Nov 1998 19:05:59 -0800 (PST) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (8.8.8/8.8.8) with SMTP id TAA07446 for ; Tue, 17 Nov 1998 19:05:57 -0800 (PST) (envelope-from tom@sdf.com) Received: from tom by misery.sdf.com with esmtp (Exim 1.82 #3) id 0zfx4K-0006A5-00; Tue, 17 Nov 1998 18:10:08 -0800 Date: Tue, 17 Nov 1998 18:10:06 -0800 (PST) From: Tom To: John Fieber cc: Palle Girgensohn , freebsd-database@FreeBSD.ORG Subject: Re: Accessing Sybase/NT from FreeBSD In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk On Tue, 17 Nov 1998, John Fieber wrote: > On Wed, 18 Nov 1998, Palle Girgensohn wrote: > > > running on an NT server, from FreeBSD. We have some programs running on > > FreeBSD, and will write some more, that would wan't to access Sybase > > using an SQL library somehow, sort of like libpq for Postgres. > > I gather there is a free clone of one of the sybase client > libraries floating around somewhere. I believe I saw it in > reference to sqsh (an isql replacement). The linux sybase client > stuff works fine on FreeBSD (modulo licensing issues) but you > would have to setup and use a linux development environment to > write your own stuff. I would use the Openlink Software's ODBC broker from www.openlinksw.com It is free for a 2 user/10 connection system. Basically, you run the broker on any platform that you do have an ODBC driver (probably your NT server), then use the Openlink ODBC driver to talk to the Broker, which translates to the Sybase ODBC. I've got this working for a MS-SQL server. However, you need to use the BSDI 2.1 ODBC drivers, and the dynamic one does not work (*.so). The static works library ok (*.a). This is fine for stuff like PHP and other C programs with ODBC calls, that don't care about static vs. dynamic. Perl is a bit of a problem, because it wants to dynamic load everything at runtime. I'm working on building a static perl with the Openlink ODBC driver builtin. > -john Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message