freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Null for "SELECT SERVERPROPERTY('productversion')"

From: Frediano Ziglio <freddy77 AT gmail.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Null for "SELECT SERVERPROPERTY('productversion')"
Date: Thu, 19 Jul 2012 11:18:51 +0100

Yes, you have to update. Probably server is returning SQL_VARIANT or
VARCHAR(MAX)

Frediano

2012/7/19 hai wu <haiwu.us AT gmail.com>:
> Freetds 0.64 is used here. When I used it to connect to a MS SQL 2008
> named instance, I could retrieve value using:
>
> SELECT @@SERVERNAME
> SELECT @@VERSION
>
> But when using:
> SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY
> ('productlevel'), SERVERPROPERTY ('edition')
>
> It returns 'NULL' for all of them.
>
> Any explanations?
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

[freetds] Null for "SELECT SERVERPROPERTY('productversion')", hai wu, 07/19/2012
- Re: [freetds] Null for "SELECT SERVERPROPERTY('productversion')", Frediano Ziglio, 07/19/2012
  - Re: [freetds] Null for "SELECT SERVERPROPERTY('productversion')", hai wu, 07/19/2012
    - Re: [freetds] Null for "SELECT SERVERPROPERTY('productversion')", Thomas, Christopher (LLU), 07/19/2012