All this ODBC Stuff?

I am basically a lurker on this list - most seem to be so far ahead of me
that I'm still learning. Troy, your explanation of the ODBC history
explaining Merant and SQL-92 sure clarified a murky picture for me. All of
a sudden I understood. Thanks for taking the time to explain -
Everyone's thorough explanations of issues help more people than just those
that ask the questions. Thanks to all - I hope to become knowledgeable
enough to be more of a contributor one day.

Thanks all,
Marilyn Fairchild
Pickwick Manufacturing

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, October 10, 2002 3:19 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] All this ODBC Stuff???

Todd,
Vantage 3.0 and 4.0 did not come with any ODBC drivers. So if you wanted
to use ODBC, you had to buy them at $100 per seat. Back then it was
Datadirect/Intersolv. That company was bought out by Merant (version 3.5
was what we used in Vantage 3.0). Once Progress 9.x came out (aka Vantage
5.0), Progress developed their own ODBC drivers -- called SQL-92 by many
here. They had their limitations in 5.0, and became faster in 5.1. But
there were still problems in certain areas. We are on Vantage 5.1, but are
still using the Merant 3.5 drivers that we purchased way back for Vantage
3.0. They have worked perfectly thus far, and we have 11 licenses for that
driver. I would have migrated to the Progress SQL-92 drivers with Vantage
5.0, except that our customized POForm.rpt report (which adds some ODBC
tables/fields in it) would not work with the SQL-92 drivers. So we have
stuck with the older (and more expensive) Merant 3.5 drivers. I don't think
we ever paid any maintenance fee for the Merant drivers.

It seems that in Vantage 5.2 (Progress 9.1D) the SQL-92 drivers may be fixed
for our POForm.rpt. If so, I plan to use those drivers and finally ditch
the Merant drivers.

A little history.

Troy Funte
Liberty Electronics




[Non-text portions of this message have been removed]
We have not used ODBC very much but when we purchased Vantage we did buy 3
copies of "ODBC Driver 32-Bit" and maintenance for it. It says (in the fine
print) the ODBC maintenance is provided "Progress/Intersolv". When we
received Vantage 4.0 it came with three CDs for Merant DataDirect Connect
ODBC Progress Driver.

Now that we are on Progress 9.1D on Vantage 5.20 what the heck ODBC are we
supposed to have? Something from Progress? Another Merant version? Were
we paying for maintenance of the Merant product or something from Progress?
What ODBC works best? I've seen mention of Progress versions and new Merant
products so I assume they are different.

I have one Crystal savy user that has done her own data extracts to Excel
using the old ODBC and as of this week, now on Progress 9.1D, it does not
work. I'd like to dabble in using ODBC some more but am not sure where to
start.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


[Non-text portions of this message have been removed]
It is installed with Progress. You just need o set up a service in progress
explorer and specify it as an SQL connection. The client side ODBC is also
set-up during the client install. You just need to set-up the DB connection
in the ODBC connection manager under control panel.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com

"Helping Business Make Intelligent Use of Technology"


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, October 10, 2002 2:59 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] All this ODBC Stuff???


We have not used ODBC very much but when we purchased Vantage we did buy 3
copies of "ODBC Driver 32-Bit" and maintenance for it. It says (in the fine
print) the ODBC maintenance is provided "Progress/Intersolv". When we
received Vantage 4.0 it came with three CDs for Merant DataDirect Connect
ODBC Progress Driver.

Now that we are on Progress 9.1D on Vantage 5.20 what the heck ODBC are we
supposed to have? Something from Progress? Another Merant version? Were
we paying for maintenance of the Merant product or something from Progress?
What ODBC works best? I've seen mention of Progress versions and new Merant
products so I assume they are different.

I have one Crystal savy user that has done her own data extracts to Excel
using the old ODBC and as of this week, now on Progress 9.1D, it does not
work. I'd like to dabble in using ODBC some more but am not sure where to
start.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


[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/
Progress 9.1B,C, and D come with the Merant 3.6 ODBC Driver.
The support is via Epicor as with all Progress software.
Merant, AKA DataDirect Tech. wrote the 3.6 driver for Progress. Then Merant
and Progress had a falling out. The last time I heard, the Merant 3.6
driver will be the last from Merant supplied with Progress for free. I
think Merant 4.5 drivers are now available directly from Datadirect Tech. I
think it runs around 125.00 each. Epicor will only support ODBC with the
3.6 driver. By the way, the 3.6 driver is at no charge. You do not have to
pay for each user using the product. This has changed since Version 4.0.

Thanks
Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, October 10, 2002 1:59 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] All this ODBC Stuff???


