[freetds] Unsupported cs_con_props property CS_SERVERNAME

Michael Peppler mpeppler at peppler.org
Wed Oct 15 16:06:46 EDT 2003


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
-- 
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