[freetds] FreeTDS and Ubuntu, iodbc

Dan Mohn mohnd at egolfscore.com
Sat Apr 7 11:15:59 EDT 2007


>> When you connect DSN-less, you're relying on the built-in TDS
version. Your package might have used the --with-tdsver=7.0 configure
option. <<

Ok, I made the libraries with the tdsver option, and now the dsn-less
connection now works again.

Regarding the "timeout".  I looked at the 3 timeout tests and its not
clear to me whether they test for what I am experiencing.

What I am doing is in the middle of a query result set, I am physically
unplugging the network cable.  Like;

send sql statement
while not resultset eof
---here I pull the network cable after a couple of rows have been read
---get data
---check for an timeout error
---get the next row
loop

Interestingly, after appx 2 hours, an error is trapped, and Realbasic is
reporting the following error message it claims is from the odbc driver;

[FreeTDS][<drivername>]Communication link failure.

What do you recommend I do for my next step? 

Thanks!

Dan


On Wed, 2007-04-04 at 21:32 -0400, James K. Lowden wrote:
> Dan Mohn wrote:
> > I will note that with the pre-packaged
> > freetds, I was able to do a DSN-less connection, but with the same
> > setting I no longer seem to.  But that could just be my lack of
> > understanding.
> 
> Hello Dan,
> 
> When you connect DSN-less, you're relying on the built-in TDS version.
> Your package might have used the --with-tdsver=7.0 configure option. 
> 
> Glad to know things are working, though. 
> 
> > When
> > I disconnect from the network, the application still does not
> timeout.
> > However, I have noticed that if I wait 1 min, or 15 min, or longer
> and
> > re-establish the network connection, the application will then catch
> an
> > odbc error. 
> 
> There are timeout unit tests that bypass all the higher layers you're
> using.  Could I suggest you try the ODBC one?  If it passes but
> doesn't
> detect the kind of problem you're, well, creating, then we need a
> better
> test. 
> 
> Also please try my new bsqlodbc utility.  Then tell us precisely how
> you're testing: you issue query X, remove something, wait N seconds,
> replace something, then something happens.  Please try the same thing
> with
> bsqldb, because that will help tell us where the problem is, if any. 
> 
> I put a lot of time into this part of the project.  It's tricky, but I
> think I got it right.  If it's not right and you can show me, I'm at
> your
> service. 
> 
> Regards,
> 
> --jkl
> 
> 



More information about the FreeTDS mailing list