Version 803 403D ODBC and Access

Yahoo Archive
1
This error can be fixed with a registry change, I actually added
workaround2 and workaround3 for each of the new values.

Add a New String Value to the following Registry Keys

\\HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\(YOUR_DSN_NAME)

\\HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\(YOUR_DSN_NAME)



New String Name = WorkArounds2

Value = 40960

OR

Value = 8192




> From: Joanne Yargeau <jyargeau@...>
> Subject: [Vantage] Version 803 403D ODBC and Access
> To: vantage@yahoogroups.com
> Date: Monday, June 9, 2008, 2:50 PM
>
>
>
>
>
>
> We are on a test server using 803 403D. I have previously used ODBC
> and Access for all of our reporting and reports. In testing the
ODBC
> drivers in Access on 803, the tables are visible but when I try to
> click on a table I get the following error: 'Reserved error (-
7748).
> There is no message for this error.' Can anyone help with what this
> error might be? Epicor says they don't support Access because they
> want you to use Crystal Reports. Our Access reports are very
complex
> and have many table joins so it would not be possible to use BAQ's
and
> I don't know Cyrstal other than moving a field here or there and I
> think they would be too complex for even Crystal. Is anyone using
> Access and ODBC in 803? I would appreciate any help that someone
may
> be willing to offer. TIA.
>
2
We are on a test server using 803 403D. I have previously used ODBC
and Access for all of our reporting and reports. In testing the ODBC
drivers in Access on 803, the tables are visible but when I try to
click on a table I get the following error: 'Reserved error (-7748).
There is no message for this error.' Can anyone help with what this
error might be? Epicor says they don't support Access because they
want you to use Crystal Reports. Our Access reports are very complex
and have many table joins so it would not be possible to use BAQ's and
I don't know Cyrstal other than moving a field here or there and I
think they would be too complex for even Crystal. Is anyone using
Access and ODBC in 803? I would appreciate any help that someone may
be willing to offer. TIA.
3
Did you download the 8.03 ODBC Kit from Epicor?

It can be found on their FTP site at:
ftp://ftpmpls.epicor.com/vantage/ODBC/ODBC_Kit_403.zip.

The 7748 error rings a bell, as I too had problems when I first
tried setting up ODBC. One quick thing to check, make sure the ODBC
driver is setup for READ_UNCOMMITED.

Calvin

--- In vantage@yahoogroups.com, "Joanne Yargeau" <jyargeau@...>
wrote:
>
> We are on a test server using 803 403D. I have previously used
ODBC
> and Access for all of our reporting and reports. In testing the
ODBC
> drivers in Access on 803, the tables are visible but when I try to
> click on a table I get the following error: 'Reserved error (-
7748).
> There is no message for this error.' Can anyone help with what
this
> error might be? Epicor says they don't support Access because
they
> want you to use Crystal Reports. Our Access reports are very
complex
> and have many table joins so it would not be possible to use BAQ's
and
> I don't know Cyrstal other than moving a field here or there and I
> think they would be too complex for even Crystal. Is anyone using
> Access and ODBC in 803? I would appreciate any help that someone
may
> be willing to offer. TIA.
>
4
You get that error alot if you try to open a table with too many fields
for Access. You may have to create a view and run the report from the
view


Kersten MacLennan
IT/ERP Analyst
Semrock, Inc.
3625 Buffalo Rd.,
Suite 6
Rochester, NY 14624
585-594-7009
585-594-7095 fax

kmaclennan@...

The Standard in Optical Filters for Biotech & Analytical Instrumentation


Hundreds of Thousands of Ion Beam Sputtered filters delivered -
extensive inventory now!

The information contained in this message and any attachments may be
privileged, confidential, and protected from disclosure. If the reader
of this message is not the intended recipient, or any agent responsible
for delivering this message to the intended recipient, you are hereby
notified that any dissemination, distribution, or copying of this
communication may be unlawful and therefore strictly prohibited. If you
received this message in error, please reply to the message and delete
it. Thank you




________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Calvin Krusen
Sent: Monday, June 09, 2008 3:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Version 803 403D ODBC and Access



Did you download the 8.03 ODBC Kit from Epicor?

It can be found on their FTP site at:
ftp://ftpmpls.epicor.com/vantage/ODBC/ODBC_Kit_403.zip.
<ftp://ftpmpls.epicor.com/vantage/ODBC/ODBC_Kit_403.zip.>

The 7748 error rings a bell, as I too had problems when I first
tried setting up ODBC. One quick thing to check, make sure the ODBC
driver is setup for READ_UNCOMMITED.

Calvin

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Joanne Yargeau" <jyargeau@...>
wrote:
>
> We are on a test server using 803 403D. I have previously used
ODBC
> and Access for all of our reporting and reports. In testing the
ODBC
> drivers in Access on 803, the tables are visible but when I try to
> click on a table I get the following error: 'Reserved error (-
7748).
> There is no message for this error.' Can anyone help with what
this
> error might be? Epicor says they don't support Access because
they
> want you to use Crystal Reports. Our Access reports are very
complex
> and have many table joins so it would not be possible to use BAQ's
and
> I don't know Cyrstal other than moving a field here or there and I
> think they would be too complex for even Crystal. Is anyone using
> Access and ODBC in 803? I would appreciate any help that someone
may
> be willing to offer. TIA.
>






[Non-text portions of this message have been removed]
5
Some of the dataviews must be joined to another (key related) table in order to query them.

--- On Mon, 6/9/08, Joanne Yargeau <jyargeau@...> wrote:

From: Joanne Yargeau <jyargeau@...>
Subject: [Vantage] Version 803 403D ODBC and Access
To: vantage@yahoogroups.com
Date: Monday, June 9, 2008, 2:50 PM






We are on a test server using 803 403D. I have previously used ODBC
and Access for all of our reporting and reports. In testing the ODBC
drivers in Access on 803, the tables are visible but when I try to
click on a table I get the following error: 'Reserved error (-7748).
There is no message for this error.' Can anyone help with what this
error might be? Epicor says they don't support Access because they
want you to use Crystal Reports. Our Access reports are very complex
and have many table joins so it would not be possible to use BAQ's and
I don't know Cyrstal other than moving a field here or there and I
think they would be too complex for even Crystal. Is anyone using
Access and ODBC in 803? I would appreciate any help that someone may
be willing to offer. TIA.