We have not used ODBC very much but when we purchased Vantage we did buy 3
copies of "ODBC Driver 32-Bit" and maintenance for it. It says (in the fine
print) the ODBC maintenance is provided "Progress/Intersolv". When we
received Vantage 4.0 it came with three CDs for Merant DataDirect Connect
ODBC Progress Driver.

Now that we are on Progress 9.1D on Vantage 5.20 what the heck ODBC are we
supposed to have? Something from Progress? Another Merant version? Were
we paying for maintenance of the Merant product or something from Progress?
What ODBC works best? I've seen mention of Progress versions and new Merant
products so I assume they are different.

I have one Crystal savy user that has done her own data extracts to Excel
using the old ODBC and as of this week, now on Progress 9.1D, it does not
work. I'd like to dabble in using ODBC some more but am not sure where to
start.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


[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/
Has anyone had any problems setting up Progress Explorer with two
configurations? One for 4GL connections and one for ODBC connections.

The Performance tuning document from Epicor states to have two different
configurations/ports for each of these communication methods. The 4GL is 4
per Progress server and ODBC is 1 per Server. I have tried setting it up
this way a few times and we run into a problem that to many users are on the
system. The messages continues to read increase your -N value.

Our -N value is fine. Epicor feels that its because we have 50 users and
that's considered a large user group for Vantage. I was told that they
think that the Generic Progress Lic we get from Epicor doesn't allow more
then 50 users.

For now, we run everything on port 3500.

Anyone else had this problem?
Thanks
Jeremy Leonard
IT Manager
K-T Corporation


-----Original Message-----
From: Rick Lane [mailto:rickl@...]
Sent: Thursday, October 10, 2002 2:08 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] All this ODBC Stuff???


It is installed with Progress. You just need o set up a service in progress
explorer and specify it as an SQL connection. The client side ODBC is also
set-up during the client install. You just need to set-up the DB connection
in the ODBC connection manager under control panel.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com

"Helping Business Make Intelligent Use of Technology"


-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Thursday, October 10, 2002 2:59 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] All this ODBC Stuff???


We have not used ODBC very much but when we purchased Vantage we did buy 3
copies of "ODBC Driver 32-Bit" and maintenance for it. It says (in the fine
print) the ODBC maintenance is provided "Progress/Intersolv". When we
received Vantage 4.0 it came with three CDs for Merant DataDirect Connect
ODBC Progress Driver.

Now that we are on Progress 9.1D on Vantage 5.20 what the heck ODBC are we
supposed to have? Something from Progress? Another Merant version? Were
we paying for maintenance of the Merant product or something from Progress?
What ODBC works best? I've seen mention of Progress versions and new Merant
products so I assume they are different.

I have one Crystal savy user that has done her own data extracts to Excel
using the old ODBC and as of this week, now on Progress 9.1D, it does not
work. I'd like to dabble in using ODBC some more but am not sure where to
start.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


