OLE and ODBC perform around the same, sure sometimes each one may run faster
than the other in some cases but the whole process has been known to reverse
itself!
_____
From: cfhelp [mailto:[EMAIL PROTECTED]
Sent: 31 October 2003 15:33
To: CF-Talk
Subject: RE: ODBC vs. OLE
Here is the last post on the list I thought I would share it here.
Pasting from IIS List
>
> -------------------------
> Why does OLEDB perform better? Well it is quite simple actually. I'm
> glad you asked. ADO *requires* having access to an OLEDB provider. So
> when you use a DSN you are actually using the "Microsoft OLE DB
> Provider for ODBC drivers". So you pass through the above provider and
> enter the ODBC drivers. After a certain number of cycles the ODBC code
> finally figures out your DSN is to connect to SQL. And whoah!! we
> happen to have an OLEDB provider that can connect to SQL. So ODBC
> moves on into the OLEDB provider for SQL.
> Finally we use dbnetlib.dll to make the final connection to SQL,
> retrieve our data then go back through all the same layers in order to
> return the data to your ASP page.
>
> So my next question for you is... why do "ADO->OLEDB for
> ODBC->ODBC->OLEDB for SQL" and need to go through the hastle
> of setting
> of DSN's when you can simply do "ADO-->OLEDB for SQL" and not have to
> setup anything?
>
> To create a valid OLEDB connection string:
> 1. Create a text file somewhere.
> 2. Rename the text file so it has a UDL extension
> 3. Double click your new UDL file.
> 4. Change to the Providers tab and choose "Microsoft OLE DB Provider
> for SQL"
> 5. Change to the "Connection" tab and enter the appropriate
> information
> 6. Click Okay then open the UDL file with notepad.
> 7. Take your new connection string and replace all the cn.Open "DSN"
> with cn.Open "My nice long performant connection string"
> -------------------------
>
> -----Original Message-----
> From: Sunil Shetty [mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> ]
> Sent: Friday, October 31, 2003 1:01 AM
> To: IIS 5 Discussions
> Subject: Re: [iis5] RE: ODBC connection tool
>
> any good reasons !!
>
> ----- Original Message -----
> From: "Brian Murphy-Booth" <[EMAIL PROTECTED]>
> To: "IIS 5 Discussions" <[EMAIL PROTECTED]>
> Sent: Thursday, October 30, 2003 8:20 PM
> Subject: RE: [iis5] RE: ODBC connection tool
>
>
> Just a reminder: ODBC is outdated. Use OLEDB.
>
Comments???
Rick
_____
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]
Sent: Friday, October 31, 2003 9:02 AM
To: CF-Talk
nonsense...this is typical from a MS list ;-)
No matter what they say etc...there are no performance advantages of OLE
over ODBC.
Its certainly not outdated....well, no more than DOS!
_____
From: cfhelp [mailto:[EMAIL PROTECTED]
Sent: 31 October 2003 15:02
To: CF-Talk
Subject: ODBC vs. OLE
I am on an IIS list and someone said that ODBC was outdated and OLE is what
should be used.
I have never used OLE and I wanted to here some pros and cons of using OLE
vs. ODBC.
Rick
_____
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
