I occassionally get an error with ODBC as well when creating reports
from Vantage. I searched Epicor's website and found a procedure to
follow to resolve but I have found an easier solution that has worked so
far (although I have not gone back to see if it resolved my error with
the change log table). Go into your ODBC DSN for Vantage and select the
advanced tab. Change the isolation level to read uncommitted and the
fetch array size to a larger number (I'm current at 2000 and I think the
default was 50).
Butch
________________________________
From: Frank Zeigafuse [mailto:
fzeigafuse@...]
Sent: Tuesday, January 11, 2005 8:39 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Change Log
I am TRYING to do this right now, what a coincidence. I found the table
called ChgLog but I am getting an odbc error :)
I think I need to step away from the light for awhile and come back to
it.
Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email:
fzeigafuse@...
-----Original Message-----
From: Manasa Reddy [mailto:
mreddy@...]
Sent: Tuesday, January 11, 2005 11:27 AM
To:
vantage@yahoogroups.com
Subject: RE: [Vantage] Change Log
Forgot, we are on Vantage 6.1.
M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email:
mreddy@...
Phone: (850) 682-2746 x 272
-----Original Message-----
From: Manasa Reddy [mailto:
mreddy@...]
Sent: Tuesday, January 11, 2005 10:27 AM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Change Log
Hope someone has figured out how to do this.
Has anyone been able to extract the information Vantage creates in the
Change Logs? If so, we
are looking to extract when a part was changed from being Manufactured
to
being Purchased, or vice versa.
TIA,
M. Manasa Reddy
ERP Specialist
Crestview Aerospace Corporation
Email:
mreddy@...
Phone: (850) 682-2746 x 272
[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
------------------------------------------------------------------------
----
--
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
c.. 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
Yahoo! Groups Links
<www.LCDarms.com> -- Ergonomic mounting solutions for monitors and
keyboards
This e-mail is from Innovative Office Products, Inc. but expresses the
views of the sender and not necessarily the views of the company. The
email and any files transmitted with it are confidential to the intended
recipient at the e-mail address to which it has been addressed. It may
not be disclosed or used by any other than that addressee, nor may it be
copied in any way. If received in error, please delete and notify the
sender via e-mail or
sales@... quoting the name of the sender.
Messages sent via this medium may be subject to delays, non-delivery and
unauthorized alteration. This e-mail has been prepared using information
believed by the author to be reliable and accurate. Unless expressly
stated otherwise, this e-mail does not form part of a legally binding
contract or agreement between recipient and Innovative Office Products,
Inc.
Warning: Although Innovative Office Products, Inc. has taken reasonable
precautions to ensure no viruses are present in this email, we cannot
accept responsibility for any loss or damage arising from the use of
this email or attachments. It is, therefore, your responsibility to scan
attachments (if any).
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
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:
vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]