[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/



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/
Todd,
Vantage 3.0 and 4.0 did not come with any ODBC drivers. So if you wanted to use ODBC, you had to buy them at $100 per seat. Back then it was Datadirect/Intersolv. That company was bought out by Merant (version 3.5 was what we used in Vantage 3.0). Once Progress 9.x came out (aka Vantage 5.0), Progress developed their own ODBC drivers -- called SQL-92 by many here. They had their limitations in 5.0, and became faster in 5.1. But there were still problems in certain areas. We are on Vantage 5.1, but are still using the Merant 3.5 drivers that we purchased way back for Vantage 3.0. They have worked perfectly thus far, and we have 11 licenses for that driver. I would have migrated to the Progress SQL-92 drivers with Vantage 5.0, except that our customized POForm.rpt report (which adds some ODBC tables/fields in it) would not work with the SQL-92 drivers. So we have stuck with the older (and more expensive) Merant 3.5 drivers. I don't think we ever paid any maintenance fee for the Merant drivers.

It seems that in Vantage 5.2 (Progress 9.1D) the SQL-92 drivers may be fixed for our POForm.rpt. If so, I plan to use those drivers and finally ditch the Merant drivers.

A little history.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Todd Caughey
To: 'vantage@yahoogroups.com'
Sent: Thursday, October 10, 2002 2:58 PM
Subject: [Vantage] All this ODBC Stuff???


We have not used ODBC very much but when we purchased Vantage we did buy 3
copies of "ODBC Driver 32-Bit" and maintenance for it. It says (in the fine
print) the ODBC maintenance is provided "Progress/Intersolv". When we
received Vantage 4.0 it came with three CDs for Merant DataDirect Connect
ODBC Progress Driver.

Now that we are on Progress 9.1D on Vantage 5.20 what the heck ODBC are we
supposed to have? Something from Progress? Another Merant version? Were
we paying for maintenance of the Merant product or something from Progress?
What ODBC works best? I've seen mention of Progress versions and new Merant
products so I assume they are different.

I have one Crystal savy user that has done her own data extracts to Excel
using the old ODBC and as of this week, now on Progress 9.1D, it does not
work. I'd like to dabble in using ODBC some more but am not sure where to
start.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


[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]
Just a note to add here, with little real relevance. Progress did not
actually develop their own ODBC drivers. They bought Merants 3.6 drivers
and began using/supporting as their own. And yes Troy, they have gotten
more stable now since the 3.5 drivers.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com

"Helping Business Make Intelligent Use of Technology"


-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, October 10, 2002 4:19 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] All this ODBC Stuff???


Todd,
Vantage 3.0 and 4.0 did not come with any ODBC drivers. So if you wanted
to use ODBC, you had to buy them at $100 per seat. Back then it was
Datadirect/Intersolv. That company was bought out by Merant (version 3.5
was what we used in Vantage 3.0). Once Progress 9.x came out (aka Vantage
5.0), Progress developed their own ODBC drivers -- called SQL-92 by many
here. They had their limitations in 5.0, and became faster in 5.1. But
there were still problems in certain areas. We are on Vantage 5.1, but are
still using the Merant 3.5 drivers that we purchased way back for Vantage
3.0. They have worked perfectly thus far, and we have 11 licenses for that
driver. I would have migrated to the Progress SQL-92 drivers with Vantage
5.0, except that our customized POForm.rpt report (which adds some ODBC
tables/fields in it) would not work with the SQL-92 drivers. So we have
stuck with the older (and more expensive) Merant 3.5 drivers. I don't think
we ever paid any maintenance fee for the Merant drivers.

It seems that in Vantage 5.2 (Progress 9.1D) the SQL-92 drivers may be fixed
for our POForm.rpt. If so, I plan to use those drivers and finally ditch
the Merant drivers.

A little history.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Todd Caughey
To: 'vantage@yahoogroups.com'
Sent: Thursday, October 10, 2002 2:58 PM
Subject: [Vantage] All this ODBC Stuff???


We have not used ODBC very much but when we purchased Vantage we did buy 3
copies of "ODBC Driver 32-Bit" and maintenance for it. It says (in the
fine
print) the ODBC maintenance is provided "Progress/Intersolv". When we
received Vantage 4.0 it came with three CDs for Merant DataDirect Connect
ODBC Progress Driver.

Now that we are on Progress 9.1D on Vantage 5.20 what the heck ODBC are we
supposed to have? Something from Progress? Another Merant version? Were
we paying for maintenance of the Merant product or something from
Progress?
What ODBC works best? I've seen mention of Progress versions and new
Merant
products so I assume they are different.

I have one Crystal savy user that has done her own data extracts to Excel
using the old ODBC and as of this week, now on Progress 9.1D, it does not
work. I'd like to dabble in using ODBC some more but am not sure where to
start.

Thanks,
-Todd Caughey
Harvey Vogel Mfg. Co.


[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/
At 04:34 PM 10/10/2002 -0400, you wrote:
>Progress did not actually develop their own ODBC drivers. They bought
>Merants 3.6 drivers and began using/supporting as their own. And yes
>Troy, they have gotten more stable now since the 3.5 drivers.

So are the Merant supplied 3.6 drivers *worse* than their 3.5 ones? We
bought 3.6 from Epicor back at Vantage 4.0. It sounds like the majority of
the folks here using Merant drivers have stayed with 3.5 rather than 3.6.
-Wayne


[Non-text portions of this message have been removed]
It really appears to be dependant on what exactly you are doing. I know
Troy and several others have noted that they had some troubles with he
drivers after 3.5, while we have come across some installations where there
were problems and others where there were not. But I will say that Progress
9.1C Vantage 5.1 ODBC has been the most solid we have seen.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com

"Helping Business Make Intelligent Use of Technology"


-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Thursday, October 10, 2002 4:58 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] All this ODBC Stuff???


