ODBC requires translation between the source and destination...OLE DB does
not which makes OLE DB faster
Bernd VanSkiver
[EMAIL PROTECTED]
ICQ #: 916324
-----Original Message-----
From: Andres [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 08, 2001 3:14 PM
To: CF-Talk
Subject: Differences between OLE DB and ODBC
Hope someone can help in any way...
I posted this message early this morning, and have received no responses. If
any one has any clue, no matter how insignificant, or if you have any ideas
as to where i can find out more details about the differences between OLE DB
and ODBC, please post them.
Thank you.
*******************************************
Good morning all,
I Created a page that accesses the same database table but with two
different datasources as shown below:
<cfquery name="FindUsers" datasource="facilitadortestsite_ole"
dbtype="OLEDB" debug>
SELECT *
FROM TeaserUsers
</cfquery>
<cfquery name="FindUsers_odbc" datasource="facilitadortestsite"
dbtype="ODBC" debug>
SELECT *
FROM TeaserUsers
</cfquery>
I outputted the total record count for each query in the following way:
<cfoutput>
#FindUsers.recordcount# users found under OLE<br>
#FindUsers_odbc.recordcount# users found under ODBC<br>
</cfoutput>
Here are my results:
5 users found under OLE
76 users found under ODBC
----------------------------------------------------------------------------
----
Queries
FindUsers (Records=5, Time=250ms)
SQL =
SELECT *
FROM TeaserUsers
FindUsers_odbc (Records=76, Time=31ms)
SQL =
SELECT *
FROM TeaserUsers
Why is it that OLE DB is reporting only 5 records, while ODBC is reporting
ALL of them as it should be, based on the query?
Any help will be greatly appreciated!
Andres
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
