Driver type with MS Access

[Dyonisus]

Hello,
I realized an application, for maintaining data, that another (java/jsp)
application uses. There, for data base connection they use a JDBC-ODBC bridge.
But now we have problems with unicode. So here my questions:
In the CF-docu they say, that MS Acess with unicode uses the type 2 of jdbc
driver which means 'Native-API/partly Java driver'.
How can I change this to a JDBC-ODBC bridge?
Which driver type is using MS Access (without unicode capability)?
Would a 'Default driver' solve this (is using the JDBC-ODBC bridge)... and if,
what do I have to fill in for driver class and driver name? I tried -> jdbc:
odbc: Driver={MicroSoft Access Driver (*.mdb)} and ->
sun.jdbc.odbc.JdbcOdbcDriver but it did not work.
-> Message: No suitable driver available for ....

Thanks

[mxstu]

Some of the answers depend on your version

1) What version of ColdFusion are you using?
2) Are you looking for a driver for MS Access that does or does not support
unicode?
3) Are you creating trying to create a datasource through the CF Administrator?

[url]http://developers.sun.com/product/jdbc/drivers[/url]

[zhaoyh.hxtt@gmail.com]

>But now we have problems with unicode.
You can try Hxtt Access, a commercial type 4 JDBC driver for MS Access,
at [url]http://www.hxtt.net/access/[/url] .

Yonghong Zhao
System Analyst
[url]www.hxtt.net[/url]

[Dyonisus]

Here my answers:
1) We are using CF MX, Version 6(,1,0,63958)
2) A driver that supports unicode. The java application uses the jdbc-odbc
bridge. They are reading the db result as bytes and then convert them to a
string. Here their code:
while(rs.next){
bytes[] b = rs.getBytes(1);
String outString = new String(b, "UTF-8);
}
Using the String, that I write into the database (with MS-Access supporting
unicode or not) the result is not correct.
3) Yes