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.

Using SAOLEDB.10 provider to access SQL Anywhere 9.0.2

5 posts in General Discussion Last posting was on 2008-11-23 19:57:19.0Z
John Posted on 2008-11-20 01:41:36.0Z
Sender: 3f76.4924bbe3.846930886@sybase.com
From: John
Newsgroups: ianywhere.public.general
Subject: Using SAOLEDB.10 provider to access SQL Anywhere 9.0.2
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4924c050.3fdd.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 19 Nov 2008 17:41:36 -0800
X-Trace: forums-1-dub 1227145296 10.22.241.41 (19 Nov 2008 17:41:36 -0800)
X-Original-Trace: 19 Nov 2008 17:41:36 -0800, 10.22.241.41
Lines: 6
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7172
Article PK: 5386

Is it possible to use ECC security (TLS) built with 9.0.2 to
access 9.0.2 database from ODBC using SAOLEDB.10 provider. I
had no success doing this with ASAProv9.0 provider using
.NET framework 2.0 and XP with SP3. Microsoft recommended
using latest SQL Anywhere provider with .NET framwork 2.0 on
XP + SP3


Shuchit Posted on 2008-11-20 17:21:06.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Using SAOLEDB.10 provider to access SQL Anywhere 9.0.2
From: Shuchit <me@privacy.net>
References: <4924c050.3fdd.1681692777@sybase.com>
Message-ID: <Xns9B5C7D9FDD9E4svelkarprivacynet@127.0.0.1>
User-Agent: Xnews/2006.08.24 Hamster/2.1.0.11
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 20 Nov 2008 09:21:06 -0800
X-Trace: forums-1-dub 1227201666 10.22.241.152 (20 Nov 2008 09:21:06 -0800)
X-Original-Trace: 20 Nov 2008 09:21:06 -0800, vip152.sybase.com
Lines: 20
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7188
Article PK: 5405


John wrote in news:4924c050.3fdd.1681692777@sybase.com:

> Is it possible to use ECC security (TLS) built with 9.0.2 to
> access 9.0.2 database from ODBC using SAOLEDB.10 provider. I
> had no success doing this with ASAProv9.0 provider using
> .NET framework 2.0 and XP with SP3. Microsoft recommended
> using latest SQL Anywhere provider with .NET framwork 2.0 on
> XP + SP3

I am a bit confused on what you are trying to do. Are you trying to access
the OLEDB provider via ODBC ?

Also, ECC support requires the strong encryption option, which is a separate
purchase.

Since you are using .NET, have you tried using the SQL Anywhere .NET provider
rather than going the OLEDB route?


Shuchit


John Posted on 2008-11-21 02:00:33.0Z
Sender: 62d3.49261515.1804289383@sybase.com
From: John
Newsgroups: ianywhere.public.general
Subject: Re: Using SAOLEDB.10 provider to access SQL Anywhere 9.0.2
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49261641.62e8.1681692777@sybase.com>
References: <Xns9B5C7D9FDD9E4svelkarprivacynet@127.0.0.1>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Nov 2008 18:00:33 -0800
X-Trace: forums-1-dub 1227232833 10.22.241.41 (20 Nov 2008 18:00:33 -0800)
X-Original-Trace: 20 Nov 2008 18:00:33 -0800, 10.22.241.41
Lines: 27
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7195
Article PK: 5410

We have purchased ECC & FIPS. No I have not used SQL
Anywhere .NET provider for 9.0.2.

I want to access(read/write) 9.0.2 Server (over the network)
with TLS from another machine using 9.0.2 client software.
At present I am using ODBC/SAOLEDB.10 with .NET

> John wrote in news:4924c050.3fdd.1681692777@sybase.com:
>
> > Is it possible to use ECC security (TLS) built with
> > 9.0.2 to access 9.0.2 database from ODBC using
> > SAOLEDB.10 provider. I had no success doing this with
> > ASAProv9.0 provider using .NET framework 2.0 and XP with
> > SP3. Microsoft recommended using latest SQL Anywhere
> > provider with .NET framwork 2.0 on XP + SP3
>
> I am a bit confused on what you are trying to do. Are you
> trying to access the OLEDB provider via ODBC ?
>
> Also, ECC support requires the strong encryption option,
> which is a separate purchase.
>
> Since you are using .NET, have you tried using the SQL
> Anywhere .NET provider rather than going the OLEDB route?
>
>
> Shuchit


