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
From: Wolfgang Kaml (ms_at_no-spam.kaml.com)
Date: 02/03/04
- Next message: John Timney \(Microsoft MVP\): "Re: web host provider offering ActivePDF?"
- Previous message: Scott Allen: "Re: simulate virtual directory for each user"
- Messages sorted by: [ date ] [ thread ]
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.
> >>
> >>
> >
> >
> >
>
>
- Next message: John Timney \(Microsoft MVP\): "Re: web host provider offering ActivePDF?"
- Previous message: Scott Allen: "Re: simulate virtual directory for each user"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|