Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!postnews.google.com!r1no9691753qas.0!news-out.google.com!c6ni32064692qas.0!nntp.google.com!newsfeed2.dallas1.level3.net!news.level3.com!newsfeed-00.mathworks.com!pit-in1.telstra.net!news.telstra.net!61.9.128.156.MISMATCH!viwinnwcl01.internal.bigpond.com!viwinnwfe02.internal.bigpond.com.POSTED!7564ea0f!not-for-mail
From: Jason Keats <jkeats@melbpcDeleteThis.org.au>
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:14.0) Gecko/20120715 Firefox/14.0.1 SeaMonkey/2.11
MIME-Version: 1.0
Newsgroups: comp.databases.ms-sqlserver,microsoft.public.sqlserver.programming
Subject: Re: SSE2008: #Tables, Stored Procedures, Avoiding ActiveX
References: <b3ge181eguiicnuugkkak08jcpq3a0hmgd@4ax.com> <jv97uf$hgk$1@dont-email.me> <iflg18t2s69a3m35ql469qmpreq7r26g55@4ax.com> <XnsA0A25E0BE15F2Yazorman@127.0.0.1>
In-Reply-To: <XnsA0A25E0BE15F2Yazorman@127.0.0.1>
Lines: 26
Message-ID: <gR4Tr.61$Wo3.44@viwinnwfe02.internal.bigpond.com>
Date: Sat, 04 Aug 2012 18:14:03 +1000
NNTP-Posting-Host: 138.217.106.169
NNTP-Posting-Date: Sat, 04 Aug 2012 18:14:04 EST
Organization: BigPond
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 7bit
Xref: csiph.com comp.databases.ms-sqlserver:1209

Erland Sommarskog wrote:
> Gene Wirchenko (genew@ocis.net) writes:
>>       My understanding is that in order to access the data with the
>> browser, I have to create an ADODB.Connection object and an
>> ADODB.Recordset object using ActiveXObject() which Firefox (for
>> example) does not have.  If there is another way of doing it, I would
>> be delighted to find out how.
>
> Old ADO is a technology that dead in the sense that there is no further
> development with it - and has not been for a decade or so. It exists
> in legacy applications, but it is nothing you should use for a new
> application in 2012. ADO was crap already in its heyday, and now it also
> suffers from lack of support for new features in SQL Server.
>
> You should use ADO .Net, or possibly JDBC or PHP as your data access API.
> (The old thing old ADO and ADO .Net has in common are three letters.)
>
> As for being browser-independent or not - if you make your application
> to run on IE only, you will have to deal with irritated users who prefers
> to use a different browser.

ADO was installed as part of MDAC, but is now part of WDAC which comes 
with the operating system of Windows Vista and later. ADO is not yet 
deprecated, and is (AFAIK still) THE way to access your SQL Server data 
- if you're not using a .NET programming language.