OT - Which Linux

You can also down load Red Hat from www.redhat.com - no charge. I
suspect that the $159 is for installing and configuring, and perhaps
some hand holding afterwards. I use Red Hat because that happen to be
what my friendly local computer store had on the shelf when I was
getting into Linux a few years ago, and have stuck with it since (It is
also a Progress supported distribution). Stable, reliable, fairly simple
to configure and instal, good support for most devices. If you are not
conversant with Linux, join you local users group, see what most of them
are using, and go with that. Then when you need help, chances are one of
them will already have solved the problem, and will be able to walk you
through it.

HTH

Jim Carnes wrote:
>
> Don't mean to be beating a dead horse but.
>
> I'm going to attempt to build a web mail server with Linux. I can order a
> server from Dell with RedHat 7.2 ($159). I've also built a test system and
> downloaded all of Mandrake (free), which I am installing now. Any
> suggestions as to which route (Linux version) to go? Never been there
> before but the cost was too much not to try. Is Redhat a better option for
> support and a mail server option? Haven't even begun to look at what mail
> package to use.
>
> Any and all suggestions are welcome.
>
> Thanks again,
>
> Jim Carnes
> IS Administrator
> Kenlee Precision Corp
> jcarnes@...
> 1700 Morrell Park Ave
> Baltimore, MD 21230
>
> [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/

--
/* ================================================================*/

Specialists in Progress Databases and Software since 1986

William E. Colls william@...
PROComputer Systems Tel 613 591 0079
67 Willow Glen Dr. Fax 613 591 3924
Kanata Ontario Canada www.procomsys.com
K2M 1T1
I understand that, when accessing a Vantage 5.1 table, one is supposed to
use Crystal v8.0 (and, with some effort, v8.5). Can one access a Vantage 5.1
database using Crystal Reports Pro v7.0?

I have ODBC working, can test the connection, can open single tables using
MS Access and Crystal 7, but any attempt to join more than one table (in
Crystal 7.0) returns a:

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

Is this a ODBC/Merant problem, a Crystal problem, or a Vantage/Progress
problem?

Thanks in advance!

============================================
Malcolm Spann
MIS
Malmberg Engineering
(925) 606-6500 x19
Malcolm@...
============================================
Malcom.

You might want to look at Eranet article 734MPS. It pertains to Outer Join
issues.

H.T.H
Dan Shallbetter
States Electric Mfg.



-----Original Message-----
From: Malcolm Spann [mailto:Malcolm@...]
Sent: Thursday, June 27, 2002 2:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports 7 & Vantage 5.1 (using Merant 3.60 ODBC
driver)



I understand that, when accessing a Vantage 5.1 table, one is supposed to
use Crystal v8.0 (and, with some effort, v8.5). Can one access a Vantage 5.1
database using Crystal Reports Pro v7.0?

I have ODBC working, can test the connection, can open single tables using
MS Access and Crystal 7, but any attempt to join more than one table (in
Crystal 7.0) returns a:

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

Is this a ODBC/Merant problem, a Crystal problem, or a Vantage/Progress
problem?

Thanks in advance!

============================================
Malcolm Spann
MIS
Malmberg Engineering
(925) 606-6500 x19
Malcolm@...
============================================





[Non-text portions of this message have been removed]
Don't mean to be beating a dead horse but.

I'm going to attempt to build a web mail server with Linux. I can order a
server from Dell with RedHat 7.2 ($159). I've also built a test system and
downloaded all of Mandrake (free), which I am installing now. Any
suggestions as to which route (Linux version) to go? Never been there
before but the cost was too much not to try. Is Redhat a better option for
support and a mail server option? Haven't even begun to look at what mail
package to use.

Any and all suggestions are welcome.

Thanks again,

Jim Carnes
IS Administrator
Kenlee Precision Corp
jcarnes@...
1700 Morrell Park Ave
Baltimore, MD 21230



[Non-text portions of this message have been removed]
You can download a registry file that will fix this. What happens is that
Crystal Reports is using the wrong syntax. This will correct that for any
version of Crystal Reports. You can use Crystal Reports v7 to access a
Vantage 5.1 database.



http://groups.yahoo.com/group/vantage/files/Vantage%20Admin/
<http://groups.yahoo.com/group/vantage/files/Vantage%20Admin/> Then select
the Crystal.reg link.



Hope this helps,



Ted Kitch
ted@...



-----Original Message-----
From: Malcolm Spann [mailto:Malcolm@...]
Sent: Thursday, June 27, 2002 2:34 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Reports 7 & Vantage 5.1 (using Merant 3.60 ODBC
driver)




I understand that, when accessing a Vantage 5.1 table, one is supposed to
use Crystal v8.0 (and, with some effort, v8.5). Can one access a Vantage 5.1
database using Crystal Reports Pro v7.0?

I have ODBC working, can test the connection, can open single tables using
MS Access and Crystal 7, but any attempt to join more than one table (in
Crystal 7.0) returns a:

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

Is this a ODBC/Merant problem, a Crystal problem, or a Vantage/Progress
problem?

Thanks in advance!

============================================
Malcolm Spann
MIS
Malmberg Engineering
(925) 606-6500 x19
Malcolm@...
============================================






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=178320.2150041.3600347.1829184/D=egroupweb/S=17050071
83:HM/A=979988/R=0/*http:/www.fastweb.com/ib/yahoo-79f>


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!
<http://docs.yahoo.com/info/terms/> Terms of Service.



[Non-text portions of this message have been removed]
Thanks to all that answered. Epicor sent me a package called "Implementing
ODBC for Vantage 5.10" which had the registry patch. However, the doc file
failed to mention this (even though the table of contents in the doc file
listed it).

Running the registry patch fixed it.

Thanks again!

Malcolm Spann
MIS
Malmberg Engineering


> -----Original Message-----
> From: Ted Kitch [mailto:ted@...]
> Sent: Thursday, June 27, 2002 2:11 PM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Crystal Reports 7 & Vantage 5.1 (using Merant
> 3.60 ODBC driver)
>
>
> You can download a registry file that will fix this. What
> happens is that Crystal Reports is using the wrong syntax. This will
correct
> that for any version of Crystal Reports. You can use Crystal Reports v7
> to access a Vantage 5.1 database.
>
> http://groups.yahoo.com/group/vantage/files/Vantage%20Admin/
> <http://groups.yahoo.com/group/vantage/files/Vantage%20Admin/>
> Then select the Crystal.reg link.
>
> Hope this helps,
>
> Ted Kitch
> ted@...
>
> -----Original Message-----
> From: Malcolm Spann [mailto:Malcolm@...]
> Sent: Thursday, June 27, 2002 2:34 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal Reports 7 & Vantage 5.1 (using
> Merant 3.60 ODBC
> driver)
>
> I understand that, when accessing a Vantage 5.1 table, one is supposed to
> use Crystal v8.0 (and, with some effort, v8.5). Can one access a Vantage
5.1
> database using Crystal Reports Pro v7.0?
>
> I have ODBC working, can test the connection, can open single tables using
> MS Access and Crystal 7, but any attempt to join more than one table (in
> Crystal 7.0) returns a:
>
> ODBC Error: [MERANT][ODBC Progress driver]The keywords LEFT OUTER JOIN
were
> not found in an outer join escape sequence.
>
> Is this a ODBC/Merant problem, a Crystal problem, or a Vantage/Progress
> problem?
>
> Thanks in advance!
>
> ============================================
> Malcolm Spann
> MIS
> Malmberg Engineering
> (925) 606-6500 x19
> Malcolm@...
> ============================================
>