E9: Where is SQL Explorer

Yahoo Archive
1
Perfect!

Thanks Zac



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Zac Jason Woodward
Sent: Thursday, September 15, 2011 1:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Where is SQL Explorer





Ah yes, had to use it to get the ODBC up and running.

Below is the text from a .bat file I used to get it started.

set dlc="E:\Epicor\oe102a"
call "E:\Epicor\oe102a\bin\sqlexp" mfgsys -H servername -S 9450 -user
username -password userpassword

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and
experienced industry experts.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Joe Rojas
Sent: Thursday, September 15, 2011 11:14 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] RE: E9: Where is SQL Explorer

Thanks from the reply Zac.

Back in Vantage 8 there was also a tool called SQL Explorer that would
allow you to run SQL queries against the Progress database.

I think it was excluded from E9 but I thought there was a command line
version.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Zac Jason Woodward
Sent: Thursday, September 15, 2011 1:09 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] RE: E9: Where is SQL Explorer

Do you mean the PET? It has been replaced by the OpenEdge Explorer, if
that is what you mean its located on the epicweb under 9.0x -> Third
party Products -> OpenEdge -> Windows -> select 32 or 64, then its
listed as OpenEdge Management and Explorer. I found it gives errors if
you try to install it while any of the DB's or app servers are running.

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and
experienced industry experts.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Joe Rojas
Sent: Thursday, September 15, 2011 9:18 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] E9: Where is SQL Explorer

Hello,

I remember hearing a while back that SQL Explorer is no longer available
in E9 but I thought there was a command line version.

If this is correct, can someone point me to it?

Thank you.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean,
green and beautiful matting and flooring

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]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]
2
Hello,



I remember hearing a while back that SQL Explorer is no longer available
in E9 but I thought there was a command line version.

If this is correct, can someone point me to it?



Thank you.










Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring


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]
3
Do you mean the PET? It has been replaced by the OpenEdge Explorer, if that is what you mean its located on the epicweb under 9.0x -> Third party Products -> OpenEdge -> Windows -> select 32 or 64, then its listed as OpenEdge Management and Explorer. I found it gives errors if you try to install it while any of the DB's or app servers are running.

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and experienced industry experts.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Rojas
Sent: Thursday, September 15, 2011 9:18 AM
To: vantage@yahoogroups.com
Subject: [Vantage] E9: Where is SQL Explorer



Hello,

I remember hearing a while back that SQL Explorer is no longer available
in E9 but I thought there was a command line version.

If this is correct, can someone point me to it?

Thank you.







Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@...<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean, green and beautiful matting and flooring

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]
4
Thanks from the reply Zac.

Back in Vantage 8 there was also a tool called SQL Explorer that would
allow you to run SQL queries against the Progress database.

I think it was excluded from E9 but I thought there was a command line
version.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Zac Jason Woodward
Sent: Thursday, September 15, 2011 1:09 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Where is SQL Explorer





Do you mean the PET? It has been replaced by the OpenEdge Explorer, if
that is what you mean its located on the epicweb under 9.0x -> Third
party Products -> OpenEdge -> Windows -> select 32 or 64, then its
listed as OpenEdge Management and Explorer. I found it gives errors if
you try to install it while any of the DB's or app servers are running.

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and
experienced industry experts.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Joe Rojas
Sent: Thursday, September 15, 2011 9:18 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] E9: Where is SQL Explorer

Hello,

I remember hearing a while back that SQL Explorer is no longer available
in E9 but I thought there was a command line version.

If this is correct, can someone point me to it?

Thank you.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean,
green and beautiful matting and flooring

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]




[Non-text portions of this message have been removed]
5
Ah yes, had to use it to get the ODBC up and running.

Below is the text from a .bat file I used to get it started.

set dlc="E:\Epicor\oe102a"
call "E:\Epicor\oe102a\bin\sqlexp" mfgsys -H servername -S 9450 -user username -password userpassword

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and experienced industry experts.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Rojas
Sent: Thursday, September 15, 2011 11:14 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: E9: Where is SQL Explorer



Thanks from the reply Zac.

Back in Vantage 8 there was also a tool called SQL Explorer that would
allow you to run SQL queries against the Progress database.

I think it was excluded from E9 but I thought there was a command line
version.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Zac Jason Woodward
Sent: Thursday, September 15, 2011 1:09 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] RE: E9: Where is SQL Explorer

