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.

Connections ignoring OPTIONS parameters

9 posts in General Discussion Last posting was on 2005-03-31 04:34:03.0Z
Mike Allen Posted on 2005-03-30 15:03:50.0Z
Sender: 5b84.424abe2b.1804289383@sybase.com
From: Mike Allen
Newsgroups: ianywhere.public.general
Subject: Connections ignoring OPTIONS parameters
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <424abfd6.5bb7.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 30 Mar 2005 07:03:50 -0800
X-Trace: forums-1-dub 1112195030 10.22.241.41 (30 Mar 2005 07:03:50 -0800)
X-Original-Trace: 30 Mar 2005 07:03:50 -0800, 10.22.241.41
Lines: 8
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4312
Article PK: 8131

I am trying to change the Date_order option for the
database.
I have set option public.date_order = MDY
I have set the same option for the user's logon
and still when the user logs on the option is set to the
default YMD
I am running ASA9.0.2 on a WIN2003 box.
What am I missing here?


Chris Keating (iAnywhere Solutions) Posted on 2005-03-30 15:19:59.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <424abfd6.5bb7.1681692777@sybase.com>
Subject: Re: Connections ignoring OPTIONS parameters
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <424ac39f$1@forums-1-dub>
Date: 30 Mar 2005 07:19:59 -0800
X-Trace: forums-1-dub 1112195999 10.25.98.199 (30 Mar 2005 07:19:59 -0800)
X-Original-Trace: 30 Mar 2005 07:19:59 -0800, keating-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4313
Article PK: 8134

Is the client changing that value transparently?

Run a Request level log (-zr sql )to see if the option is being reset.

<Mike Allen> wrote in message news:424abfd6.5bb7.1681692777@sybase.com...
>I am trying to change the Date_order option for the
> database.
> I have set option public.date_order = MDY
> I have set the same option for the user's logon
> and still when the user logs on the option is set to the
> default YMD
> I am running ASA9.0.2 on a WIN2003 box.
> What am I missing here?


Breck Carter [TeamSybase] Posted on 2005-03-30 16:24:02.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__bcarter@risingroad.com>
Newsgroups: ianywhere.public.general
Subject: Re: Connections ignoring OPTIONS parameters
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__bcarter@risingroad.com
Message-ID: <phkl415rn3npcrndg577aitl9maf1166i9@4ax.com>
References: <424ac39f$1@forums-1-dub> <424ace56.5d29.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bcarter.sentex.ca
X-Original-NNTP-Posting-Host: bcarter.sentex.ca
Date: 30 Mar 2005 08:24:02 -0800
X-Trace: forums-1-dub 1112199842 64.7.134.118 (30 Mar 2005 08:24:02 -0800)
X-Original-Trace: 30 Mar 2005 08:24:02 -0800, bcarter.sentex.ca
Lines: 73
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4315
Article PK: 8135

Check your setting of the LOGIN_PROCEDURE (you can see all options by
executing

SET

in dbisql)

That option may point to a stored procedure that is doing this to you.
By default it points to dbo.sp_login_environment, and the installed
version of that procedure does *not* do what you are experiencing.

Breck

On 30 Mar 2005 08:05:42 -0800, Mike Allen wrote:

>Turned logging on and sure enough it is getting changed by
>the second command executed after the connect. The
>connection is coming from an ODBC client. I have no code
>written to do this. Is this part of an internal Procedure?
>My first SQL does not occur until 5 to 8 statements later.
>Where are these statements coming from?
>
>
>
>I. 03/30 10:40:37. ** CONNECT conn: 2 UID=cms_app
>I. 03/30 10:40:37. ** DONE conn: 2 CONNECT
> Conn=2
>I. 03/30 10:40:37. ** REQUEST conn: 2 STMT_PREPARE
> "SELECT @@version, if 'A'<>'a' then 1 else 0 endif, if
>db_property('IsIQ') = 'YES' then 1 else 0 endif"
>I. 03/30 10:40:37. ** DONE conn: 2 STMT_PREPARE
> Stmt=65536
>I. 03/30 10:40:37. ** REQUEST conn: 2 STMT_EXECUTE
> Stmt=-1
>I. 03/30 10:40:37. ** DONE conn: 2 STMT_EXECUTE
>I. 03/30 10:40:37. ** REQUEST conn: 2 STMT_DROP
> Stmt=65536
>I. 03/30 10:40:37. ** DONE conn: 2 STMT_DROP
>I. 03/30 10:40:37. ** REQUEST conn: 2 STMT_PREPARE
> "SET TEMPORARY OPTION Time_format = 'hh:nn:ss';SET
>TEMPORARY OPTION Timestamp_format = 'yyyy-mm-dd
>hh:nn:ss.ssssss';SET TEMPORARY OPTION Date_format =
>'yyyy-mm-dd';SET TEMPORARY OPTION Date_order = 'ymd';SET
>TEMPORARY OPTION Isolation_level = 0;"
>I. 03/30 10:40:37. ** DONE conn: 2 STMT_PREPARE
> Stmt=65537
>I. 03/30 10:40:37. ** REQUEST conn: 2 STMT_EXECUTE
> Stmt=-1
>I. 03/30 10:40:37. ** DONE conn: 2 STMT_EXECUTE
>> Is the client changing that value transparently?
>>
>> Run a Request level log (-zr sql )to see if the option is
>> being reset.
>>
>>
>> <Mike Allen> wrote in message
>> news:424abfd6.5bb7.1681692777@sybase.com... >I am trying
>> > to change the Date_order option for the database.
>> > I have set option public.date_order = MDY
>> > I have set the same option for the user's logon
>> > and still when the user logs on the option is set to the
>> > default YMD
>> > I am running ASA9.0.2 on a WIN2003 box.
>> > What am I missing here?
>>
>>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/ASIN/1556225067/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com