8.1.7 ODBC driver to 8.0.5 database

From: James Juran <juranj_at_mail.nih.gov>
Date: Wed, 15 Aug 2001 14:59:47 -0400
Message-ID: <3B7AC6A3.51C3F87F@mail.nih.gov>

We have a Microsoft Access 2000 application that connects to an Oracle 8.1.6 database and an Oracle 8.0.5 database via ODBC. The ODBC drivers are version 8.1.7.4.0. We have a query that retrieves data stored in a column of type LONG. When this query runs on the 8.1.6 database, it works if the "Force retrieval of longs" option is set in the ODBC control panel. If this option is not set, the query gets the following error: "3702: The width of a Unicode text column must be an even number of bytes".

If I run this query against the 8.0.5 database, I get this error regardless of whether the "Force retieval of longs" option is checked. Is this a problem to be expected when using an 8.1.7 ODBC driver with an 8.0.5 database? Unfortunately, changing the ODBC version or upgrading the databases are not viable options right now. If anyone has any suggestions for how to prevent this error, I'd greatly appreciate hearing them.

Thank you,

--
James Juran
juranj_at_mail.nih.gov

Received on Wed Aug 15 2001 - 13:59:47 CDT