<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1">
<TITLE>Oracle and ODBC</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">I'm having problems setting up a data connection to an Oracle database with the ODBC driver.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">The connection tests successfully in Studio, but Show Tables returns only a fraction of the tables in the database. The ODBC connection itself seems to be OK, as I can list and link to the tables in Oracle with Microsoft Access. The user ID is in upper case.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">The ODBC driver I am using is 'Oracle in XE' which I assume was installed with a local version of Oracle XE. ODBC itself is at version 3.525.1117.0.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">The remote database is 10g.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Any suggestions as to how to get this working properly are greatly appreciated.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Keith</FONT>
</P>
<br><br>
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff" color=#ff0000><STRONG><FONT face="MS Sans Serif"><FONT size=2><FONT color=#000000>This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding</FONT>.</FONT></FONT></STRONG></FONT></P></NOBR>
<P align=center>The ultimate parent company of the Atkins Group is WS Atkins plc. Registered in England No. 1885586. Registered Office Woodcote Grove, Ashley Road, Epsom, Surrey KT18 5BW.</P><NOBR>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt" align=center><FONT face="MS Sans Serif"><FONT size=2><SPAN style="FONT-SIZE: 18pt; COLOR: green; FONT-FAMILY: Webdings">P</SPAN><SPAN style="COLOR: navy"> </SPAN><STRONG><SPAN style="COLOR: green; FONT-FAMILY: Arial">Consider the environment.</SPAN></STRONG><SPAN style="COLOR: blue"> </SPAN><STRONG><SPAN style="COLOR: green; FONT-FAMILY: Arial">Please don't print this e-mail unless you really need to.</SPAN></STRONG></FONT></FONT></P>
</body>
</HTML>