[freetds] Unsupported ct_con_props property CS_SERVERNAME

Michael Peppler mpeppler at peppler.org
Thu Oct 16 09:33:49 EDT 2003


On Thu, 2003-10-16 at 06:54, Patrick Spinler wrote:
> Michael Peppler wrote:
> > On Wed, 2003-10-15 at 13:30, Patrick Spinler wrote:
> > 
> >>In (ancient) Openclient 10.0, ct_con_props supported a CS_GET property 
> >>CS_SERVERNAME, which returned the name of the connected server, like so:
> >>
> >>ct_con_props(conn,CS_GET,CS_SERVERNAME,connectionName,sizeof(connectionName),NULL);
> >>
> >>This doesn't appear to be in FreeTDS 0.61.  Is there an alternative I 
> >>can use ?
> > 
> > 
> > select @@servername
> > 
> > should work, at least for Sybase.
> > 
> > BTW - CS_SERVERNAME is still supported in recent OpenClient versions.
> > 
> > Michael
> 
> Oh ?  That'd be great, no code changes.  Can you please point out my 
> idiocy and tell me where I might find the definition of it ?

Sorry - I meant that CS_SERVERNAME is supported in Sybase's OpenClient
11.x and 12.x - not that FreeTDS had support for it (yet).

So I think the "select @@servername" work-around is your best bet at
this point.

Michael
-- 
Michael Peppler                              Data Migrations, Inc.
mpeppler at peppler.org                 http://www.mbay.net/~mpeppler
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or 
long term contract positions - http://www.mbay.net/~mpeppler/resume.html


More information about the FreeTDS mailing list