Access Vs Access with Unicod

[ThalesDeMilet]

Following the execution of a script to re-install the ODBC services in
CFMX6.1(standard), we lost the capacity to create dsn with access driver. I
found in forums that we can go around the problem creating it using access with
unicode and it actually worked. I'd like to make sure that both driver are
equivalent tough. Can someone explain to me what is the difference between the
2 drivers. Thanks.

[Mountain Lover]

As I understand it...
The "Access" driver uses the macromedia driver which uses the JDBC:ODBC
bridge (a type 1 driver)
The "Unicode" driver uses the Izmado driver which utilizes OLEDB and is
a Type 2 driver
([url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001742.htm[/url]) and
is slightly better than the type 1 driver
HTH
--
Tim Carley
[url]www.recfusion.com[/url]
[email]info@NOSPAMINGrecfusion.com[/email]

[PaulH *ACE*]

ThalesDeMilet wrote:

> equivalent tough. Can someone explain to me what is the difference between the
> 2 drivers. Thanks.

i don't know all the differences but the access for unicode driver has a
different set of reserved words.

[LL@Work]

[url]http://www.macromedia.com/devnet/coldfusion/articles/globalize_02.html[/url] may help.
do a Find on 'Unicode"

[Survivorman]

Is it possible to use the unicode driver with a password protected access db?