ODBC... what else is out there?

Sorry to say I don't have the info anymore and I don't recall.



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)





[Non-text portions of this message have been removed]
What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132



[Non-text portions of this message have been removed]
SQL Or Progress?



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC... what else is out there?





What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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





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



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:24 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC... what else is out there?





SQL Or Progress?

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:18 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ODBC... what else is out there?

What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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





[Non-text portions of this message have been removed]
VB scripts running ODBC connections is about all I have done. I believe you
can use Access but at the end of the day it will use an ODBC as well.



I know you can write a BAQ that dumps xml/csv files and schedule them on
some regular basis never had a need for it though so I haven't written any.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC... what else is out there?





Progress

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] ODBC... what else is out there?

SQL Or Progress?

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:18 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ODBC... what else is out there?

What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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





[Non-text portions of this message have been removed]
So even if we would use Access we would still have to use an ODBC
connection?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:50 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC... what else is out there?





VB scripts running ODBC connections is about all I have done. I believe
you
can use Access but at the end of the day it will use an ODBC as well.

I know you can write a BAQ that dumps xml/csv files and schedule them on
some regular basis never had a need for it though so I haven't written
any.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:42 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC... what else is out there?

Progress

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] ODBC... what else is out there?

SQL Or Progress?

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:18 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ODBC... what else is out there?

What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

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





[Non-text portions of this message have been removed]
Lets assume for a moment, nobody from Epicor is reading this.... if that is the case, then you can use Access, .NET (this opens up a HUGE array of data reading and presentation possibilities), basic SQL commands and basically any app that will read from a SQL database (assuming that your database is SQL, I don't know too much about Progress). One thing I would very very strongly advise you not to do is write directly to the vantage SQL database, all of that should be done strictly from within Vantage.

Thanks,
Kunal




________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tue, November 10, 2009 9:17:31 AM
Subject: [Vantage] ODBC... what else is out there?


What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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







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



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Kunal Ganguly
Sent: Tuesday, November 10, 2009 10:54 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC... what else is out there?





Lets assume for a moment, nobody from Epicor is reading this.... if that is the case, then you can use Access, .NET (this opens up a HUGE array of data reading and presentation possibilities), basic SQL commands and basically any app that will read from a SQL database (assuming that your database is SQL, I don't know too much about Progress). One thing I would very very strongly advise you not to do is write directly to the vantage SQL database, all of that should be done strictly from within Vantage.

Thanks,
Kunal

________________________________
From: Blake Clemens <blake.clemens@... <mailto:blake.clemens%40d-m-c.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tue, November 10, 2009 9:17:31 AM
Subject: [Vantage] ODBC... what else is out there?

What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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





[Non-text portions of this message have been removed]
To my understanding yes.



~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC... what else is out there?





So even if we would use Access we would still have to use an ODBC
connection?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:50 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] ODBC... what else is out there?

VB scripts running ODBC connections is about all I have done. I believe
you
can use Access but at the end of the day it will use an ODBC as well.

I know you can write a BAQ that dumps xml/csv files and schedule them on
some regular basis never had a need for it though so I haven't written
any.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:42 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC... what else is out there?

Progress

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] ODBC... what else is out there?

SQL Or Progress?

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:18 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ODBC... what else is out there?

What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

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

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





[Non-text portions of this message have been removed]
Any application outside of Vantage or Progress will require ODBC to access the Progress database. I also use JDBC with a free application called Squirrel, but JDBC is really nothing more then ODBC for Java applications.

I find that BAQs, BAMs, BPMs and Crystal supplies almost everything I need to access the Progress data. I try to avoid ODBC whenever possible, but there are a few rare occasions that I need to use it to fix a problem in the database that requires me to bypass the Business Objects. I do all my reporting and data extracting from within the Vantage environment.

There is also Service Connect, but unless you are doing data dumps back and forth, the effort to set it up may not be worth it. Once you have it set up for a specific need, it works fairly well if not very fast.



