MS Access/DB2 ODBC

Thread View: alt.comp.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Bob Clore Tue, 12 May 1998 00:00

#81

Author: Bob Clore
Date: Tue, 12 May 1998 00:00

19 lines
1667 bytes

When Access 8 sends an Outer Join via ODBC it puts parentheses around the
clause after the "ON".  Our DB2 v4.1.0 on OS390 rejects this syntax.  The
parentheses don't show up in the Access SQL window, only in the ODBC trace.

Why does Access change things it doesn't need to?  Is there a way to get it
to stop doing that?
On the other side shouldn't parentheses be acceptable most anywhere as long
as they are matched?
Is there a  patch for DB2 v4.1.0 to handle this problem?
Any other ideas for a work around?

example:

select ........ from ..... left join .....  on (..... = ....)

Thanks,
Bob Clore
Seattle City Light (City of Seattle)

Re: MS Access/DB2 ODBC

#80

Author: David de Jong
Date: Wed, 13 May 1998 00:00

5 lines
1131 bytes

This isn't directly related but since you're using Access....
I'm having trouble opening more than 3 or 4 tables in Access 97.  Other than
that I have no problem accessing data.  Are there some parameters I need to
set?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads