Error creating DSN with "Microsoft Access with UnicodeSupport"

[SMuc_Pac]

Here's the error message I get:

Connection verification failed for data source: cftest_unicode
[]com.inzoom.adojni.ComException: Unspecified error
The root cause was that: com.inzoom.adojni.ComException: Unspecified error in
Microsoft JET Database Engine code=0 Type=1

Where do I start to debug this? Regular access DSNs work fine.

[SafariTECH]

the first thing I would check is that the latest JET and MDAC driver updates are installed on the system with the Access Database

[SMuc_Pac]

MDAC - 2.71.9040.2
JET - not sure but we have DAO 3.6, I can't seem to find a simple way of determining the JET version number. Any ideas?

[PaulH]

might try [url]http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=2d2a7a19&pss=rss_coldfusion_2d2a7a19[/url] to see if it brings any relief.

[SMuc_Pac]

Thanks but that doesn't seem to work either:

Connection verification failed for data source: cftest_unicode
[]com.inzoom.adojni.ComException: [Microsoft][ODBC Microsoft Access Driver]
System resource exceeded.
The root cause was that: com.inzoom.adojni.ComException: [Microsoft][ODBC
Microsoft Access Driver] System resource exceeded. in Microsoft OLE DB Provider
for ODBC Drivers code=0 Type=1

[PaulH]

a bit of google turned up
[url]http://www.sitepoint.com/forums/showthread.php?t=254675[/url] plus a bunch of stuff
all over the map. enough free disk space? how big is that db? got the proper
permissions? too much ram to java heap?

[SMuc_Pac]

Disk partition has several gigs free.
The Access DB only has 1 table with 1 row.
CF is running as SYSTEM and SYSTEM definitely has permissions to this file
The machine has 2Gigs of RAM and the JVM heap is set to 1024MB.

Everything else on the server is running fine. Why could creating a DSN result
in a Resource Allocation error? Why can't I simply choose "Microsoft Access
with Unicode" in the CFAdmin area? What logs do you need to see in order to
better assist me with this problem?

[SMuc_Pac]

I'm still having this problem... can anyone else help?

[PaulH]

WAG but what's the table name? column names? that driver's reserved word list is different from ms access's.

[SMuc_Pac]

WAG???

I tried my own test DB created with Access 2003. The only table name is 'test'
with a column named 'test'. Creating a DSN pointing to that .mdb file using
'Microsoft Access with Unicode Support ' driver causes the same error as in my
first post.

The customer reports that creating the DSN works fine in their CFMX 7 test
environment.

What's the best way to get the current JET version number?

[PaulH]

WAG == wild a*s*s-ed guess. you can see driver info via the control panel,
data sources (ODBC).

as an experiment, maybe try
[url]http://www.sustainableGIS.com/unicode/unicodeTB.zip[/url] access database *as is*.
don't convert it to access 2003, etc.

[SMuc_Pac]

I tried your DB file and I got the same error.

The DSN I created does not show up in the ODBC DSN Administrator in Windows.
This is because the JET drivers aren't ODBC, they are OLEDB right? The Access
ODBC driver version I have is 4.00.6200.00.

[KenTack]

I came here very often for last a couple of days to check for something new
about the problem because I got the same error message when creating a
datasource with "Microsoft Access with Unicode". Have you found out any
solution to the problem? Anyway, I could finally create a datasource with it
however I decided to install web stuff such as IIS, coldfusion and etc. once
again from the beginning. I hope this becomes a clue to the problem. I want to
know a genuine solution.

What I did is "uninstallation" and "reinstallation" of some programs:

Software | Action (U/R) | Result
-------------------------------------------------------------------------
ColdFusion | U | not created
ColdFusion | R | not created
-------------------------------------------------------------------------
MS Office 2003 | U | not created
MS Office 2003 | R | not created
-------------------------------------------------------------------------
MS Office 2003 SP1 | U | not created
MS Office 2003 SP1 | R | not created
-------------------------------------------------------------------------
WIndows 2003 SP1 | U | not created
Windwos 2003 SP1 | R | CREATED
-------------------------------------------------------------------------
U - Uninstallation
R - Reinstallation

Since I removed Coldfusion once, I lost everything about configurations of my
ColdFusion. And when I removed SP1 of Windows 2003, he threatened me that some
applications installed in my computer wouldn't work after the uninstallation
although he kindly gave me an option to choose "yes" or "no".