Do you mean the PET? It has been replaced by the OpenEdge Explorer, if
that is what you mean its located on the epicweb under 9.0x -> Third
party Products -> OpenEdge -> Windows -> select 32 or 64, then its
listed as OpenEdge Management and Explorer. I found it gives errors if
you try to install it while any of the DB's or app servers are running.

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and
experienced industry experts.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Joe Rojas
Sent: Thursday, September 15, 2011 9:18 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] E9: Where is SQL Explorer

Hello,

I remember hearing a while back that SQL Explorer is no longer available
in E9 but I thought there was a command line version.

If this is correct, can someone point me to it?

Thank you.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@...<mailto:jrojas%40matsinc.com> <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean,
green and beautiful matting and flooring

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]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
6
SQLEXP is a command line SQL tool for Progress databases. It's used to, at a minimum, grant permissions for ODBC connections using SQL commands. Haven't tried anything further.

Ken

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Joe Rojas
Sent: Thursday, September 15, 2011 11:14 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] RE: E9: Where is SQL Explorer



Thanks from the reply Zac.

Back in Vantage 8 there was also a tool called SQL Explorer that would
allow you to run SQL queries against the Progress database.

I think it was excluded from E9 but I thought there was a command line
version.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Zac Jason Woodward
Sent: Thursday, September 15, 2011 1:09 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] RE: E9: Where is SQL Explorer

Do you mean the PET? It has been replaced by the OpenEdge Explorer, if
that is what you mean its located on the epicweb under 9.0x -> Third
party Products -> OpenEdge -> Windows -> select 32 or 64, then its
listed as OpenEdge Management and Explorer. I found it gives errors if
you try to install it while any of the DB's or app servers are running.

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and
experienced industry experts.

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Joe Rojas
Sent: Thursday, September 15, 2011 9:18 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] E9: Where is SQL Explorer

Hello,

I remember hearing a while back that SQL Explorer is no longer available
in E9 but I thought there was a command line version.

If this is correct, can someone point me to it?

Thank you.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@...<mailto:jrojas%40matsinc.com> <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean,
green and beautiful matting and flooring

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]

[Non-text portions of this message have been removed]



[Non-text portions of this message have been removed]
7
Hi Ken,



I just needed a quick way to get a record count of orderhed. It worked
pretty good.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ken Williams
Sent: Thursday, September 15, 2011 1:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] RE: E9: Where is SQL Explorer





SQLEXP is a command line SQL tool for Progress databases. It's used to,
at a minimum, grant permissions for ODBC connections using SQL commands.
Haven't tried anything further.

Ken

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Joe Rojas
Sent: Thursday, September 15, 2011 11:14 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] RE: E9: Where is SQL Explorer

Thanks from the reply Zac.

Back in Vantage 8 there was also a tool called SQL Explorer that would
allow you to run SQL queries against the Progress database.

I think it was excluded from E9 but I thought there was a command line
version.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>]
On Behalf
Of Zac Jason Woodward
Sent: Thursday, September 15, 2011 1:09 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] RE: E9: Where is SQL Explorer

Do you mean the PET? It has been replaced by the OpenEdge Explorer, if
that is what you mean its located on the epicweb under 9.0x -> Third
party Products -> OpenEdge -> Windows -> select 32 or 64, then its
listed as OpenEdge Management and Explorer. I found it gives errors if
you try to install it while any of the DB's or app servers are running.

"Zac" Jason Woodward
Network Administrator
Intermountain Electronics, Inc.
O: 877-544-2291
M: 435-820-6515
F: 435-637-9601
www.ie-corp.com

Creating customer confidence through extraordinary service and
experienced industry experts.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com> ]
On
Behalf Of Joe Rojas
Sent: Thursday, September 15, 2011 9:18 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] E9: Where is SQL Explorer

Hello,

I remember hearing a while back that SQL Explorer is no longer available
in E9 but I thought there was a command line version.

If this is correct, can someone point me to it?

Thank you.

Joe Rojas | Director of Information Technology | Mats Inc
dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
jrojas@... <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> <mailto:jrojas%40matsinc.com>
<mailto:jrojas%40matsinc.com> | www.matsinc.com Ask us about our clean,
green and beautiful matting and flooring

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]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]




[Non-text portions of this message have been removed]