Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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




Archive powered by MHonArc 2.6.24.

Top of Page