dbTalk Databases Forums  

ASE Version

comp.databases.sybase comp.databases.sybase


Discuss ASE Version in the comp.databases.sybase forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Claret
 
Posts: n/a

Default ASE Version - 12-07-2009 , 11:41 AM






Why am I getting different results from sp_server_info 2 and
@@version? (@@version is correct).

exec sp_server_info 2
attribute_id attribute_name attribute_value
2 DBMS_VER SQL Server/12.5/P/Generic/OS/1/OPT/Sat Jun 30
00:01:37 PDT 2001


select @@version
Adaptive Server Enterprise/15.0.3/EBF 16555 ESD#1/P/Linux Intel/Linux
2.6.9-42.ELsmp i686/ase1503/2680/32-bit/FBO/Thu Mar 5 04:50:21 2009

Reply With Quote
  #2  
Old   
Bret_Halford
 
Posts: n/a

Default Re: ASE Version - 12-07-2009 , 04:43 PM






On Dec 7, 9:41*am, Claret <clare.tuc... (AT) navy (DOT) mil> wrote:
Quote:
Why am I getting different results from sp_server_info 2 and
@@version? *(@@version is correct).

exec sp_server_info 2
attribute_id *attribute_name * *attribute_value
* * 2 * * *DBMS_VER * * SQL Server/12.5/P/Generic/OS/1/OPT/Sat Jun 30
00:01:37 PDT 2001

select @@version
Adaptive Server Enterprise/15.0.3/EBF 16555 ESD#1/P/Linux Intel/Linux
2.6.9-42.ELsmp i686/ase1503/2680/32-bit/FBO/Thu Mar *5 04:50:21 2009

There is this comment in the $ASE/scripts/SYCSP11.SQL file where this
value comes
from:

/*
** DO NOT change the DBMS_VER value! It is NOT supposed to be
** the same as @@version, even though ASE RefMan indicates otherwise.
** This value needs to be kept in-sync with ODBC driver from Merant/
Intersolv,
** so this may only be changed in accordance with the driver. Also
see
** note at the beginning of this file.
*/
insert into spt_server_info
values (2, "DBMS_VER",
"SQL Server/12.5/P/Generic/OS/1/OPT/Sat Jun 30 00:01:37 PDT 2001")

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.