[mapguide-users] Oracle and ODBC

[Campbell, Keith A]

Just for reference, I got this working by using a different ODBC driver
- the Oracle Instant Client ODBC driver, version 10.2.0.3.
 
http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/
winsoft.html
 
Keith

________________________________

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Campbell,
Keith A
Sent: 17 July 2007 15:00
To: MapGuide Users Mail List
Subject: [mapguide-users] Oracle and ODBC



I'm having problems setting up a data connection to an Oracle database
with the ODBC driver. 

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.

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.

The remote database is 10g. 

Any suggestions as to how to get this working properly are greatly
appreciated. 

Keith 



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.

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 Consider the environment. Please don't print this e-mail unless you
really need to.



This message has been scanned for viruses by MailControl
<http://bluepages.wsatkins.co.uk/?6875772> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070723/decf5605/attachment.html