We want to be able to support different time zones for different databases
running on the same windows server.

We use the dblib interface to connect to SQL anywhere and from my reading of
the link below it doesn't seem possible that this is supported since dblib
(Open clent) only supports the server's time zone.

I wanted to confirm this.

"If the client is connecting via jConnect or Open Client, the default is
based on the server's time zone."

http://www.ianywhere.com/developer/p...nt-option.html

I also want to confirm that server time zone is retrieved from the OS and
there is no way to change that with any server property settings?

thanks

Your application can execute:
set temporary option time_zone_adjustment = '-5:00'
immediately after connecting. If you want all connections to a particular
database to use the same adjustment, you could set the value in the login
procedure.

The server's value is set from the OS and cannot be adjusted.

Whitepapers, TechDocs, bug fixes at http://www.ianywhere.com/developer

"Steve Garland [ASTA]" <sgarland (AT) astatech (DOT) com> wrote