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: "Thomas, Christopher (LLU)" <cwthomas AT llu.edu>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Null for "SELECT SERVERPROPERTY('productversion')"
  • Date: Thu, 19 Jul 2012 16:01:44 +0000

RHEL EPEL Repository:

http://fedoraproject.org/wiki/EPEL

after installing repo:

#rpm -ivh freetds


Or you can download the freeTDS source. It has a .spec file which you can use
to create your own rpm package.

Chris

-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of hai wu
Sent: Thursday, July 19, 2012 4:06 AM
To: FreeTDS Development Group
Subject: Re: [freetds] Null for "SELECT SERVERPROPERTY('productversion')"

Which version would work fine in rhel5 if I need to update? Any rpm package
available for that version?

On 7/19/12, Frediano Ziglio <freddy77 AT gmail.com> wrote:
> 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 mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>

--
Sent from my mobile device
_______________________________________________
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