Crystal/ODBC 'Left Outer Join' Error [bayes]

Yahoo Archive
1
Actually there is a registry fix that you must run to fix this
problem. I think tech support will have the information on it for
you.

Brian Stenglein
Clow Stamping Co.


--- In vantage@yahoogroups.com, "Kathy Schmidt" <kathyschmidt@f...>
wrote:
> First delete all the ODBC links provided by Progress.
>
> Second, create new links on only those indexes that you know are
unique
> to each field. I don't use the "equal" join very often, but I do
use
> the "left outer join" all the time.
>
> Try this first.
>
> John
>
>
> I finally got our ODBC to connect.
>
> However, it will only let me create 'Left Outer Join' links in
> Crystal. If I try to create an 'Equal join', I get the following
> errors:
>
> "ODBC error: [DataDirect-Technologies][ODBC Progress Driver] The
> keywords LEFT OUTER JOIN were not found in an outer join escape
> sequence"
>
> "Error detected by database DLL"
>
> What am I missing?
>
>
> Scott Zwieg
>
> IS Manager
> IMS-Electrol
> (262) 966-3741 Ext. 230
> Fax: (262) 966-7021
> szwieg@i...
>
>
>
>
>
>
>
>
>
>
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> have already linked your email address to a yahoo id to enable
access. )
> (1) To access the Files Section of our Yahoo!Group for Report
Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
> Yahoo! Groups Links
2
First delete all the ODBC links provided by Progress.

Second, create new links on only those indexes that you know are unique
to each field. I don't use the "equal" join very often, but I do use
the "left outer join" all the time.

Try this first.

John


I finally got our ODBC to connect.

However, it will only let me create 'Left Outer Join' links in
Crystal. If I try to create an 'Equal join', I get the following
errors:

"ODBC error: [DataDirect-Technologies][ODBC Progress Driver] The
keywords LEFT OUTER JOIN were not found in an outer join escape
sequence"

"Error detected by database DLL"

What am I missing?


Scott Zwieg

IS Manager
IMS-Electrol
(262) 966-3741 Ext. 230
Fax: (262) 966-7021
szwieg@...













Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links