Problem:

When you try to add a Microsoft Access data source, an error appears:

Solution:

Install and start up the ODBC service, or use the Microsoft Access with Unicode driver.

Problem:

ODBC services do not install properly.

Solution:

Remove the existing ODBC services using the following code:

<cfscript> 
        writeOutput("Installing ODBC Services...<br>"); 
        returnValue = myObj.installODBCservice(); 
        writeOutput("ODBC Services installed"); 
    </cfscript>

You then reinstall the ODBC services using the following code:

<cfscript> 
    writeOutput("Removing ODBC Services...<br>"); 
    returnValue = myObj.removeODBCservice(); 
    writeOutput("ODBC Services removed"); 
</cfscript>

Problem:

Columns have a 4 KB size limit in Oracle. If a column is larger that the 4 KB size limit, when you try to use either the cfinsert or cfupdate tag, the following error is generated:

ORA-01704: string literal too long 

Solution:

To avoid this error, use either the cfquery or cfqueryparam tag.