From owner-freebsd-isp Thu Nov 9 21: 3:26 2000 Delivered-To: freebsd-isp@freebsd.org Received: from grok.example.net (cr479972-a.rct1.bc.wave.home.com [24.113.37.168]) by hub.freebsd.org (Postfix) with ESMTP id 5497D37B479 for ; Thu, 9 Nov 2000 21:03:24 -0800 (PST) Received: by grok.example.net (Postfix, from userid 1000) id A7C80212EA9; Thu, 9 Nov 2000 21:03:19 -0800 (PST) Date: Thu, 9 Nov 2000 21:03:19 -0800 From: Steve Reid To: Troy Settle Cc: Bob Martin , freebsd-isp@FreeBSD.ORG Subject: Re: ODBC Message-ID: <20001109210319.A25287@grok> References: <3A082566.A2E6E2BB@inu.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.4i In-Reply-To: ; from Troy Settle on Wed, Nov 08, 2000 at 09:02:20AM -0500 Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org On Wed, Nov 08, 2000 at 09:02:20AM -0500, Troy Settle wrote: > It's not ODBC, but FreeTDS works great against MSSQL7. [snip] > For perl, I don't know for sure, but I think the DBI module will give > you access to MSSQL. I'm currently using FreeTDS with DBD::Sybase to connect to an MS-SQL server (don't know or care what version). I had some problems getting DBD::Sybase working initially. First I had to do some massaging to get it to compile (something related to perl internals; I don't recall details). Once compiled it gave "can't assign requested address" or something trying to connect to the database (it was looking for the "interfaces" config file in the wrong location (thank the gods for ktrace)). It's working fine for me now. However, I've noticed some superfluous \0 bytes in database responses that need to be filtered out. Nuking \0 is a good idea anyway (see Phrack #55). To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-isp" in the body of the message