Discussion:
[freetds] Null for "SELECT SERVERPROPERTY('productversion')"
hai wu
2012-07-19 09:52:35 UTC
Permalink
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?
Frediano Ziglio
2012-07-19 10:18:51 UTC
Permalink
Yes, you have to update. Probably server is returning SQL_VARIANT or
VARCHAR(MAX)

Frediano
Post by hai wu
Freetds 0.64 is used here. When I used it to connect to a MS SQL 2008
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
hai wu
2012-07-19 11:06:22 UTC
Permalink
Which version would work fine in rhel5 if I need to update? Any rpm
package available for that version?
Post by Frediano Ziglio
Yes, you have to update. Probably server is returning SQL_VARIANT or
VARCHAR(MAX)
Frediano
Post by hai wu
Freetds 0.64 is used here. When I used it to connect to a MS SQL 2008
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
Thomas, Christopher (LLU)
2012-07-19 16:01:44 UTC
Permalink
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?
Post by Frediano Ziglio
Yes, you have to update. Probably server is returning SQL_VARIANT or
VARCHAR(MAX)
Frediano
Post by hai wu
Freetds 0.64 is used here. When I used it to connect to a MS SQL 2008
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

Loading...