FreeTDS Development Group

[Bob Kline <bkline AT rksystems.com>]

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