ODBC error with Crystal

Yahoo Archive
1
Bob,

Where is that file obtained?

Todd Gilbert
Altair Technologies, Inc.
Vantage 5.10.132

-----Original Message-----
From: BWalton [mailto:rwalton@...]
Sent: Thursday, May 08, 2003 1:26 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC error with Crystal


Dave,
If Epicor Tech Support can't help, I've got this documented from my
early days on 5.1. There is a file named OUTJOINFILE.REG that we needed.
Let me know if you need
more info.
Bob Walton

David Schnorr wrote:

> I recently tried using ODBC with Crystal Reports to connect to our
> Vantage database. We are on Vantage 5.1. If I select data from one table
> it works great, but when I join another table, I get an error. It says
> OBDC Error The Keywords LEFT OUTER JOIN were not found in an outer join
> escape sequence. Does anyone have any ideas why I am getting this
> message? I am trying to simply join the orderhed to the orderdtl table.
> Thanks
>
> -Dave Schnorr
> Minnesota Electric Technology
>
> [Non-text portions of this message have been removed]
>
>
> 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/.
<http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>


[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=251812.3170658.4537139.1261774/D=egroupweb/S=17050071
83:HM/A=1564416/R=0/*http://www.netflix.com/Default?mqso=60164797&partid=317
0658>

<http://us.adserver.yahoo.com/l?M=251812.3170658.4537139.1261774/D=egroupmai
l/S=:HM/A=1564416/rand=127686100>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
2
Dave,
you need to contact Epicor tech support for a procedureal document
and applet to fix this.

-----Original Message-----
From: David Schnorr [mailto:daves@...]
Sent: Thursday, May 08, 2003 3:50 PM
To: Vantage@yahoogroups.com
Subject: [Vantage] ODBC error with Crystal


I recently tried using ODBC with Crystal Reports to connect to our Vantage
database. We are on Vantage 5.1. If I select data from one table it works
great, but when I join another table, I get an error. It says OBDC Error The
Keywords LEFT OUTER JOIN were not found in an outer join escape sequence.
Does anyone have any ideas why I am getting this message? I am trying to
simply join the orderhed to the orderdtl table. Thanks
3
Dave,
If Epicor Tech Support can't help, I've got this documented from my early days on 5.1. There is a file named OUTJOINFILE.REG that we needed. Let me know if you need
more info.
Bob Walton

David Schnorr wrote:

> I recently tried using ODBC with Crystal Reports to connect to our
> Vantage database. We are on Vantage 5.1. If I select data from one table
> it works great, but when I join another table, I get an error. It says
> OBDC Error The Keywords LEFT OUTER JOIN were not found in an outer join
> escape sequence. Does anyone have any ideas why I am getting this
> message? I am trying to simply join the orderhed to the orderdtl table.
> Thanks
>
> -Dave Schnorr
> Minnesota Electric Technology
>
> [Non-text portions of this message have been removed]
>
>
> 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
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


[Non-text portions of this message have been removed]