Vantage 8.03 - ODBC to MS Excel 64 Bit

system · May 28, 2014, 1:04pm

system · April 3, 2014, 6:14pm

<!-- #ygrps-yiv-1549471271 _filtered #ygrps-yiv-1549471271 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1549471271 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-1549471271 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-1549471271 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} _filtered #ygrps-yiv-1549471271 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1549471271 #ygrps-yiv-1549471271 p.ygrps-yiv-1549471271MsoNormal, #ygrps-yiv-1549471271 li.ygrps-yiv-1549471271MsoNormal, #ygrps-yiv-1549471271 div.ygrps-yiv-1549471271MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-1549471271 a:link, #ygrps-yiv-1549471271 span.ygrps-yiv-1549471271MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-1549471271 a:visited, #ygrps-yiv-1549471271 span.ygrps-yiv-1549471271MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-1549471271 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1549471271 code
{
font-family:“Courier New”;}
#ygrps-yiv-1549471271 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-1549471271 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1549471271 span.ygrps-yiv-1549471271HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-1549471271 p.ygrps-yiv-1549471271attach, #ygrps-yiv-1549471271 li.ygrps-yiv-1549471271attach, #ygrps-yiv-1549471271 div.ygrps-yiv-1549471271attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1549471271 p.ygrps-yiv-1549471271bold, #ygrps-yiv-1549471271 li.ygrps-yiv-1549471271bold, #ygrps-yiv-1549471271 div.ygrps-yiv-1549471271bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1549471271 p.ygrps-yiv-1549471271green, #ygrps-yiv-1549471271 li.ygrps-yiv-1549471271green, #ygrps-yiv-1549471271 div.ygrps-yiv-1549471271green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-1549471271 p.ygrps-yiv-1549471271replbq, #ygrps-yiv-1549471271 li.ygrps-yiv-1549471271replbq, #ygrps-yiv-1549471271 div.ygrps-yiv-1549471271replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1549471271 p.ygrps-yiv-1549471271ad, #ygrps-yiv-1549471271 li.ygrps-yiv-1549471271ad, #ygrps-yiv-1549471271 div.ygrps-yiv-1549471271ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1549471271 p.ygrps-yiv-1549471271underline, #ygrps-yiv-1549471271 li.ygrps-yiv-1549471271underline, #ygrps-yiv-1549471271 div.ygrps-yiv-1549471271underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1549471271 span.ygrps-yiv-1549471271yshortcuts
{}
#ygrps-yiv-1549471271 p.ygrps-yiv-1549471271ad1, #ygrps-yiv-1549471271 li.ygrps-yiv-1549471271ad1, #ygrps-yiv-1549471271 div.ygrps-yiv-1549471271ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1549471271 p.ygrps-yiv-1549471271ad2, #ygrps-yiv-1549471271 li.ygrps-yiv-1549471271ad2, #ygrps-yiv-1549471271 div.ygrps-yiv-1549471271ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1549471271 p.ygrps-yiv-1549471271underline1, #ygrps-yiv-1549471271 li.ygrps-yiv-1549471271underline1, #ygrps-yiv-1549471271 div.ygrps-yiv-1549471271underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-1549471271 span.ygrps-yiv-1549471271yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-1549471271 span.ygrps-yiv-1549471271yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-1549471271 span.ygrps-yiv-1549471271EmailStyle34
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-1549471271 .ygrps-yiv-1549471271MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-1549471271 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1549471271 div.ygrps-yiv-1549471271WordSection1
{}
#ygrps-yiv-1549471271
_filtered #ygrps-yiv-1549471271 {
}
_filtered #ygrps-yiv-1549471271 {

font-family:Symbol;}
_filtered #ygrps-yiv-1549471271 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-1549471271 {

font-family:Wingdings;}
_filtered #ygrps-yiv-1549471271 {

font-family:Wingdings;}
#ygrps-yiv-1549471271 ol
{margin-bottom:0in;}
#ygrps-yiv-1549471271 ul
{margin-bottom:0in;}
–>

Hi,

Has anyone had any success with a database connection from Vantage 8.03Â 409 Â progress to Microsoft Excel 64 Bit

using an odbc connection.

Just wondering if it is possible

Thank You

Don

.

system · April 3, 2014, 6:42pm

Yep.Â Possible.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Don Kollmann
Sent: Thursday, April 03, 2014 6:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03 - ODBC to MS Excel 64 Bit

Hi,

Has anyone had any success with a database connection from Vantage 8.03 409 progress to Microsoft Excel 64 Bit

using an odbc connection.

Just wondering if it is possible

Thank You

Don

.

system · April 4, 2014, 9:40am

Hey Don,

Are you having trouble getting the ODBC drivers up in your 64-bit environment? Or you're wanting to know the entire process of setting up ODBC?

I've got a doc I wrote for doing this from Epicor 9.05.702a/Progress; I'll be glad to share it with you if you'd like.

-ben

benahlquist@...

system · April 4, 2014, 10:00am

Ben, as a polite suggestion, upload it to the Files section of this list so that others may access it, too.Â In fact, there's already an ODBC folder; so perhaps dump it in there.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of benahlquist@...
Sent: Friday, April 04, 2014 9:40 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage 8.03 - ODBC to MS Excel 64 Bit

