Unable to add a Microsoft Access data source

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.

ODBC services do not install properly

Problem:

ODBC services do not install properly.

Solution:

You must 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>

Unable to INSERT or UPDATE an Oracle 10 database when there is a CLOB field

Problem:

Columns have a 4 KB size limit in Oracle. If a column is larger that that, 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.