Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How do I get the version of an ADS server?

2 posts in Visual Basic Last posting was on 2005-02-09 15:28:26.0Z
Alex Haley Posted on 2005-02-08 04:26:51.0Z
From: "Alex Haley" <haley-alex@usa.net>
Newsgroups: Advantage.Visual_Basic
Subject: How do I get the version of an ADS server?
Date: Mon, 7 Feb 2005 20:26:51 -0800
Lines: 12
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 4.246.138.32
Message-ID: <42084097@solutions.advantagedatabase.com>
X-Trace: 7 Feb 2005 21:31:19 -0700, 4.246.138.32
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!4.246.138.32
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:943
Article PK: 1137737

I need to be able to determine the ADS version I am connected to using
Visual Basic. The version properties I have found so far only return the
Version of the OLE DB provider.

I would prefer to know how to do this using the OLEDB provider directly or
SQL, but if that can't be done and there is another way, I will take
anything.

Thank You!
-Alex


Mark Wilkins Posted on 2005-02-09 15:28:26.0Z
Message-ID: <9140632435342444733100@solutions.advantagedatabase.com>
From: Mark Wilkins <mwilkins@extendsys.com>
Subject: Re: How do I get the version of an ADS server?
Newsgroups: Advantage.Visual_Basic
References: <42084097@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=iso-8859-1; format=flowed
X-Newsreader: JetBrains Omea Reader 381.17
NNTP-Posting-Host: 198.102.102.86
Date: 9 Feb 2005 08:28:26 -0700
X-Trace: 9 Feb 2005 08:28:26 -0700, 198.102.102.86
Lines: 24
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.86
Xref: solutions.advantagedatabase.com Advantage.Visual_Basic:944
Article PK: 1137738

Hello Alex,

The stored procedure sp_mgGetInstallInfo will return the server version.
This would be a very simple method, however that stored procedure was not
added until v7.1. Otherwise, I think the only way to get it is with the
Advantage Client Engine API AdsMgGetInstallInfo. Calling that API from Visual
Basic, though, might be a bit of a trick since it uses a structure containing
null terminated strings. I think it can be done, but do not have an example.

Mark Wilkins
Advantage R&D

> I need to be able to determine the ADS version I am connected to using
> Visual Basic. The version properties I have found so far only return
> the Version of the OLE DB provider.
>
> I would prefer to know how to do this using the OLEDB provider
> directly or SQL, but if that can't be done and there is another way, I
> will take anything.
>
> Thank You!
> -Alex