<!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.0.6618.4">
<TITLE>RE: [mapguide-users] Oracle and ODBC</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><SPAN LANG="de"><FONT COLOR="#000000" SIZE=2 FACE="Verdana">Joel,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT COLOR="#000000" SIZE=2 FACE="Verdana">I have seen the same issue. There are two things to consider:</FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT COLOR="#000000" SIZE=2 FACE="Verdana">1. Don’t use the Microsoft ODBC for Oracle driver. This driver has an older version of ODBC specification that won’t work with the FDO ODBC Provider.</FONT></SPAN></P>
<P><SPAN LANG="de"><FONT COLOR="#000000" SIZE=2 FACE="Verdana">2. In the ODBC Setup dialog the values for TNS Name and User ID are case sensitive. Oracle expects them to have all uppercase.</FONT> </SPAN></P>
<P><SPAN LANG="de"><FONT COLOR="#000000" SIZE=2 FACE="Verdana">regards,</FONT></SPAN>
<BR><SPAN LANG="de"><FONT COLOR="#000000" SIZE=2 FACE="Verdana">Dirk</FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=1 FACE="Tahoma">_____________________________________________ </FONT></SPAN>
<BR><SPAN LANG="de"><B><FONT SIZE=1 FACE="Tahoma">From: </FONT></B> <FONT SIZE=1 FACE="Tahoma">Joel Carranza [</FONT></SPAN><A HREF="mailto:jec@gatekeeper.com"><SPAN LANG="de"><U><FONT COLOR="#0000FF" SIZE=1 FACE="Tahoma">mailto:jec@gatekeeper.com</FONT></U></SPAN></A><SPAN LANG="de"><FONT SIZE=1 FACE="Tahoma">] </FONT></SPAN>
<BR><SPAN LANG="de"><B><FONT SIZE=1 FACE="Tahoma">Sent: </FONT></B> <FONT SIZE=1 FACE="Tahoma">Thursday, July 20, 2006 1:00 AM</FONT></SPAN>
<BR><SPAN LANG="de"><B><FONT SIZE=1 FACE="Tahoma">To: </FONT></B> <FONT SIZE=1 FACE="Tahoma">users@mapguide.osgeo.org</FONT></SPAN>
<BR><SPAN LANG="de"><B><FONT SIZE=1 FACE="Tahoma">Subject: </FONT></B> <FONT SIZE=1 FACE="Tahoma">[mapguide-users] Oracle and ODBC</FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">Has anyone had any success connecting to Oracle through the ODBC driver? I get a "Successful connection" when I hit "Test Connection" but I never see any tables show up. </FONT></SPAN></P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">I tried using both the Connection String and Data Source Name methods. Absolutely nothing. </FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial">Ideas anyone?</FONT></SPAN>
</P>
<BR>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">--Joel</FONT></SPAN>
<BR><SPAN LANG="de"><FONT SIZE=2 FACE="Courier New">Gatekeeper System</FONT></SPAN>
</P>
<P><SPAN LANG="de"><FONT SIZE=2 FACE="Arial"> << File: ATT403967.txt >> </FONT></SPAN>
</P>
</BODY>
</HTML>