second query fails when querying sql server 2008

"Patrick H. Burke" <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <67937CC5BB12D1469388747981EC9AE70DDF515ACC@SOFTPRO2K8.SoftProLLC.com>
Hello,

I have FreeTDS installed on a 64 bit CentOS platform, connecting to a MS SQL Server 2008.

Configuration:
                tds version = 8.0

I connect using the following scenarios:

-----------------------------------------------
                Connect to isql
                Select * from sip_acc
                                (55 rows returned)
                Disconnect

-----------------------------------------------

                Connect to isql
                Select 1
                                (1 row returned)
                Select * from sip_acc
                                (0 rows returned)
                Disconnect

                NOTES:  Looking in the freetds.log file I see there are 55 rows returned.
token.c:2175:                rows_affected = 55
-----------------------------------------------

Any recommendations?
Thanks,
Pat Burke


________________________________
E-MAIL CONFIDENTIALITY NOTICE: This message may contain confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, disclose, or take any action based on this message or any information herein. If you have received this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.