At 04:34 PM 10/10/2002 -0400, you wrote:
>Progress did not actually develop their own ODBC drivers. They bought
>Merants 3.6 drivers and began using/supporting as their own. And yes
>Troy, they have gotten more stable now since the 3.5 drivers.

So are the Merant supplied 3.6 drivers *worse* than their 3.5 ones? We
bought 3.6 from Epicor back at Vantage 4.0. It sounds like the majority of
the folks here using Merant drivers have stayed with 3.5 rather than 3.6.
-Wayne


[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 believe the main trouble with the Progress-supplied drivers has been that the login process (Username: sysprogress, Password: sysprogress) causes Vantage to choke when adding Vantage tables to Vantage reports via ODBC. (Error 599). If only they didn't have to use the password, I think it would have been OK. Plus there were those Userfix and ODBCfix issues that had to be worked around. I don't know of any other bad issues with the SQL-92 drivers since 5.1.

Troy Funte
----- Original Message -----
From: Rick Lane
To: 'vantage@yahoogroups.com'
Sent: Thursday, October 10, 2002 5:04 PM
Subject: RE: [Vantage] All this ODBC Stuff???


It really appears to be dependant on what exactly you are doing. I know
Troy and several others have noted that they had some troubles with he
drivers after 3.5, while we have come across some installations where there
were problems and others where there were not. But I will say that Progress
9.1C Vantage 5.1 ODBC has been the most solid we have seen.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com

"Helping Business Make Intelligent Use of Technology"


-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Thursday, October 10, 2002 4:58 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] All this ODBC Stuff???


At 04:34 PM 10/10/2002 -0400, you wrote:
>Progress did not actually develop their own ODBC drivers. They bought
>Merants 3.6 drivers and began using/supporting as their own. And yes
>Troy, they have gotten more stable now since the 3.5 drivers.

So are the Merant supplied 3.6 drivers *worse* than their 3.5 ones? We
bought 3.6 from Epicor back at Vantage 4.0. It sounds like the majority of
the folks here using Merant drivers have stayed with 3.5 rather than 3.6.
-Wayne


[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/


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]
Here is something that you might want to try, Troy. Call Epicor support and
ask them to write you a utility that will remove the password from db user
sysprogress. We have plenty of installations that we didn't run the
odbcuser fix and they don't ask for a password. It should be something
really simple. There may even be away to remove the password through the
Progress db tools. I don't know of any.

Ted Kitch
ted@...

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, October 10, 2002 8:11 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] All this ODBC Stuff???

I believe the main trouble with the Progress-supplied drivers has been that
the login process (Username: sysprogress, Password: sysprogress) causes
Vantage to choke when adding Vantage tables to Vantage reports via ODBC.
(Error 599). If only they didn't have to use the password, I think it would
have been OK. Plus there were those Userfix and ODBCfix issues that had to
be worked around. I don't know of any other bad issues with the SQL-92
drivers since 5.1.

Troy Funte
----- Original Message -----
From: Rick Lane
To: 'vantage@yahoogroups.com'
Sent: Thursday, October 10, 2002 5:04 PM
Subject: RE: [Vantage] All this ODBC Stuff???


It really appears to be dependant on what exactly you are doing. I know
Troy and several others have noted that they had some troubles with he
drivers after 3.5, while we have come across some installations where
there
were problems and others where there were not. But I will say that
Progress
9.1C Vantage 5.1 ODBC has been the most solid we have seen.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com

"Helping Business Make Intelligent Use of Technology"


-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Thursday, October 10, 2002 4:58 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] All this ODBC Stuff???


At 04:34 PM 10/10/2002 -0400, you wrote:
>Progress did not actually develop their own ODBC drivers. They bought
>Merants 3.6 drivers and began using/supporting as their own. And yes
>Troy, they have gotten more stable now since the 3.5 drivers.

So are the Merant supplied 3.6 drivers *worse* than their 3.5 ones? We
bought 3.6 from Epicor back at Vantage 4.0. It sounds like the majority
of
the folks here using Merant drivers have stayed with 3.5 rather than 3.6.
-Wayne


