SQL Anywhere database - How to detect EBF level on client

Author

How to detect EBF level on client

Scott Huerta

2005-12-14, 1:23 pm

We are trying to close some loose ends in our applications start up
processing. We want to make sure that all machines that connect to our
database server are on the "proper" EBF patch for our application.

I thought I'd seen something in this group before about this. But
searching for it, I didn't find anything.

We know how to check the database server's EBF level. But we can't seem
to figure how to do it on the clients.

What I'd like to see is something like what you get when you run "DBEng8
-v". Isn't there a local property or setting that can be queried from
the local client?

We are using:
1. Delphi (5 and 2005) as the programming language.
2. ASA 8.0.2.4454 & ASA 9.0.2.3182.
3. Windows Server 2000/2003, Windows 2000/XP

Thanks,

Scott Huerta
Distinctive Solutions Corporation

Joshua Savill

2005-12-14, 8:24 pm

SELECT @@version will return the version and build of the database server
running the database.

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Scott Huerta" <scott@dissol.com> wrote in message
news:43A06675.427E6A57@dissol.com...
> We are trying to close some loose ends in our applications start up
> processing. We want to make sure that all machines that connect to our
> database server are on the "proper" EBF patch for our application.
>
> I thought I'd seen something in this group before about this. But
> searching for it, I didn't find anything.
>
> We know how to check the database server's EBF level. But we can't seem
> to figure how to do it on the clients.
>
> What I'd like to see is something like what you get when you run "DBEng8
> -v". Isn't there a local property or setting that can be queried from
> the local client?
>
> We are using:
> 1. Delphi (5 and 2005) as the programming language.
> 2. ASA 8.0.2.4454 & ASA 9.0.2.3182.
> 3. Windows Server 2000/2003, Windows 2000/XP
>
> Thanks,
>
> Scott Huerta
> Distinctive Solutions Corporation
>

Scott Huerta

2005-12-14, 8:24 pm

Thanks for the reply Joshua.

I know about this and the server. But from a client workstation how can I
tell the version (including build version) of ASA that is running on the
client?

For example, the database server is running on server1 with ASA 8.0.2.4454. I
then have one client workstation connecting to this sever1 but using ASA
8.0.2.4339. I want to issue a warning message from within our app upon
startup that this workstation is not at the correct EBF level. Within our
database we have a setting in a control table that indicates what build
version the EBF needs to be at.

Will the "select connection_property(
'version')" SQL command give me this
info? Or will this just give me the version info of the EXE making the call?

Thanks

Scott

Joshua Savill wrote:
[color=darkred]
> SELECT @@version will return the version and build of the database server
> running the database.
>
> --
> Joshua Savill
> iAnywhere Solutions - Product Support Analyst
>
> "Scott Huerta" <scott@dissol.com> wrote in message
> news:43A06675.427E6A57@dissol.com...

Jason Hinsperger \(iAnywhere\)

2005-12-14, 8:24 pm

The 'appinfo' connection property should give you the client side
information.

select connection_property(
'appinfo')

--
Jason Hinsperger
Product Manager
iAnywhere Solutions
********************
********************
********************

For the latest downloads technotes, whitepapers, webcasts and other
developer
resources, go to: http://www.ianywhere.com/developer/
********************
********************
********************

"Scott Huerta" <scott@dissol.com> wrote in message
news:43A078FF.BC56A087@dissol.com...
> Thanks for the reply Joshua.
>
> I know about this and the server. But from a client workstation how can I
> tell the version (including build version) of ASA that is running on the
> client?
>
> For example, the database server is running on server1 with ASA
> 8.0.2.4454. I
> then have one client workstation connecting to this sever1 but using ASA
> 8.0.2.4339. I want to issue a warning message from within our app upon
> startup that this workstation is not at the correct EBF level. Within our
> database we have a setting in a control table that indicates what build
> version the EBF needs to be at.
>
> Will the "select connection_property(
'version')" SQL command give me this
> info? Or will this just give me the version info of the EXE making the
> call?
>
> Thanks
>
> Scott
>
> Joshua Savill wrote:
>
>

Sponsored Links