In the testing I have found they have been just as fast as ODBC,
plus add in the added headaches that certain commands your used to don't
work in OLEDB, like the way dates are handled. It's really not a big deal no
article I have read has been able to give me hard numbers that prove OLEDB
is faster so I will just stick with what works.
Robert Everland III
Web Developer
Dixon Ticonderoga
-----Original Message-----
From: Rick Osborne [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 7:46 AM
To: [EMAIL PROTECTED]
Subject: RE: oledb and native drivers
Native and OLEDB are *much* faster than ODBC. (For us it they were both
literally an order of magnitude faster.)
Someone may correct me on this, but as near as I can tell there really isn't
any difference between OLEDB and Native. That is, OLEDB is essentially
"Native" for MS.
If you are using SQLServer, I really can't think of a good reason why you
wouldn't want to use OLEDB.
-Rick
-----Original Message-----
From: Brian Mitter [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 03, 2000 6:21 AM
To: [EMAIL PROTECTED]
Subject: oledb and native drivers
Hi All,
Can someone explain the difference between oledb and native drivers for
connecting to datasources?
In the CF Administrator there seems to be native drivers for Sybase11,
Oracle73, Oracle80, Informix83 and DB2. Should there be one for MS SQL? In
the oledb section of the administrator there is sqloledb and microsoft jet.
We are using CF Enterprise 4.01 and MS SQL 7.0 What is the best way to
connect to the datasources on the SQL server? Any url's for more reading
matter on oledb and native drivers? Ive tried the Allaire site but the
search is still down.
Thanks in advance
Brian
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