Hey Don,

Are you having trouble getting the ODBC drivers up in your 64-bit environment? Or you're wanting to know the entire process of setting up ODBC?

I've got a doc I wrote for doing this from Epicor 9.05.702a/Progress; I'll be glad to share it with you if you'd like.

-ben

benahlquist@...

system · May 6, 2014, 12:24pm

system · May 28, 2014, 12:25pm

Yes it is possible.

I used Regedit to add the entries from my XP system to the 64 bit Windows 7 system.

Here is also a document on it.

PROBLEM DESCRIPTION:
The OE 10.1B ODBC driver does not have the proper

registry entry.

OR

The OE 10.1B ODBC driver is not available for
installation in the ODBC Control Panel.

OR

ODBC setup could not be loaded (126)

PROBLEM RESOLUTION:
The OE 10.1B Shared Network Client needs to be

installed for the ODBC driver to run properly.

Use one of the following registry entries below depending
if you are using a Mapped drive to your server or a UNC path to the server.

1) Simply copy and
paste one of the sections below to a new text doc.

(i.e. odbc.txt)
Copy and paste everything BETWEEN
the <>BEGIN<> and
<>END<> markings. Be cautious that the last line “OpenEdge
10.1B driver”=“Installed” IS the last line and not on same line
as previous string value.

2) Edit the paths
accordingly for your installation

3) Save the
changes

4) Rename the file
from “odbc.txt” to “odbc.reg”

5) Double click
and it will import automatically into the workstations registry.

NOTE: This needs
to be done on each workstation that will be using ODBC.

This is what the attached registry updated looks like for
the one with the UNC Path:

------------------------------------------------------------------------

---------------------------------------------------------

<><><>BEGIN<><><>

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\OpenEdge

10.1B driver]

“APILevel”=“1”

“ConnectFunctions”=“YYY”

“CPTimeout”=“60”

“Driver”="\\\\<server>\\epicor\\oe101b\\bin\\pgoe1022.dll"

“DriverODBCVer”=“5.1”

“FileUsage”=“0”

“Setup”="\\\\<server>\\epicor\\oe101b\\bin\\pgoe1022.dll"

“SQLLevel”=“1”

“UsageCount”=“1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC
Drivers] “OpenEdge 10.1B driver”=“Installed”

<><><>END<><><>

========================================================================

This is the registry entry for the Mapped Drive:

-----------------------------------------------------------------------

<><><>BEGIN<><><>

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\OpenEdge

10.1B Driver]

“APILevel”=“1”

“ConnectFunctions”=“YYY”

“CPTimeout”=“60”

“Driver”=“V:\\oe101b\\bin\\pgoe1022.dll”

“DriverODBCVer”=“5.1”

“FileUsage”=“0”

“Setup”=“V:\\oe101b\\bin\\pgoe1022.dll”

“SQLLevel”=“1”

“UsageCount”=“1”

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\ODBC
Drivers]

“OpenEdge 10.1B Driver”=“Installed”

<><><>END<><><>

NOTE: Once the
ODBC Driver is setup in the ODBC Control Panel, the Default Isolation Level
MUST be set to Read Uncommitted.

IMPORTANT NOTE: A 64-bit OS cannot use a 32-bit ODBC
driver. The ODBC driver will be listed
in the ODBC Control Panel, but no program will be able to use it. To test, open MS Excel on the 64-bit
client. Go to

Data->Import External Data->New Database
Query. If the ODBC driver does

not appear under the Databases tab, the operating system
does not recognize the driver.

A check of Microsoft forums shows the following topic,
with several links to workarounds for 32-bit ODBC driver on 64-bit OS:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1575276&SiteID=1

There are several possible workarounds from this
site.

Workaround/Solution:

One workaround that has been successfully used is the
Windows odbcad32.exe. Locate the
C:\Windows\sysWoW64\odbcad32.exe file.
Create a shortcut from C:Windows\sysWoW64\odbcad32.exe to the server
desktop.

Use this shortcut to setup 32 bit ODBC connections on the
server.

Consult your Microsoft documentation for further
information.

On Tuesday, May 6, 2014 11:24 AM, Don Kollmann <dkollmann@…> wrote:

Hi Vic,

I am finally getting back to this project of trying to connect Vantage OpenEdge 10.1B driver to Office / Excel 64 â€“bit and have not been successful.

I understand the SYSWOW odbc install and used that to install the odbcdriver in the 64-Bit ODBC Data Source Administrator.

I just cannot get Office 64-bit to see the 32-bit ODBC drivers.

Would you please share the technique to get this to work?

Thank You

Don Kollmann

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Thursday, April 03, 2014 5:43 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage 8.03 - ODBC to MS Excel 64 Bit

Yep. Possible.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Don Kollmann
Sent: Thursday, April 03, 2014 6:15 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage 8.03 - ODBC to MS Excel 64 Bit

Hi,

Has anyone had any success with a database connection from Vantage 8.03 409 progress to Microsoft Excel 64 Bit

using an odbc connection.

Just wondering if it is possible

Thank You

Don

.