From owner-freebsd-database Tue Jun 9 10:27:02 1998 Return-Path: Received: (from majordom@localhost) by hub.freebsd.org (8.8.8/8.8.8) id KAA17174 for freebsd-database-outgoing; Tue, 9 Jun 1998 10:27:02 -0700 (PDT) (envelope-from owner-freebsd-database@FreeBSD.ORG) Received: from bangkok.office.cdsnet.net (bangkok.office.cdsnet.net [204.118.245.23]) by hub.freebsd.org (8.8.8/8.8.8) with ESMTP id KAA17165 for ; Tue, 9 Jun 1998 10:27:00 -0700 (PDT) (envelope-from cts@bangkok.office.cdsnet.net) Received: (from cts@localhost) by bangkok.office.cdsnet.net (8.8.8/8.8.5) id KAA02592; Tue, 9 Jun 1998 10:26:34 -0700 (PDT) Date: Tue, 9 Jun 1998 10:26:34 -0700 (PDT) Message-Id: <199806091726.KAA02592@bangkok.office.cdsnet.net> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit From: Craig Spannring To: Angelo Nardone Cc: freebsd-database@FreeBSD.ORG Subject: TDDS? Was Re: SQL server, Oracle In-Reply-To: <357D2F23.33B4D6A4@adinet.com.uy> References: <357D2F23.33B4D6A4@adinet.com.uy> X-Mailer: VM 6.31 under Emacs 20.2.1 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk Angelo Nardone writes: > I need to make a query to an Oracle (NT) server, and a SQL server from a > process > runing in FreeBSD. > Do anybody know how ? I don't know about Oracle, but I have some programs running on FreeBSD that access a MS SQLServer database. Please don't judge me to harshly but what I'm doing right now is running a Java RMI server on an NT machine. The program I have on the FreeBSD side is a Java application that connects to the ODBC-JDBC bridge via the RMI server on the NT box. It ain't pretty, but it works. There are also a few companies that have JDBC drivers that can talk to SQLServer. Ideally I would like to write a library to access the SQLServer (and Sybase) via the Tabular Data Stream (TDS) protocol, but TDS is undocumented, proprietary, confidential and the people that know anything about it have been sworn to secrecy upon pain of death. I've looked at a few packet dumps of what SQLServer sends over the wire. It looks pretty simple if someone wanted to reverse engineer it. -- ======================================================================= Life is short. | Craig Spannring Ski hard, Bike fast. | cts@internetcds.com --------------------------------+------------------------------------ Any sufficiently perverted technology is indistinguishable from Perl. ======================================================================= To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message