Shuchit Posted on 2008-11-22 01:52:46.0Z
Newsgroups: ianywhere.public.general
Subject: Re: Using SAOLEDB.10 provider to access SQL Anywhere 9.0.2
From: Shuchit <me@privacy.net>
References: <Xns9B5C7D9FDD9E4svelkarprivacynet@127.0.0.1> <49261641.62e8.1681692777@sybase.com>
Message-ID: <Xns9B5DD45C7AC7svelkarprivacynet@127.0.0.1>
User-Agent: Xnews/2006.08.24 Hamster/2.1.0.11
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 21 Nov 2008 17:52:46 -0800
X-Trace: forums-1-dub 1227318766 10.22.241.152 (21 Nov 2008 17:52:46 -0800)
X-Original-Trace: 21 Nov 2008 17:52:46 -0800, vip152.sybase.com
Lines: 28
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7206
Article PK: 5423


>>> Is it possible to use ECC security (TLS) built with
>>> 9.0.2 to access 9.0.2 database from ODBC using
>>> SAOLEDB.10 provider. I had no success doing this with
>>> ASAProv9.0 provider using .NET framework 2.0 and XP with
>>> SP3. Microsoft recommended using latest SQL Anywhere provider with
>>> .NET framwork 2.0 on XP + SP3
>>
>> I am a bit confused on what you are trying to do. Are you
>> trying to access the OLEDB provider via ODBC ?
>>

> We have purchased ECC & FIPS. No I have not used SQL
> Anywhere .NET provider for 9.0.2.
>
> I want to access(read/write) 9.0.2 Server (over the network)
> with TLS from another machine using 9.0.2 client software.
> At present I am using ODBC/SAOLEDB.10 with .NET
>

Look at the examples in <http://tinyurl.com/58fjqz> which points to
<http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/
dbseen9/00000050.htm>

If you have already tried something similar, please provide details on
exactly what you tried and the exact error or issue you are seeing. Also,
include the build number that you are using (dbeng9 -v).

Shuchit


John Posted on 2008-11-23 19:57:19.0Z
Sender: 6c7d.4929b176.846930886@sybase.com
From: John
Newsgroups: ianywhere.public.general
Subject: Re: Using SAOLEDB.10 provider to access SQL Anywhere 9.0.2
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4929b59f.6ccd.1681692777@sybase.com>
References: <Xns9B5DD45C7AC7svelkarprivacynet@127.0.0.1>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Nov 2008 11:57:19 -0800
X-Trace: forums-1-dub 1227470239 10.22.241.41 (23 Nov 2008 11:57:19 -0800)
X-Original-Trace: 23 Nov 2008 11:57:19 -0800, 10.22.241.41
Lines: 36
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7210
Article PK: 5428

I am not going to go after this problem anymore. Instead of
using ODBC I will be using Anywhere provider for .NET on the
program itself. It works out great during testing.

Thank you for your help.

> >>> Is it possible to use ECC security (TLS) built with
> >>> 9.0.2 to access 9.0.2 database from ODBC using
> >>> SAOLEDB.10 provider. I had no success doing this with
> >>> ASAProv9.0 provider using .NET framework 2.0 and XP
> with >>> SP3. Microsoft recommended using latest SQL
> Anywhere provider with >>> .NET framwork 2.0 on XP + SP3
> >>
> >> I am a bit confused on what you are trying to do. Are
> you >> trying to access the OLEDB provider via ODBC ?
> >>
>
> > We have purchased ECC & FIPS. No I have not used SQL
> > Anywhere .NET provider for 9.0.2.
> >
> > I want to access(read/write) 9.0.2 Server (over the
> > network) with TLS from another machine using 9.0.2
> > client software. At present I am using ODBC/SAOLEDB.10
> > with .NET
>
> Look at the examples in <http://tinyurl.com/58fjqz> which
> points to
> <http://www.ianywhere.com/developer/product_manuals/sqlany
> where/0902/en/html/ dbseen9/00000050.htm>
>
> If you have already tried something similar, please
> provide details on exactly what you tried and the exact
> error or issue you are seeing. Also, include the build
> number that you are using (dbeng9 -v).
>
> Shuchit