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.

problems with determining column types when using ASAProvider from 8.0.2

6 posts in General Discussion Last posting was on 2003-03-05 13:51:23.0Z
Michael Gould Posted on 2003-03-04 13:02:10.0Z
From: "Michael Gould" <mgould@Omnicc.com>
Subject: problems with determining column types when using ASAProvider from 8.0.2
Date: Tue, 4 Mar 2003 08:02:10 -0500
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <CeDwWFl4CHA.181@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: adsl-17-249-160.jax.bellsouth.net 68.17.249.160
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:788
Article PK: 3273

When I try and import the column types for DATE and TIME columns using the
ASAProvider, it always returns a 135 type which I believe is a TIMESTAMP for
all DATE and TIME columns. My setup is as below.

Provider=ASAProv.80;Persist Security Info=False;Data Source = ASA-ODBC


If I try this using the MS Provider for ODBC then it correctly returns the
column types for DATE and TIME

For this test I used the setup below.

Provider=MSDASQL.1;Persist Security Info=False;Data Source=ASA-ODBC

This returns type 133 for DATE and 134 for Time columns.

Michael Gould


Chris Keating Posted on 2003-03-04 15:03:44.0Z
From: "Chris Keating" <Fight_Spam_keating@iAnywhere.com>
References: <CeDwWFl4CHA.181@forums.sybase.com>
Subject: Re: problems with determining column types when using ASAProvider from 8.0.2
Date: Tue, 4 Mar 2003 10:03:44 -0500
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <luogPIm4CHA.287@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.140.19
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:791
Article PK: 2738

I am not seeing this problem in ASA 8.0.2.4218

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

"Michael Gould" <mgould@Omnicc.com> wrote in message
news:CeDwWFl4CHA.181@forums.sybase.com...
> When I try and import the column types for DATE and TIME columns using the
> ASAProvider, it always returns a 135 type which I believe is a TIMESTAMP
for
> all DATE and TIME columns. My setup is as below.
>
> Provider=ASAProv.80;Persist Security Info=False;Data Source = ASA-ODBC
>
>
> If I try this using the MS Provider for ODBC then it correctly returns the
> column types for DATE and TIME
>
> For this test I used the setup below.
>
> Provider=MSDASQL.1;Persist Security Info=False;Data Source=ASA-ODBC
>
> This returns type 133 for DATE and 134 for Time columns.
>
> Michael Gould
>
>


Michael Gould Posted on 2003-03-05 00:02:40.0Z
From: "Michael Gould" <mgould@Omnicc.com>
References: <CeDwWFl4CHA.181@forums.sybase.com> <luogPIm4CHA.287@forums.sybase.com>
Subject: Re: problems with determining column types when using ASAProvider from 8.0.2
Date: Tue, 4 Mar 2003 19:02:40 -0500
Lines: 57
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <3lngc2q4CHA.261@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: adsl-154-224-36.jax.bellsouth.net 68.154.224.36
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:793
Article PK: 3268

Chris,

I just installed 4218 on my machine. I was a couple of EBF's down. I have a
program that when run using the ASA provider it always returns type 135 for
Date and Time columns. When running it using the MS Provider for ODBC it
returns a Date column as type 133 and Time Column as Type 134.

Would you like the test program to verify this?

Thanks

Michael Gould

"Chris Keating" <Fight_Spam_keating@iAnywhere.com> wrote in message
news:luogPIm4CHA.287@forums.sybase.com...
> I am not seeing this problem in ASA 8.0.2.4218
>
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use CaseXpress to report bugs http://casexpress.sybase.com
>
> "Michael Gould" <mgould@Omnicc.com> wrote in message
> news:CeDwWFl4CHA.181@forums.sybase.com...
> > When I try and import the column types for DATE and TIME columns using
the
> > ASAProvider, it always returns a 135 type which I believe is a TIMESTAMP
> for
> > all DATE and TIME columns. My setup is as below.
> >
> > Provider=ASAProv.80;Persist Security Info=False;Data Source = ASA-ODBC
> >
> >
> > If I try this using the MS Provider for ODBC then it correctly returns
the
> > column types for DATE and TIME
> >
> > For this test I used the setup below.
> >
> > Provider=MSDASQL.1;Persist Security Info=False;Data Source=ASA-ODBC
> >
> > This returns type 133 for DATE and 134 for Time columns.
> >
> > Michael Gould
> >
> >
>
>


