Crystal ODBC Error

Troy,

Thank you very much. The reg fix worked like a charm.

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, February 20, 2003 7:31 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Crystal ODBC Error


Ed,
You need to download the registry fix from the Egroups website. It sets
a special registry setting for Crystal that fixes an 'outjoin' problem
related to the ODBC drivers.

http://groups.yahoo.com/group/vantage/files/Vantage%20Admin/Crystal.reg
Here is the website if you have the ODBC 3.6 drivers. I have the .reg file
for the older ODBC 3.5 drivers if you need that instead.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Edward F. Fox, Jr.
To: vantage@yahoogroups.com
Sent: Thursday, February 20, 2003 4:41 PM
Subject: [Vantage] Crystal ODBC Error


I just started to create a report in Crystal 8.5 and I am running Vantage
5.0. All works well until I join to another table. When I do I get the
following message:

"ODBC error: [MERANT][ODBC PROGRESS driver]The keywords LEFT OUTER JOIN
were
not found in an outer join escape sequence."

After selecting OK I get the following:

"Error detected by database DLL."

I have only one inner join in the report.

Does anyone have any ideas?

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


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


Yahoo! Groups Sponsor
ADVERTISEMENT




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 the Yahoo! Terms of Service.


[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/
I just started to create a report in Crystal 8.5 and I am running Vantage
5.0. All works well until I join to another table. When I do I get the
following message:

"ODBC error: [MERANT][ODBC PROGRESS driver]The keywords LEFT OUTER JOIN were
not found in an outer join escape sequence."

After selecting OK I get the following:

"Error detected by database DLL."

I have only one inner join in the report.

Does anyone have any ideas?

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


[Non-text portions of this message have been removed]
Ed,
You need to download the registry fix from the Egroups website. It sets a special registry setting for Crystal that fixes an 'outjoin' problem related to the ODBC drivers.

http://groups.yahoo.com/group/vantage/files/Vantage%20Admin/Crystal.reg Here is the website if you have the ODBC 3.6 drivers. I have the .reg file for the older ODBC 3.5 drivers if you need that instead.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Edward F. Fox, Jr.
To: vantage@yahoogroups.com
Sent: Thursday, February 20, 2003 4:41 PM
Subject: [Vantage] Crystal ODBC Error


I just started to create a report in Crystal 8.5 and I am running Vantage
5.0. All works well until I join to another table. When I do I get the
following message:

"ODBC error: [MERANT][ODBC PROGRESS driver]The keywords LEFT OUTER JOIN were
not found in an outer join escape sequence."

After selecting OK I get the following:

"Error detected by database DLL."

I have only one inner join in the report.

Does anyone have any ideas?

Edward F. Fox, Jr., CPA
Controller
Maxson Automatic Machinery Company
Phone: 401-596-0162 x110
Fax: 401-596-1050
www.maxsonautomatic.com


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


Yahoo! Groups Sponsor
ADVERTISEMENT




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 the Yahoo! Terms of Service.


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