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.

ADO or ODBC to connect to SQL Anywhere 8,9 .NET front end?

2 posts in General Discussion Last posting was on 2008-01-22 18:18:20.0Z
Liz Nel Posted on 2008-01-22 18:01:22.0Z
Sender: 435c.47962e53.1804289383@sybase.com
From: Liz Nel
Newsgroups: ianywhere.public.general
Subject: ADO or ODBC to connect to SQL Anywhere 8,9 .NET front end?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47962f72.437e.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Jan 2008 10:01:22 -0800
X-Trace: forums-1-dub 1201024882 10.22.241.41 (22 Jan 2008 10:01:22 -0800)
X-Original-Trace: 22 Jan 2008 10:01:22 -0800, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6689
Article PK: 4937

Hello, I was not so sure if this is an obvious answer?
But we are looking to create an application which would have
a front an interface like iGoogle.
It will be created with .NET web technologies. Is it an
obvious choice to then go with ADO to handle the connections
to the DB or DOES ADO require a ASE connection () object?
Please let me know your thoughts


Jeff Albion (Sybase iAnywhere) Posted on 2008-01-22 18:18:20.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.9 (Windows/20071031)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: ADO or ODBC to connect to SQL Anywhere 8,9 .NET front end?
References: <47962f72.437e.1681692777@sybase.com>
In-Reply-To: <47962f72.437e.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: jalbion-xp.sybase.com
X-Original-NNTP-Posting-Host: jalbion-xp.sybase.com
Message-ID: <4796336c$1@forums-1-dub>
Date: 22 Jan 2008 10:18:20 -0800
X-Trace: forums-1-dub 1201025900 10.25.98.200 (22 Jan 2008 10:18:20 -0800)
X-Original-Trace: 22 Jan 2008 10:18:20 -0800, jalbion-xp.sybase.com
Lines: 31
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6690
Article PK: 4939


Liz Nel wrote:
> It will be created with .NET web technologies.

Great! Which web technology in particular? ASP.NET?

> Is it an
> obvious choice to then go with ADO to handle the connections
> to the DB or DOES ADO require a ASE connection () object?

Arguably, Our SQL Anywhere .NET data provider is probably the most
intuitive for many .NET programmers to use, but you can also use ADO or
OLEDB. It really depends on which technology your
development/engineering/product management teams wish to work with.

Please read through our documentation to find out more about your
options for programming with SQL Anywhere Studio 9.

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbpgen9/dbpgen9.htm

ADO uses our native "ASAProv" provider - it does not reference ASE at all.

Regards,

--
Jeff Albion, Product Support Analyst
Sybase iAnywhere

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0