Date: Fri, 10 Nov 2000 01:45:18 -0500 From: "Troy Settle" <troy@psknet.com> To: "Steve Reid" <sreid@sea-to-sky.net> Cc: "Bob Martin" <bob@inu.net>, <freebsd-isp@FreeBSD.ORG> Subject: RE: ODBC Message-ID: <FCEELIAEIIECDGKKJLMIIEHGCCAA.troy@psknet.com> In-Reply-To: <20001109210319.A25287@grok>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?FCEELIAEIIECDGKKJLMIIEHGCCAA.troy>