I know, I know, MS Access. But this task is the first step to start a process to eliminate a large number of heritage Access applications.
I am trying to use the CF9 Hibernate feature for the first time. Should I expect it to work with an Access database? The documentation seems to hint that is should, but I am getting a "Table Not Found" error that I can not understand.
I have a fifteen year old Access database, configured in ColdFusion on my workstation. The DSN tests OK with the basic MS Access driver. Using the MS Access Unicode driver throws an Jet Driver error.
I can run a basic query with <cfquery...> and retreive a simple table from this database.
This works:
<cfquery name="prefixes">
SELECT *
FROM PREFIXES
</cfquery>
<cfdump var="#prefixes#">
I try to set this up with ORM as follows:
Applicaiton.cfc
<cfcomponent>
<cfscript>
this.name = "eval_scientists";
this.datasource = "eval_scientists";
this.ormenabled = true;
this.ormsettings = {
dialect = "MicrosoftSQLServer",
logsql = true
};
</cfscript>
</cfcomponent>
prefixes.cfc
<cfcomponent persistent="true" table="PREFIXES">
<cfproperty name="id" column="PREFIX">
<cfproperty name="description" coluumn="DESCRIP">
</cfcomponent>
test code
<script>
prefixes = EntityLoad("prefixes");
</script>
<cfdump var="#prefixes#">
Running this version produces this error:
Table PREFIXES defined for cfc eval-scientists-orm.cfc.prefixes does not exist.
Is there any hope for me? Or am I just out of luck with this combination of technologies?
7
Replies
But I can at least confirm your test code worked for me. 
AdChoices