From owner-freebsd-isp Thu Nov 9 22:43:50 2000 Delivered-To: freebsd-isp@freebsd.org Received: from mail.psknet.com (orion.psknet.com [207.198.61.253]) by hub.freebsd.org (Postfix) with SMTP id 4112F37B479 for ; Thu, 9 Nov 2000 22:43:46 -0800 (PST) Received: (qmail 86638 invoked from network); 10 Nov 2000 06:43:42 -0000 Received: from abyss.dashit.net (HELO abyss) (209.100.22.250) by orion.psknet.com with SMTP; 10 Nov 2000 06:43:42 -0000 From: "Troy Settle" To: "Steve Reid" Cc: "Bob Martin" , Subject: RE: ODBC Date: Fri, 10 Nov 2000 01:45:18 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 In-Reply-To: <20001109210319.A25287@grok> X-AntiVirus: scanned for viruses by Pulaski Networks (http://www.psknet.com) using AMaViS (http://www.amavis.org) Sender: owner-freebsd-isp@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org Yeah, I've found a few things in FreeTDS that I've had to tip-toe around. I'm not quite sure what I'm looking at yet. It might just be me being stupid (but, the exact same queries work fine from other clients to the MSSQL database). For example, "select * from table" gives me grief when executed from PHP via FreeTDS to a MSSQL server. Haven't tracked that one down yet. I guess this is the price we pay for using software written by reverse-engineering a protocol. -- Troy Settle Pulaski Networks 540.994.4254 It's always a long day, 86400 doesn't fit into a short. ** -----Original Message----- ** From: Steve Reid [mailto:sreid@sea-to-sky.net] ** Sent: Friday, November 10, 2000 12:03 AM ** To: Troy Settle ** Cc: Bob Martin; freebsd-isp@FreeBSD.ORG ** Subject: Re: ODBC ** ** ** 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