________________________________
From: Blake Clemens <blake.clemens@...>
To: vantage@yahoogroups.com
Sent: Tue, November 10, 2009 10:17:31 AM
Subject: [Vantage] ODBC... what else is out there?

Â
What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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







[Non-text portions of this message have been removed]
I was always under the impression that if you used Access you didn't
have to use ODBC. That stinks. So it looks like my only option is to
run the report from a BAQ.



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 11:03 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC... what else is out there?





To my understanding yes.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:53 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC... what else is out there?

So even if we would use Access we would still have to use an ODBC
connection?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:50 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] ODBC... what else is out there?

VB scripts running ODBC connections is about all I have done. I believe
you
can use Access but at the end of the day it will use an ODBC as well.

I know you can write a BAQ that dumps xml/csv files and schedule them on
some regular basis never had a need for it though so I haven't written
any.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:42 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC... what else is out there?

Progress

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] ODBC... what else is out there?

SQL Or Progress?

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:18 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ODBC... what else is out there?

What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

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

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

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





[Non-text portions of this message have been removed]
Well, you don't HAVE to use ODBC if you are using Access. However, if you don't use ODBC, you will need some intermediate data, either csv or xml. I have a couple of reports I run overnight that rely on a csv data extract. The csv is generated automatically every morning at 4:00 AM from Vista. Then, at 5:00 AM, my Access database starts as a scheduled task, reads the csv data, and sends emails to various people with information about the previous day. There is no ODBC involved in that process, but it would not work as smoothly if I try to run things during the workday. Also, my experience, and I have not heard others with this problem, is that ODBC can cause big slowdowns for others using the system.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any attachments, is legally privileged and confidential. If you are not the intended recipient you are hereby notified that any reading, use or dissemination of this message is strictly prohibited. If you have received this message in error, please immediately notify us by telephone at 425-776-4946 and delete this message from your system. Even though this e-mail and any attachments are believed to be free of any virus or other defect that might affect any computer system into which it is received and opened, it is the responsibility of the recipient to ensure that it is virus free, and no responsibility is accepted by Electric Mirror LLC for any loss or damage arising in any way from its use


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Blake Clemens
Sent: Tuesday, November 10, 2009 8:05 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC... what else is out there?



I was always under the impression that if you used Access you didn't
have to use ODBC. That stinks. So it looks like my only option is to
run the report from a BAQ.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 11:03 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC... what else is out there?

To my understanding yes.

~Charlie

_____

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:53 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC... what else is out there?

So even if we would use Access we would still have to use an ODBC
connection?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:50 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] ODBC... what else is out there?

VB scripts running ODBC connections is about all I have done. I believe
you
can use Access but at the end of the day it will use an ODBC as well.

I know you can write a BAQ that dumps xml/csv files and schedule them on
some regular basis never had a need for it though so I haven't written
any.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:42 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC... what else is out there?

Progress

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] ODBC... what else is out there?

SQL Or Progress?

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:18 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ODBC... what else is out there?

What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

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

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

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

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



[Non-text portions of this message have been removed]
We experience HUGE slowdowns. That's why I'm asking these questions.
Thanks for the input!!



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Rose
Sent: Tuesday, November 10, 2009 11:34 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC... what else is out there?





Well, you don't HAVE to use ODBC if you are using Access. However, if
you don't use ODBC, you will need some intermediate data, either csv or
xml. I have a couple of reports I run overnight that rely on a csv data
extract. The csv is generated automatically every morning at 4:00 AM
from Vista. Then, at 5:00 AM, my Access database starts as a scheduled
task, reads the csv data, and sends emails to various people with
information about the previous day. There is no ODBC involved in that
process, but it would not work as smoothly if I try to run things during
the workday. Also, my experience, and I have not heard others with this
problem, is that ODBC can cause big slowdowns for others using the
system.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

