Connection Fail - Access with Unicode

[My_Pal_Al]

All of a sudden I am getting this error when I try to verify my Microsoft Access with Unicode files. My other connections still work.

Connection verification failed for data source: bct_db
com.inzoom.jdbcado.JdbcAdoException: could not load izmjniado.dll Can't load library: c:\program files\infozoom\izmjniado.dll
The root cause was that: com.inzoom.jdbcado.JdbcAdoException: could not load izmjniado.dll Can't load library: c:\program files\infozoom\izmjniado.dll

How do I fix this?

[CFTofinha_Inove]

Look the TechNote below:

http://kb2.adobe.com/cps/452/67c452e5.html

[KosivArt]

The given link is dead, do you have some workaround for that, because I have the same problem?

Recently I've moved from CFMX 7.0 Intermediate to CF9 Intermediate plan and MS Access DB started to output "??" instead of Ukrainian letters, though English outputs OK.

So I have deleted and added the same datasourses but now with Unicode support in control panel and got this strange error:

Error Executing Database Query.

could not load izmjniado.dll Can't load library: c:\program files\infozoom\izmjniado.dll

It's a simple select query that worked OK on previous plan and support says that unicode is set up OK on CF9.

I didn't find anything helpfull in Google about that error so I have to move back to old plan

Any suggestions from CF specialists here would be really appreciated! Please, help!

[Guest]

>I didn't find anything helpfull in Google about that error so I have to move back to old plan

Maybe you should consider HXTT's pure Java solution at http://www.hxtt.com/access.html , which supports UNICODE. If your MS Access is 2000~2010 format, you needn't any special setting. If your MS Access is 95~97 format, you need to set charSet connection property.

[KosivArt]

Thank you for advice, but since I'm on shared environment I don't have access to server settings

[Guest]

>but since I'm on shared environment I don't have access to server settings

It needn't server settings. If your Java VM allow the file i/o right on that mdb file, it can be accessed.