freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Unsupported cs_con_props property CS_SERVERNAME

From: Michael Peppler <mpeppler AT peppler.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Unsupported cs_con_props property CS_SERVERNAME
Date: Wed, 15 Oct 2003 15:06:46 -0700

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

[freetds] RE: FreeTDS Digest, Vol 9, Issue 9, David Nsengiyumva, 10/09/2003
- Re: [freetds] RE: FreeTDS Digest, Vol 9, Issue 9, Ole Hansen, 10/09/2003
- [freetds] Re: Date/Time and Currency (was: FreeTDS Digest, Vol 9, Issue 9), James K. Lowden, 10/10/2003
  - [freetds] Unsupported cs_con_props property CS_SERVERNAME, Patrick Spinler, 10/15/2003
    - Re: [freetds] Unsupported cs_con_props property CS_SERVERNAME, Michael Peppler, 10/15/2003
      - Re: [freetds] Unsupported ct_con_props property CS_SERVERNAME, Patrick Spinler, 10/16/2003
        
        Re: [freetds] Unsupported ct_con_props property CS_SERVERNAME, Michael Peppler, 10/16/2003
- <Possible follow-up(s)>
- [freetds] RE: FreeTDS Digest, Vol 9, Issue 9, David Nsengiyumva, 10/09/2003
- RE: [freetds] RE: FreeTDS Digest, Vol 9, Issue 9, Thompson, Bill D (London), 10/09/2003