Skip to Content.
Sympa Menu

freetds - Re: [freetds] Unsupported ct_con_props property CS_SERVERNAME

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Unsupported ct_con_props property CS_SERVERNAME
  • Date: Thu, 16 Oct 2003 08:33:49 -0700

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




Archive powered by MHonArc 2.6.24.

Top of Page