FreeTDS Development Group

["Piet De Jong" <piet AT ahead-tech.net>]

Hi Patrick,

Tried today with version freetds-0.63.dev.20040507 
Unfortunately does not work either..


> -----Original Message-----
> From: iODBC Administrator [mailto:iodbc AT openlinksw.com]
> Sent: 11 May 2004 03:28 PM
> To: piet AT ahead-tech.net
> Subject: Re: [freetds] Another OTL question / problem
> 
> 
> Hi Piet,
> 
> > Attached I have a very simple select statement which is supposed to
> > return a single column. However when I run the program I do not get 
> > any data returned.
> >  
> > I use the latest version of OTL ( 4.0.84 )
> >  
> > I am not sure if I had asked this question before, I could
> not find it
> > on the list.
> >  
> > The platform with the problem:
> > Slackware 9.1.0
> > using iodbc 3.51.1
> > gcc version: 3.2.3
> >  
> > When I compile and run the attached example on Windows I
> dont have any
> > problems, the correct values ( 1  and RPC = 1 ) are returned.
> 
> I checked your trace and the problem is that the version of
> the freetds driver you are using returns 0 for the 
> SQLNumResultCols after the
> 
>    select revision from revisiontable where version = 1
> 
> The OTL code then does not bind the resulting columns using
> the SQLBindCol. The SQLFetchScroll function retrieves the 
> row, but the data is not passed to your app.
> 
> You may want to try the latest FreeTDS code from the CVS archive.
> 
> BTW: Sorry i reply to you directly but for some reason my account was
> not allowed to post on the list. Will have to sort that out later.
> 
> 
> Best regards,
> 
> Patrick
> -- 
> Patrick van Kleef            Email : iodbc AT openlinksw.com
> Maintainer iODBC             Web   : http://www.iodbc.org/
> OpenLink Software
> 
> Universal Data Access & Data Integration Technology Providers
>