[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/>


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/.
<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.


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





Yahoo! Groups Sponsor


ADVERTISEMENT


<http://rd.yahoo.com/M=212804.2460941.3878106.2225242/D=egroupweb/S=17050071
83:HM/A=810327/R=0/*http:/geocities.yahoo.com/ps/info?.refer=blrecs>


<http://rd.yahoo.com/M=212804.2460941.3878106.2225242/D=egroupweb/S=17050071
83:HM/A=810327/R=1/*http:/geocities.yahoo.com/ps/info?.refer=blrecs>


<http://us.adserver.yahoo.com/l?M=212804.2460941.3878106.2225242/D=egroupmai
l/S=:HM/A=810327/rand=367927441>

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]
Ted,
It's actually not a big deal for me now. Things are working totally fine with the Merant 3.5 drivers (I don't intend to change all of my 300 crystal reports to use the SQL-92 drivers just for the fun of it). Supposedly the issue is fixed in 5.2, so I may test it out and go with the new drivers if/when we upgrade to Vantage 5.2. Virginia at Epicor has been on this issue for months -- working between Progress and Seagate to find a solution. I wonder if they ever thought of your suggestion in the process.???

Troy Funte
Liberty Electronics

----- Original Message -----
From: Ted Kitch
To: 'vantage@yahoogroups.com'
Sent: Thursday, October 10, 2002 9:15 PM
Subject: RE: [Vantage] All this ODBC Stuff???


Here is something that you might want to try, Troy. Call Epicor support and
ask them to write you a utility that will remove the password from db user
sysprogress. We have plenty of installations that we didn't run the
odbcuser fix and they don't ask for a password. It should be something
really simple. There may even be away to remove the password through the
Progress db tools. I don't know of any.

Ted Kitch
ted@...

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Thursday, October 10, 2002 8:11 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] All this ODBC Stuff???

I believe the main trouble with the Progress-supplied drivers has been that
the login process (Username: sysprogress, Password: sysprogress) causes
Vantage to choke when adding Vantage tables to Vantage reports via ODBC.
(Error 599). If only they didn't have to use the password, I think it would
have been OK. Plus there were those Userfix and ODBCfix issues that had to
be worked around. I don't know of any other bad issues with the SQL-92
drivers since 5.1.

Troy Funte
----- Original Message -----
From: Rick Lane
To: 'vantage@yahoogroups.com'
Sent: Thursday, October 10, 2002 5:04 PM
Subject: RE: [Vantage] All this ODBC Stuff???


It really appears to be dependant on what exactly you are doing. I know
Troy and several others have noted that they had some troubles with he
drivers after 3.5, while we have come across some installations where
there
were problems and others where there were not. But I will say that
Progress
9.1C Vantage 5.1 ODBC has been the most solid we have seen.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275
www.intelligentsi.com

"Helping Business Make Intelligent Use of Technology"


-----Original Message-----
From: Wayne Cox [mailto:wmc20@...]
Sent: Thursday, October 10, 2002 4:58 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] All this ODBC Stuff???


At 04:34 PM 10/10/2002 -0400, you wrote:
>Progress did not actually develop their own ODBC drivers. They bought
>Merants 3.6 drivers and began using/supporting as their own. And yes
>Troy, they have gotten more stable now since the 3.5 drivers.

So are the Merant supplied 3.6 drivers *worse* than their 3.5 ones? We
bought 3.6 from Epicor back at Vantage 4.0. It sounds like the majority
of
the folks here using Merant drivers have stayed with 3.5 rather than 3.6.
-Wayne


[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/>


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/.
<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.


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





Yahoo! Groups Sponsor


ADVERTISEMENT


<http://rd.yahoo.com/M=212804.2460941.3878106.2225242/D=egroupweb/S=17050071
83:HM/A=810327/R=0/*http:/geocities.yahoo.com/ps/info?.refer=blrecs>


<http://rd.yahoo.com/M=212804.2460941.3878106.2225242/D=egroupweb/S=17050071
83:HM/A=810327/R=1/*http:/geocities.yahoo.com/ps/info?.refer=blrecs>


<http://us.adserver.yahoo.com/l?M=212804.2460941.3878106.2225242/D=egroupmai
l/S=:HM/A=810327/rand=367927441>

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]


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]