Microsoft Query and Oracle

[dalssoft]

Hi,

I'm trying to use Microsoft Query (Office 2003 SP2) and Oracle 9i but
it is not working for two reasons:

1. The table's and column's names on Oracle DB are case-sensitive.

Error: "Can't access table TABLE1"

2. It is not possible to use "auto-link". I tried to use with another
DB that is not case sensitive and when I add two related tables (FK)
it does not show me the link between them.

ODBC: Microsoft ODBC for Oracle

Any information to fix it? Hot fix? Service Pack? Setup?

It is very important that Excel works with Oracle.

Thank you,

David

 

[dalssoft]

More information:

About the FKs, it seems a problem with ODBC, because I tried to use
Visual Studio 2005 with its query designer and it worked when I was
using .NET Framework Data Provider for Oracle or .NET Framework Data
Provider for OLEDB, but it didn't work (wasn't able to auto-create the
contraints) when I tried ODBC.

Any ideia how to solve the problem?