[freetds] FreeTDS and Ubuntu, iodbc

James K. Lowden jklowden at freetds.org
Wed Apr 4 21:32:43 EDT 2007


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