Re: Null for "SELECT SERVERPROPERTY('productversion')"
Frediano Ziglio <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <CAHt6W4fAp893Mmp0PGLtYb_QqA=kNtPgELKCMbAHw=o0pN9v7g@mail.gmail.com> |
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