freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] [Store Procedure Names] roll-over problem

From: Wolfgang Gruen <wgruen AT caci.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Cc: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>, freetds-bounces AT lists.ibiblio.org
Subject: [freetds] [Store Procedure Names] roll-over problem
Date: Fri, 14 Jul 2006 11:27:23 -0400

Hi,

I am running into the case where the connections starts to create
duplicate store procedure names. This happens when we roll over in method
tds_get_dynid() in query.c. Please check out this line, which causes the
roll-over:

inc_num = (inc_num + 1) & 0xffff

I am researching different random string/character generators and was
wondering whether somebody has already a better generator/solution
available.

A workaround could be to free a statements at the time of roll-over, but
this may be time consuming and not be in synch with the application.

I appreciate any suggestions.
Thanks!
Wolfgang

[freetds] Problem with stored proc and varchar parameters, bflood, 07/13/2006
- Re: [freetds] Problem with stored proc and varchar parameters, Ellert van Koperen, 07/13/2006
  - Re: [freetds] Problem with stored proc and varchar parameters, bflood, 07/13/2006
- <Possible follow-up(s)>
- Re: [freetds] Problem with stored proc and varchar parameters, Lowden, James K, 07/13/2006
  - Re: [freetds] Problem with stored proc and varchar parameters, bflood, 07/13/2006
- Re: [freetds] Problem with stored proc and varchar parameters, ZIGLIO, Frediano, VF-IT, 07/14/2006
  - [freetds] [Store Procedure Names] roll-over problem, Wolfgang Gruen, 07/14/2006
  - Re: [freetds] Problem with stored proc and varchar parameters, Ellert van Koperen, 07/17/2006
- Re: [freetds] Problem with stored proc and varchar parameters, ZIGLIO, Frediano, VF-IT, 07/17/2006