Note: The information contained in the e-mail, including any
attachments, is legally privileged and confidential. If you are not the
intended recipient you are hereby notified that any reading, use or
dissemination of this message is strictly prohibited. If you have
received this message in error, please immediately notify us by
telephone at 425-776-4946 and delete this message from your system. Even
though this e-mail and any attachments are believed to be free of any
virus or other defect that might affect any computer system into which
it is received and opened, it is the responsibility of the recipient to
ensure that it is virus free, and no responsibility is accepted by
Electric Mirror LLC for any loss or damage arising in any way from its
use

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Blake Clemens
Sent: Tuesday, November 10, 2009 8:05 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC... what else is out there?

I was always under the impression that if you used Access you didn't
have to use ODBC. That stinks. So it looks like my only option is to
run the report from a BAQ.

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 11:03 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC... what else is out there?

To my understanding yes.

~Charlie

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:53 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC... what else is out there?

So even if we would use Access we would still have to use an ODBC
connection?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:50 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] ODBC... what else is out there?

VB scripts running ODBC connections is about all I have done. I believe
you
can use Access but at the end of the day it will use an ODBC as well.

I know you can write a BAQ that dumps xml/csv files and schedule them on
some regular basis never had a need for it though so I haven't written
any.

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:42 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ODBC... what else is out there?

Progress

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf
Of Charlie Wilson
Sent: Tuesday, November 10, 2009 10:24 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: RE: [Vantage] ODBC... what else is out there?

SQL Or Progress?

~Charlie

_____

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Blake Clemens
Sent: Tuesday, November 10, 2009 10:18 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ODBC... what else is out there?

What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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

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

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

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

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

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

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





[Non-text portions of this message have been removed]
I concur with Steve.


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Steven Gotschall
Sent: Tuesday, November 10, 2009 11:06 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] ODBC... what else is out there?




Any application outside of Vantage or Progress will require ODBC to access
the Progress database. I also use JDBC with a free application called
Squirrel, but JDBC is really nothing more then ODBC for Java applications.

I find that BAQs, BAMs, BPMs and Crystal supplies almost everything I need
to access the Progress data. I try to avoid ODBC whenever possible, but
there are a few rare occasions that I need to use it to fix a problem in the
database that requires me to bypass the Business Objects. I do all my
reporting and data extracting from within the Vantage environment.

There is also Service Connect, but unless you are doing data dumps back and
forth, the effort to set it up may not be worth it. Once you have it set up
for a specific need, it works fairly well if not very fast.

________________________________
From: Blake Clemens <blake.clemens@ <mailto:blake.clemens%40d-m-c.com>
d-m-c.com>
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Sent: Tue, November 10, 2009 10:17:31 AM
Subject: [Vantage] ODBC... what else is out there?


What other options do we have to pull data from the Vantage database
instead of ODBC? Is Access a good substitute?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

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

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







[Non-text portions of this message have been removed]
The first question that I would ask:



"Is this an on demand report or a batch report?"



Most folks trash ODBC like it is some kind of evil villain. It rarely
is the source of performance problems. If you write a poor query, it
will perform terribly.



I have also found that there is a huge difference in how tools behave
when accessing ODBC data sources.



It is true that ODBC is CPU intensive in the Progress environment. Each
ODBC thread will grab 25% of the CPU. Not a problem as long as the
durations are short.



We use a few strategies:



1. BAQ reports
2. BAQ's exporting CSV's overnight consumed by spreadsheets
3. SQL server DTS packages exporting data en masse over night for
use during the following day as an alternate location for static data.
We also use this technique to update our customer portal via
replication.
4. ColdFusion web pages accessing Vantage dynamically via ODBC. We
have dozens of users doing this simultaneously during the day without a
problem.



Note that item 3 and 4 which ODBC are only server technology. ODBC is
not used from client stations. We then keep ODBC within the IT
department and tune the heck out of it.



I would make sure to always use the select top option when developing
to avoid unintentional clobbering of the Vantage server.



Hope this helps.



John A. Hatcher

Manager of IS

Versa Products Co., Inc.

(201) 518-5948

(201) 843-2400 x4148

(201) 843-2931 (fax)





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

