freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

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

From: hai wu <haiwu.us AT gmail.com>
To: freetds AT lists.ibiblio.org
Subject: [freetds] Null for "SELECT SERVERPROPERTY('productversion')"
Date: Thu, 19 Jul 2012 04:52:35 -0500

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