[mapguide-users] Oracle and ODBC

[Dirk Doerrenberg]

Joel,
I have seen the same issue. There are two things to consider:

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.
2. In the ODBC Setup dialog the values for TNS Name and User ID are case
sensitive. Oracle expects them to have all uppercase. 

regards,
Dirk

> _____________________________________________ 
> From: 	Joel Carranza [mailto:jec at gatekeeper.com] 
> Sent:	Thursday, July 20, 2006 1:00 AM
> To:	users at mapguide.osgeo.org
> Subject:	[mapguide-users] Oracle and ODBC
> 
> 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. 	
> 
> I tried using both the Connection String and Data Source Name methods.
> Absolutely nothing. 
> 
> Ideas anyone?
> 
> 
> --Joel
> Gatekeeper System
> 
>  << File: ATT403967.txt >> 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20060720/fa3b0717/attachment.html