Is there a query to retrieve the current version of the elevatedb-server?

Hi Eydun,

> Is there a query to retrieve the current version of the elevatedb-server?

Use the GetRemoteServerVersion function of your TEDBSession object to get the server version.

Terry

Terry Swiers wrote:

> Use the GetRemoteServerVersion function of your TEDBSession object to get the server version.

Is it possible to do this via the EDB manager or SQL?

In the EDB manager in session detals I can see host name port and encrpted etc

Anthony,

<< Is it possible to do this via the EDB manager or SQL? >>

Unfortunately, no, but I added it (along with the remote server name/description) so that it will appear in the next EDB version/build.

Tim Young
Elevate Software
www.elevatesoft.com

I realize this is not a solution, as you probably need to test many databases, perhaps including ones you do not control, however (once you know the version) you can use the following to hold data on the database:


ALTER DATABASE "Data"
Path '<some path>'
Description 'Version 2.7 build 1'!

Then use the following to retrieve:

SELECT Description FROM Configuration.Databases
WHERE Name = 'Data'

This is only useful if you add code to update the description when you update the version of EDB of course.