Chris Keating Posted on 2003-03-05 02:18:58.0Z
From: "Chris Keating" <Spam_Free_keating@iAnywhere.com>
References: <CeDwWFl4CHA.181@forums.sybase.com> <luogPIm4CHA.287@forums.sybase.com> <3lngc2q4CHA.261@forums.sybase.com>
Subject: Re: problems with determining column types when using ASAProvider from 8.0.2
Date: Tue, 4 Mar 2003 21:18:58 -0500
Lines: 74
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <4qJ5mBs4CHA.289@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 158.159.8.82
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:794
Article PK: 2739

If the problem is urgent, please contact 1-800-8-Sybase to open a technical
support case via the terms of your support plan. If the matter is not
urgent, you can use the Report a Bug service. To do so, go to
http://www.sybase.com/support and select "Report a Bug" under the Additional
Services in the left hand frame.

/ck

"Michael Gould" <mgould@Omnicc.com> wrote in message
news:3lngc2q4CHA.261@forums.sybase.com...
> Chris,
>
> I just installed 4218 on my machine. I was a couple of EBF's down. I have
a
> program that when run using the ASA provider it always returns type 135
for
> Date and Time columns. When running it using the MS Provider for ODBC it
> returns a Date column as type 133 and Time Column as Type 134.
>
> Would you like the test program to verify this?
>
> Thanks
>
> Michael Gould
>
> "Chris Keating" <Fight_Spam_keating@iAnywhere.com> wrote in message
> news:luogPIm4CHA.287@forums.sybase.com...
> > I am not seeing this problem in ASA 8.0.2.4218
> >
> > --
> >
> > Chris Keating
> > Sybase Adaptive Server Anywhere Professional Version 8
> > iAnywhere Solutions http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> >
> > "Michael Gould" <mgould@Omnicc.com> wrote in message
> > news:CeDwWFl4CHA.181@forums.sybase.com...
> > > When I try and import the column types for DATE and TIME columns using
> the
> > > ASAProvider, it always returns a 135 type which I believe is a
TIMESTAMP
> > for
> > > all DATE and TIME columns. My setup is as below.
> > >
> > > Provider=ASAProv.80;Persist Security Info=False;Data Source = ASA-ODBC
> > >
> > >
> > > If I try this using the MS Provider for ODBC then it correctly returns
> the
> > > column types for DATE and TIME
> > >
> > > For this test I used the setup below.
> > >
> > > Provider=MSDASQL.1;Persist Security Info=False;Data Source=ASA-ODBC
> > >
> > > This returns type 133 for DATE and 134 for Time columns.
> > >
> > > Michael Gould
> > >
> > >
> >
> >
>
>


Chris Keating Posted on 2003-03-05 13:51:23.0Z
From: "Chris Keating" <Fight_Spam_keating@iAnywhere.com>
References: <CeDwWFl4CHA.181@forums.sybase.com> <luogPIm4CHA.287@forums.sybase.com> <3lngc2q4CHA.261@forums.sybase.com> <4qJ5mBs4CHA.289@forums.sybase.com>
Subject: Re: problems with determining column types when using ASAProvider from 8.0.2
Date: Wed, 5 Mar 2003 08:51:23 -0500
Lines: 101
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <p73whEy4CHA.261@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.140.19
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:795
Article PK: 2740

My testing shows that the provider is identifying the datatypes correctly,
fields(n).Type, in VB6 SP5 so make sure that you submit the test case if
and when you submit this matter.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8
iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

