Re: amazing finding (!!!) - MS folks, pls check this out!!! Re: annoying delay during refresh of aspx web page with ODBC Access query on IIS Windows 2003

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Wolfgang Kaml (ms_at_no-spam.kaml.com)
Date: 02/03/04


Date: Tue, 3 Feb 2004 10:48:57 -0800

Thanks for that clarification. Sounds like MS Access has evolved to be a
convenient front end for MSDE. As of what version of MS Access will there be
MSDE sitting behind the scene?

Wolfgang

"Scot Rose [MSFT]" <scotr@online.microsoft.com> wrote in message
news:$XBfYXP5DHA.2920@cpmsftngxa07.phx.gbl...
> >- Is Microsoft now calling their MS Jet OLE DB provider obsolete as
well? -
> >In other words, will they drop supporting MS Access?
>
> Actually Jet support in MDAC was dropped as of version 2.6. There are
newer components that have been released in subsequent
> Service packs for Jet, But in the long run, Yes, Jet is being obsoleted.
It will probably take some time considering the large number of
> developers that use it but going forward with new development work it is
suggested that developers use the MSDE (Note that recent
> versions of Access also use MSDE and at some point Jet may no longer be
supported in Access)
>
>
> Scot Rose, MCSD
> Microsoft Visual Basic Developer Support
> Email : scotr@online.microsoft.com <Remove word online. from address>
>
> This posting is provided "AS IS", with no warranties, and confers no
rights.
>
> Get Secure!
> http://www.microsoft.com/security
> http://www.microsoft.com/protect
>
>
> --------------------
> >Reply-To: "Wolfgang Kaml" <ms@no-spam.kaml.com>
> >From: "Wolfgang Kaml" <ms@no-spam.kaml.com>
> >References: <eEpBTwR4DHA.2304@TK2MSFTNGP10.phx.gbl>
<#xWcv6S4DHA.2428@tk2msftngp13.phx.gbl> <eT7LKdT4DHA.1868
> @TK2MSFTNGP10.phx.gbl> <unTKMJU4DHA.2384@TK2MSFTNGP10.phx.gbl>
<##LJhVU4DHA.1504@TK2MSFTNGP12.phx.gbl>
> >Subject: Re: amazing finding (!!!) - MS folks, pls check this out!!! Re:
annoying delay during refresh of aspx web page with ODBC Access
> query on IIS Windows 2003
> >Date: Thu, 22 Jan 2004 17:40:42 -0800
> >Lines: 55
> >Organization: KAML DOT COM CONSULTING
> >X-Priority: 3
> >X-MSMail-Priority: Normal
> >X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
> >X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
> >Message-ID: <#aUD0HV4DHA.2348@TK2MSFTNGP10.phx.gbl>
> >Newsgroups:
>
microsoft.public.dotnet.framework.adonet,microsoft.public.dotnet.framework.a
spnet,microsoft.public.inetserver.asp.general
> >NNTP-Posting-Host: adsl-66-122-66-234.dsl.anhm01.pacbell.net
66.122.66.234
> >Path:
cpmsftngxa07.phx.gbl!cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP10.
phx.gbl
> >Xref: cpmsftngxa07.phx.gbl
microsoft.public.dotnet.framework.aspnet:204403
microsoft.public.inetserver.asp.general:263626
> microsoft.public.dotnet.framework.adonet:72417
> >X-Tomcat-NG: microsoft.public.dotnet.framework.aspnet
> >
> >3 more interesting things here:
> >
> >1) I did some more testing on the ODBC vs. OLEDB part and found out, that
> >without using DSN but referencing the file name directly in the ODBC
code,
> >the ODBC version is just as fast as OLEDB. It's DSN that's causing the
> >problem.
> >
> >2) I just worked for a while with Crystal Reports and the only way you
can
> >connect to an Access DB is using a DSN. Interesting to watch: Microsoft
is
> >making ODBC obsolete, but making a product, that's using ODBC to connect
to
> >their database 'de-facto' standard and ships it with their own product
> >(refering to Crystal Reports for VS.NET). A good idea for MS would have
been
> >to just buy that company, because they are changing their name so fast,
it's
> >hard to keep track of them. But my appology, put that on a different note
> >...
> >
> >3) - And that's actually the most important _QUESTION_ here:
> >You are linking to a very good article. I am not sure if I am
understanding
> >everything correct that's being said on that but...
> >- Is Microsoft now calling their MS Jet OLE DB provider obsolete as
well? -
> >In other words, will they drop supporting MS Access?
> >
> >Thank you,
> >Wolfgang
> >
> >
> >"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
> >news:%23%23LJhVU4DHA.1504@TK2MSFTNGP12.phx.gbl...
> >> Wolfgang Kaml wrote:
> >> > Dear MS folks,
> >> > That's what I call a real bug! Please check it and fix it, or drop
> >> > ODBC
> >> > support on Windows 2003 server, because it is a hassle.
> >> >
> >>
> >> ODBC has been on the Deprecated Components list for at least 2, and
> >possibly
> >> 3 versions of MDAC
> >>
(http://msdn.microsoft.com/library/en-us/ado270/htm/ado_deprecated.asp).
> >> Unfortunately, the word has not made it to the rank and file. Too many
> >books
> >> have been written in the past 10 yrs using the obsolete technology, and
> >> beginners are still reading those books. There's nobody to tell these
> >> readers that the information in their books is obsolete.
> >>
> >> Bob Barrows
> >> --
> >> Microsoft MVP -- ASP/ASP.NET
> >> Please reply to the newsgroup. The email account listed in my From
> >> header is my spam trap, so I don't check it very often. You will get a
> >> quicker response by posting to the newsgroup.
> >>
> >>
> >
> >
> >
>
>



Relevant Pages

  • Aktualisierung a2K odbc msde
    ... Ich verwende bei einer Anwendung A2K in Verbindung mit ODBC und MSDE. ... Meine .mdb DAtei nimmt gigantische Größen an, ... z.B. beim Neuanlegen von Datensätzen bleiben die ...
    (microsoft.public.de.access.clientserver)
  • Problem with MSDE SP3A on XP SP2
    ... we are using MSDE quite long using ODBC without problems on MS-Windows 2000 ... after several queries the sql-server does not answer anymore. ... after starting our db-interface process of the sql-server it all works again. ... Looks like an odbc problem to me ... ...
    (microsoft.public.sqlserver.msde)
  • Re: Msde ot Jet?
    ... > connection to msde and link tables via ODBC. ... Or, even easier, use an ADP, which is specifically designed to talk to MSDE ... if you take care to minimise network traffic, ... to have a Connection object in use all the time though, ...
    (microsoft.public.access.tablesdbdesign)
  • RE: MSDE ODBC connection fails
    ... on PC 3 which didn't have MSDE installed and I can now make an ODBC ... The Microsoft Access Data Components include an updated SQL Server ODBC ... > I can set-up an ODBC connection through TCP/IP port and named pipes from PC ... > Originally PC 2 did not have MSDE installed and a TCP/IP ODBC connection ...
    (microsoft.public.sqlserver.msde)