FreeTDS Development Group

["Lowden, James K" <LowdenJK AT bernstein.com>]

> From: Dave [mailto:david AT tomato.it]
> Sent: March 19, 2003 11:03 AM
> 
> Hi I have a "small" problem using cursor, I'm using this code 
> to make a query:
...
> if($result=mssql_query("FETCH ABSOLUTE ".($first+1)." FROM 
> select_cursor",$connection)  or die('unable to execute FETCH 
> ABSOLUTE!'))
...
> the script always exits at this line: unable to execute FETCH 
> ABSOLUTE!
> 
> I'm using freetds with FreeBSD 4.7 + Apache 1.3.27 + PHP 4.2.1.
> I compiled freetds from ports.
> I'm using Microsoft SQL server 2000 installed on Win 2000 server.
> 
> Any suggestions or is this a bug in freetds drivers ?

It might be a bug.  I don't know much about how TDS 7.0 conveys row data for
server-side cursors.  If it looks like a normal row with a little twist, we
might be able to fix it easily. 

Set TDSDUMP and have a look at the output, focussing on the last 500 lines
or so.  Does the server send any sort of error message?  Does FreeTDS
discard any tokens?  Do you see your data arriving?   

You can post your log here if you like; you'll probably have to cut it down
to keep it with the 75 KB limit on list messages.  

--jkl


The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above.  If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.