[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== ENG0010: XOCACHE error or "how to configure the ODBC driver" (OpenInsight 32-bit Specific) ====
=== At 06 MAY 2003 02:40:50PM Wilhelm Schmitt wrote: ===
 
{{tag>"OpenInsight 32-bit Specific"}}
 
<QUOTE>
When I try to configure the DataSet for the DBF example (Chapter 4: Getting Started with Client/Server Data) I get the error [b]ENG0010: XOCACHE line 909 Variable has not been assigned a value.[/b]. After that, the system hangs and I have to jump out of the window by closing the task.



This happens, when I try to define the DataSet entity after selecting "DBF_OI" from the list of data sources. The Connection entity doesn¡t present any problem.



The data location with the EMPLOY.DBF and PRODUCT.DBF and DBT is C:\REVSOFT\OI32Bit\TUTORIAL.



The [b]ODBC.INI[/b] file in the \Windows subdirectory looks like this:

ODBC 32 bit Data Sources

DBF_OI=Microsoft dBase Driver (*.dbf) (32 bits)

DBF_OI

Driver32=C:\WINDOWS\System32\odbcjt32.dll



Since I am completely new to this type of handling data, I don't know, whether the problem derives from the ODBC configuration or something else.



Any comments will be appreciated.



Wilhelm





BTW: 

several threads on this forum point to a white-paper that suggests to use 16bit connection and copy around in the ODBC.INI file. I assume that with OI32 this has become history. Please correct, if I am wrong.
</QUOTE>
----

=== At 06 MAY 2003 03:06PM Sean FitzSimons wrote:  ===

<QUOTE>Wilhelm,



What version of OpenInsight are you running?  The XOCACHE error occurred prior to OI 4.1.3, but was fixed since then.  



The ODBC.ini file changes are history!



Sean

</QUOTE>

----

=== At 06 MAY 2003 03:24PM Wilhelm Schmitt wrote:  ===

<QUOTE>Sean,

I use OI ver 4.1.2

Wilhelm

</QUOTE>

----

=== At 07 MAY 2003 09:39AM Bob Carten  wrote:  ===

<QUOTE>Wilhelm:



I just tried dbase with OI4.13, it worked.



made a dbase4 file from Excel, saved it to its own subdirectory

made an ODBC connection using microsoft ODBC driver 4.00.6200.00

used query window to SELECT * from BOOK1, no problem.

Made a dataset against Book1, was able to create a popup which showed

all the data.



Made a form but it did not update as the dbase file had no key defined.





BTW you are correct about the editing of the INI file.  That is not needed for OI 32.





Bob

</QUOTE>

----

=== At 07 MAY 2003 10:51AM Wilhelm Schmitt wrote:  ===

<QUOTE>I tried on a different machine with WinXP and OI413 - Examples work perfect.



Question 1:

I still use OI412 on my computer, because we have not yet resolved the issue of WAN configuration (pending on the OI-WORKS section). 

In the meantime, is there a patch for ODBC on OI412?



Question 2 on other ODBC datasources:

Is it possible to acces Excel and Word documents through ODBC connection?



Regards

Wilhelm

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=51B8FE29D129872685256D1E00669DAB|View this thread on the  forum...]]