"Chris Keating" <Spam_Free_keating@iAnywhere.com> wrote in message
news:4qJ5mBs4CHA.289@forums.sybase.com...
> If the problem is urgent, please contact 1-800-8-Sybase to open a
technical
> support case via the terms of your support plan. If the matter is not
> urgent, you can use the Report a Bug service. To do so, go to
> http://www.sybase.com/support and select "Report a Bug" under the
Additional
> Services in the left hand frame.
>
> /ck
>
>
>
> "Michael Gould" <mgould@Omnicc.com> wrote in message
> news:3lngc2q4CHA.261@forums.sybase.com...
> > Chris,
> >
> > I just installed 4218 on my machine. I was a couple of EBF's down. I
have
> a
> > program that when run using the ASA provider it always returns type 135
> for
> > Date and Time columns. When running it using the MS Provider for ODBC
it
> > returns a Date column as type 133 and Time Column as Type 134.
> >
> > Would you like the test program to verify this?
> >
> > Thanks
> >
> > Michael Gould
> >
> > "Chris Keating" <Fight_Spam_keating@iAnywhere.com> wrote in message
> > news:luogPIm4CHA.287@forums.sybase.com...
> > > I am not seeing this problem in ASA 8.0.2.4218
> > >
> > > --
> > >
> > > Chris Keating
> > > Sybase Adaptive Server Anywhere Professional Version 8
> > > iAnywhere Solutions http://www.iAnywhere.com
> > >
> > > ** Please only post to the newsgroup
> > >
> > > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > > ** Use CaseXpress to report bugs http://casexpress.sybase.com
> > >
> > > "Michael Gould" <mgould@Omnicc.com> wrote in message
> > > news:CeDwWFl4CHA.181@forums.sybase.com...
> > > > When I try and import the column types for DATE and TIME columns
using
> > the
> > > > ASAProvider, it always returns a 135 type which I believe is a
> TIMESTAMP
> > > for
> > > > all DATE and TIME columns. My setup is as below.
> > > >
> > > > Provider=ASAProv.80;Persist Security Info=False;Data Source =
ASA-ODBC
> > > >
> > > >
> > > > If I try this using the MS Provider for ODBC then it correctly
returns
> > the
> > > > column types for DATE and TIME
> > > >
> > > > For this test I used the setup below.
> > > >
> > > > Provider=MSDASQL.1;Persist Security Info=False;Data Source=ASA-ODBC
> > > >
> > > > This returns type 133 for DATE and 134 for Time columns.
> > > >
> > > > Michael Gould
> > > >
> > > >
> > >
> > >
> >
> >
>
>


Robert Waywell Posted on 2003-03-04 13:24:17.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <CeDwWFl4CHA.181@forums.sybase.com>
Subject: Re: problems with determining column types when using ASAProvider from 8.0.2
Date: Tue, 4 Mar 2003 08:24:17 -0500
Lines: 48
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
Message-ID: <kZVNrQl4CHA.287@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:789
Article PK: 3256

Sounds like a bug. Have you reproduced it in the current ebf? If so, have
you submitted the repro to Tech Support so that we can get it fixed?

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Michael Gould" <mgould@Omnicc.com> wrote in message
news:CeDwWFl4CHA.181@forums.sybase.com...
> When I try and import the column types for DATE and TIME columns using the
> ASAProvider, it always returns a 135 type which I believe is a TIMESTAMP
for
> all DATE and TIME columns. My setup is as below.
>
> Provider=ASAProv.80;Persist Security Info=False;Data Source = ASA-ODBC
>
>
> If I try this using the MS Provider for ODBC then it correctly returns the
> column types for DATE and TIME
>
> For this test I used the setup below.
>
> Provider=MSDASQL.1;Persist Security Info=False;Data Source=ASA-ODBC
>
> This returns type 133 for DATE and 134 for Time columns.
>
> Michael Gould
>
>