Keith, I just tried using my original (Progress 10.1B-32bit) driver that I’ve used all along with Crystal, just pointed it to my new Epicor Server and 9450 port and voila, it worked. Happy days!!!! Any issue with doing this since my Epicor9 DB is 10.2A? It seems to work fine but thought I’d ask….
Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.8408
Mobile: 615.418.3055
email: MAbell@...
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, February 20, 2015 2:17 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: Using ODBC Crystal reports with Epicor9 64bit progress
What driver (name) are you using, we use pgoe1023.dll. Version 3.50. I am not sure if it is 64 bit or not but it works and we use it with Crystal all day long.
From:
vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, February 20, 2015 2:49 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: Using ODBC Crystal reports with Epicor9 64bit progress
Keith, I’ve successfully created a 64 BIT ODBC connection using the manual 64 BIT ODBC setup. The problem I have is that Crystal Reports will ONLY use 32 BIT ODBC driver connections. When I try and install a 32BIT ODBC connection (using odbcad.exe in syswow directory), I get an error that states the “setup routines could not be loaded due to system error code 193”. I’m guessing this is because our Epicor9 server and db is 64BIT???. Another note, I had to “manually” create the registry entries in order to get the ODBC working, it did not install with any EPicor 9 client install (unless I’m doing something wrong).
Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.8408
Mobile: 615.418.3055
email: MAbell@...
From:
vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, February 20, 2015 1:35 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] RE: Using ODBC Crystal reports with Epicor9 64bit progress
When you installed the V9 client the ODBC drive for Progress should have been installed on your client. If you go to the Administrative Tools on your client and open the ODBC connections, then System DSN select Add and search for the Progress Open Edge 10.2A driver. Configure it to suit your install. The user ID is sysprogress as is the pwd.
In Crystal just use the ODBC connection.
If you need more info or trouble shooting info let me know what errors you are experiencing. You can test the connection in the ODBC configuration screen.
From:
vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, February 20, 2015 2:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Using ODBC Crystal reports with Epicor9 64bit progress
Can anyone send me a “how-to” in order to get Crystal Reports (which uses 32bit ODBC drivers) working with a 64bit Progress DB install of Epicor9? We are in conversion now from our Vantage8 system and I have hundreds of reports that I need to convert to Epicor9 but can’t get the ODBC connection working. Anyone else ran into this???
Mike Abell
Information Technology Manager
Flexial - BOA Group - Cookeville, Tennessee
Office: 931.432.8408
Mobile: 615.418.3055
email: MAbell@...
The information contained in this e-mail message is intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, or is not the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this message in error, please notify Ferguson Perforating immediately by telephone or reply by e-mail and then promptly delete the message. Thank-you.
The information contained in this e-mail message is intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, or is not the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this message in error, please notify Ferguson Perforating immediately by telephone or reply by e-mail and then promptly delete the message. Thank-you.