Skip to Content.
Sympa Menu

freetds - Re: SELECT problem with MSSQL 2000

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Bob Kline <bkline AT rksystems.com>
  • To: TDS Development Group <freetds AT franklin.metalab.unc.edu>
  • Subject: Re: SELECT problem with MSSQL 2000
  • Date: Wed, 15 May 2002 10:13:02 -0400 (EDT)


On Wed, 15 May 2002, Marco wrote:

> I'll be very thankful to everyon could help me.
>
> I have FreeTDS v0.53 installed on a SPARC with linux. I use it to
> connect throught APACHE-1.3.24 and PHP 4.2.0 to a MSSQL 2000 Server.
> I need to connect to the system table on MSSQL, but strange things
> happen:
>
> SELECT constid FROM sysreferences -> works
> SELECT rkeyid FROM sysreferences -> works
> SELECT fkeyid FROM sysreferences -> works
> SELECT constid,rkeyid,fkeyid -> not works (segmentation fault)
> SELECT rkeyid,fkeyid or in any other combination -> not work
>
> also SELECT * FROM sysreferences ->not works
>
> constid,rkeyid and fkeyid are int and they aren't locked.
>
> This happens not only for sysreferences but quite for all other
> system table. Sometimes all work if i put the name of the columns in
> a particular order (for example SELECT name,xtype,id FROM sysobjects
> is the only combination which work).
>
> Any suggestion??

Perhaps this is related to big-endian problems described in the list
archives. These queries all work on an Intel (little-endian) client
with protocol version 7.0 against SQL Server 2000.

--
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com





Archive powered by MHonArc 2.6.24.

Top of Page