<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Oracle and ODBC</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=315470216-23072007><FONT face=Arial
color=#0000ff size=2>Just for reference, I got this working by using a different
ODBC driver - the Oracle Instant Client ODBC driver, version
10.2.0.3.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=315470216-23072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=315470216-23072007><FONT face=Arial
color=#0000ff size=2><A
href="http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html">http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=315470216-23072007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=315470216-23072007><FONT face=Arial
color=#0000ff size=2>Keith</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> mapguide-users-bounces@lists.osgeo.org
[mailto:mapguide-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Campbell,
Keith A<BR><B>Sent:</B> 17 July 2007 15:00<BR><B>To:</B> MapGuide Users Mail
List<BR><B>Subject:</B> [mapguide-users] Oracle and ODBC<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>I'm having problems setting up a data connection to
an Oracle database with the ODBC driver.</FONT> </P>
<P><FONT face=Arial size=2>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 face=Arial size=2>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 face=Arial size=2>The remote database is 10g.</FONT> </P>
<P><FONT face=Arial size=2>Any suggestions as to how to get this working
properly are greatly appreciated.</FONT> </P>
<P><FONT face=Arial size=2>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></DEFANGHTML_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><DEFANGHTML_NOBR>
<P class="MsoNormal" align="center" defanghtml_style="MARGIN: 0cm 0cm 0pt"><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><BR><BR><FONT
style="BACKGROUND-COLOR: #ffffff">
<P align=center><FONT style="BACKGROUND-COLOR: #ffffff">This message has been
scanned for viruses by </FONT><A
href="http://bluepages.wsatkins.co.uk/?6875772"><FONT
style="BACKGROUND-COLOR: #ffffff"
color=#000000>MailControl</FONT></A></P></FONT><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>