FreeTDS Development Group

[Craig Spannring <cts AT internetcds.com>]

In SQLServer 6.5 the '#' prefix tells the server to create a temporary
identifier.  Any stored procedure that starts with '#' will be
automatically deleted when the connection is dropped.  SQLServer 4.21
(AFAIK) doesn't support temporaries.

The easy solution (from my perspective :-) is to upgrade to 6.5.  From
your perspective I can imagine many reasons why that might not be a
good solution.


Malte Grunwald writes:
 > Hallo,
 > 
 > for each preparedStatement (freetds JDBC-Driver) the driver creates a
 > stored procedure in the tempdb. What is the mechanism to remove the
 > procedures again from the tempdb? - should this be handled automatically
 > by the database-server?
 > 
 > We are using a 4.21 MS Server. With this server the procedures in the
 > tempdb are not found when a preparedStatment is executed. I have changed
 > the prefix `#JDBC#' to `JDBC' then the driver is finding the procedures
 > (in the default-database of the user). This is not the right way. What can
 > I do to help the driver to find the procedures? If I can not do anything
 > here, what is the best way to remove the procedures again.
 > 
 > Thank your for your help,
 > 
 > Malte Grunwald 
 > 
 > 
 > ***********************************************************************
 > Malte Grunwald
 > Risiko Management/System Entwicklung
 > Clearing Bank Hannover AG
 > ***********************************************************************
 > 
 > 
 > ---
 > You are currently subscribed to freetds as: cts AT internetcds.com
 > To unsubscribe, forward this message to $subst('Email.Unsub')
 > 
-- 
=======================================================================
 Life is short.                  | Craig Spannring 
      Bike hard, ski fast.       | cts AT internetcds.com
 --------------------------------+------------------------------------
 Any sufficiently horrible technology is indistinguishable from Perl.
=======================================================================