Is it true that if you have an ole access ds setup, you can connect to any
mdb file on the system?
Also, is it possible to do things such as setup default field values etc
which arent possible through JET on odbc through OLE???
cheers
-----Original Message-----
From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: 12 March 2001 11:01
To: CF-Talk
Subject: RE: Dates in OLEDB
> Could somone summarise / point me to a location listing the advantages /
> disadvantages of OLE vs ODBC for connecting within CF...?
OLEDB is (theoretically) faster as it's using the database's "native"
language - this isn't always faster though - some aspects will be faster,
some slower
ODBC has memory leaks on some drivers (Access specifically)
ODBC dates don't work in OLEDB - you have to specify the dates in the format
the database expects - with ODBC, CreateODBCdate works no matter which
server as the ODBC driver converts it for you
ODBC and OLEDB have a natural limit of 64KB on field transfers - CF4.5 has
the ability to extend this, but at a speed degridation on all queries to
that DSN
OLEDB can be a bitch to setup, but once it's working you can just let it get
on with it
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
