>
>I got it working on a simple table.
>
>As for the driver, I got the Oracle ODBC but installing it required the presence of Installer which does not come with Oracle XE.
>
>For me, that was a proof of concept. I let you know if I need more help. Thanks again.

Yes, your ODBC driver name (alias) will be different than the example I gave. My driver alias "Oracle in XE" is assigned by the Oracle Installer based on the Oracle Home I installed the ODBC driver in. The Oracle Installer manages all Oracle products allowing different versions of products to live in harmony on one computer. So if you have three Oracle Homes (Home1, Home2 and Home3) on your computer you could have three different ODBC driver versions with names "Oracle in Home1", "Oracle in Home2" and "Oracle in Home3".

For a better understanding take a look at registry key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI. Under that key is "HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers" key which contains a string entry value for each ODBC driver reference listed in the ODBC Data Source Administrator. Each one of those string entries has a corresponding Key with the same name under the HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI key. So in my case I have a key HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle in XE that contains several string entries. The one entry called Driver points to the location of the sqora32.dll used.