If you're having "huge" slowdowns when using ODBC to query the database
then you need two check two things:

1. The ODBC configuration using Progress Explorer on the server - make
sure you follow Epicor's ODBC configuration guidelines

2. The structure of your query. A poorly-written query will choke
server performance.

You can get the ODBC server config guidelines in Epicor's database
config documentation. As far as writing good queries goes, Epicor's
report-writing course was valuable in the past for imparting good query
rules. In a nutshell:

1. Start from the smallest table to the largest (Company-> OrderHed ->
OrderDtl -> OrderRel for example)

2. Company is always your first table, even if you only have one
company in your database

3. Always sort on Company first, even if you only have one company in
your database

4. Try to always join and sort on indexed fields (the Data Dictionary
viewer will help you)

5. When using Access, don't be afraid of doing nested queries. Access
is happy using an initial query as a source for a second query.

6. Be judicious with your use of outer joins. First understand what
they are, next understand how they affect your data result. Then
understand their impact on query performance.

FYI, we make heavy use of ODBC here and we do not suffer performance
issues. I control who can write and execute queries. I heavily
automate our reporting and I make extensive use of Excel as a front-end
for the MSQuery- or Access-generated reports that our users need.

If you have an example query that's running slow, post the SQL here and
I'm sure we can help you fine-tune it.


have fun,
john





----- Original message -----
From: "Blake Clemens" <blake.clemens@...>
To: vantage@yahoogroups.com
Date: Tue, 10 Nov 2009 11:40:15 -0500
Subject: RE: [Vantage] ODBC... what else is out there?

We experience HUGE slowdowns. That's why I'm asking these questions.
Thanks for the input!!











*
are you using pass-through queries?

--- In vantage@yahoogroups.com, "Blake Clemens" <blake.clemens@...> wrote:
>
> We experience HUGE slowdowns. That's why I'm asking these questions.
> Thanks for the input!!
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>

>
What are pass-through queries?



Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Rupert
Sent: Wednesday, November 11, 2009 3:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: ODBC... what else is out there?





are you using pass-through queries?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Blake Clemens" <blake.clemens@...> wrote:
>
> We experience HUGE slowdowns. That's why I'm asking these questions.
> Thanks for the input!!
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>

>





[Non-text portions of this message have been removed]
A query that you run on (or pass through) an external system without linking
or importing from the system. Here's an Access tutorial on it:



http://www.techonthenet.com/access/tutorials/passthrough/basics02.php



Gerry





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Blake Clemens
Sent: Wednesday, November 11, 2009 7:54 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: ODBC... what else is out there?





What are pass-through queries?

Thanks,

Blake Clemens

IT Systems Engineer

Delmarva Millwork Corporation

(800) 360-2364 x132

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Rupert
Sent: Wednesday, November 11, 2009 3:32 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: ODBC... what else is out there?

are you using pass-through queries?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Blake Clemens" <blake.clemens@...> wrote:
>
> We experience HUGE slowdowns. That's why I'm asking these questions.
> Thanks for the input!!
>
>
>
> Thanks,
>
> Blake Clemens
>
> IT Systems Engineer
>

>

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





[Non-text portions of this message have been removed]
Pass-thru queries are great, I use them to dump raw piles of data. If
you're not comfortable writing SQL queries directly you can still use
the QBE grid in table view to write the query, then switch to SQL view
and copy the SQL, then paste into a new blank pass-thru query. One
caution: Access' SQL output is not always what the Progress driver
expects, so you still may need to tweak by hand.

But pass-thrus are not necessarily the answer your poor query
performance. Gerry's post jogged my memory about one thing I forgot to
mention in my previous post: make sure you set "Read Uncommitted" in
your ODBC driver settings.

have fun,
john




----- Original message -----
From: "Blake Clemens" <blake.clemens@...>
To: vantage@yahoogroups.com
Date: Wed, 11 Nov 2009 07:54:10 -0500
Subject: RE: [Vantage] Re: ODBC... what else is out there?

What are pass-through queries?











*