Re: Null for "SELECT SERVERPROPERTY('productversion')"

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: [email protected] [mailto:[email protected]] 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 <[email protected]> wrote:
> Yes, you have to update. Probably server is returning SQL_VARIANT or
> VARCHAR(MAX)
>
> Frediano
>
> 2012/7/19 hai wu <[email protected]>:
>> 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
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>

--
Sent from my mobile device
_______________________________________________
FreeTDS mailing list
[email protected]
http://lists.ibiblio.org/mailman/listinfo/freetds