Skip to Content.
Sympa Menu

freetds - Re: [freetds] second query fails when querying sql server 2008

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Patrick H. Burke" <phburke AT ctimessaging.com>
  • To: nitin sayare <nitinsayare AT gmail.com>, "FreeTDS AT lists.ibiblio.org" <FreeTDS AT lists.ibiblio.org>
  • Subject: Re: [freetds] second query fails when querying sql server 2008
  • Date: Thu, 4 Feb 2010 11:45:56 -0600

Is there a setting that will force that?

If I connect to a Mysql database (using the standard Mysql odbc driver), I
don't get the error.
Thanks,
Pat Burke

From: nitin sayare [mailto:nitinsayare AT gmail.com]
Sent: Thursday, February 04, 2010 11:09 AM
To: Patrick H. Burke
Subject: Re: [freetds] second query fails when querying sql server 2008

Hi ,

You need to close the cursor.



On Thu, Feb 4, 2010 at 10:02 PM, Patrick H. Burke
<phburke AT ctimessaging.com<mailto:phburke AT ctimessaging.com>> wrote:
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.




Archive powered by MHonArc 2.6.24.

Top of Page