And by the way, this is an old version and I've had issues with newer versions. So I advise to install this version and not apply/upgrade to any others. Some other folks that have used this told me once they upgraded, it wasn't compatible any longer. But this version works for sure.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 29, 2015 5:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Easiest way to get record count
Yeah, Joe, that's me. I'm the Squirrel guy. :-)
Here you go:
1. Download from here: http://sourceforge.net/projects/squirrel-sql/files/1-stable/3.2.1/squirrel-sql-3.2.1-install.jar/download
2. Execute installation with all default options is OK.
3. Locate Squirrel Installation folder (C:\Program Files) and open the subfolder “Libâ€
4. Open the \\<server>\epicor\oe101b\java folder and copy all “.jar†files into the “Lib†folder above. Do not overwrite any duplicate files.
- Replace <server> above with your Vantage server’s name.
5. Open Squirrel
6. Click on “Drivers†and then the “+†button to Add a new driver.
- Name = “OpenEdgeâ€
- Example URL = “jdbc:datadirect:openedge://<server>:10001;DatabaseName=mfgsys†(Replace <server> with your Vantage server; do NOT change the port here)
- Website URL = leave blank
- Class Name: “com.ddtek.jdbc.openedge.OpenEdgeDriverâ€
7. Click OK to Save the Driver info
8. Add an Alias: Click on the Alias tab in the left column and Click on the “+†button to Add a new Alias
- Name = give it a name... ie, “Vantage TEST†or “Vantage LIVEâ€
- Driver = Choose “OpenEdge†(should have a blue checkmark)
- URL = Should be a copy of the “Example URL†in Step 6; verify. Still leave the Port alone.
- User Name and Password should both equal “sysprogressâ€
- Click the “Auto Login†checkbox
- Click on “Properties†button
- On the Schemas tab, for best performance, select “Load all and cache all schemasâ€
- Click on Driver Properties tab and check the “Use Driver Properties†box
- Click the “Specify†checkbox for each of the following and fill in the appropriate value:
- ServerName = your Vantage Server
- User = sysprogress
- password = sysprogress
- PortNumber = your ODBC port (8350 for Live, 8370 for Test, 8380 for Pilot)
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 29, 2015 3:58 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Easiest way to get record count
Thanks All.
I’m going to give Squirrel a try.
Is getting connect to Progress pretty straight forward?
I vaguely remember someone posting setup instructions.
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@... | www.matsinc.com
Ask us about our clean, green and beautiful matting and flooring
[cid:3e3d28.png@0f5093d7.4db1e872]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 29, 2015 2:41 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] E9: Easiest way to get record count
Once again, this is so easily done in SQL. (quiet, Jose!) :-)
Actually, call Epicor….. they have a utility that they've given me in the past that counts all the records in all of your tables.
Or… downloand and install SQuirreL and you can do a SELECT COUNT(*) FROM PUB.ORDERHED very easily just like in SQL.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, January 29, 2015 2:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Easiest way to get record count
Hello,
We had an issue with our Progress database and with Epicor’s help we seem to have gotten past it.
I am trying to delay doing a full initialization of the replication server because it takes several hours but I want to check to see if there is any major discrepancy in row counts for a few tables between the Progress and the replication DB.
I tried creating a BAQ with just OrderHed (for example), flagged it as summary and added a calculated field of “COUNT(OrderHed.Company)†but this just returns a blank field where I would expect to see a row count.
Any ideas on how to do this with a BAQ or is there a better way to get a row count?
Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
addr: 179 Campanelli Pkwy | Stoughton | MA | 02072-3734
jrojas@...<mailto:jrojas@...> | www.matsinc.com<http://www.matsinc.com>
Ask us about our clean, green and beautiful matting and flooring
[cid:bef233.png@4cfc2944.43869058]
This message is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]