Skip to Content.
Sympa Menu

freetds - [freetds] Login timeout on dblib

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Vincent Cunniffe <vincent AT oitg.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Login timeout on dblib
  • Date: Fri, 02 May 2008 14:10:23 +0100

Hi,

I'm trying to get FreeTDS (in the form of sybdb linked to a C++ binary) working. I've got it connecting, executing queries, etc., but am having problems with timeouts. The network environment is somewhat lossy, leading to failed login attempts. However, although I've requested a 10 second login timeout, and although the /tmp/freetds.log is spamming :

13:49:34.603236 26839 (net.c:354):exceeded query timeout: 10

every 10 seconds during the failed login attempts, I'm not getting any calls through to the error handler. When I do connect successfully, and if any *other* error conditions happen post-login, then the error handler is called correctly to handle those error conditions.

Anyone seen this before, and is there a solution?

This is freetds-0.64, with a vanilla configure/make/install on CentOS 4.6, linked against a C++ binary compiled with gcc 3.4.3. It's connecting to a remote MS SQL server.

The exact code in use to generate this is attached below.

Regards,

Vin

---

LOGINREC *login=dblogin();

dbsetluser(login, username.c_str());
dbsetlpwd(login, password.c_str());
dbsetlapp(login, appname.c_str());

dbsetlogintime(10);

dberrhandle(err_handler);
dbmsghandle(msg_handler);

DBPROCESS *dbproc=dbopen(login, (char *)linktarget.c_str());

dbloginfree(login);

dbsettime(30);

return(dbproc);


--

Vincent Cunniffe
Head of SMS, Opera Technology Group

Hospitality House,
South Cumberland Street, Dublin 2

t: +353 (0)1 484 8850 m: +353 (0)87 225 2049 f: +353 (0)1 484 8890

e: vincent AT oitg.com w: http://www.oitg.com/ireland




Archive powered by MHonArc 2.6.24.

Top of Page