SQuirreL and ODBC

Thanks so much for the replies from you, Vic and Ephraim! I now have ODBC, SQuirreL AND DBVisualizer set up and connecting. I need to finish up security and do some (very careful!) poking around. I will most likely still use BPMs to "fix up" tables rather than force things and I usually can figure out how to get what I need from BAQs or dashboards exported to Crystal exported to Excel. It's just nice to have a different way of looking at things and new options when I'm stuck. I'll feel much better going home this weekend having this done instead of having this little project floating around in my head all weekend! Thanks again for pointing me in the right direction.

Sue

--- In vantage@yahoogroups.com, "b_ordway" wrote:
>
> Also in the Files are setup notes for DBVisualizer, an alternative to SQuirrel.
>
> Files/ODBC/"DBVisualizer setup for Progress.doc".
>
>
> I found it mentioned in EpicWeb document before I had heard of SQuirrel. It does everything I needed I never bothered to compare the two in detail. But I always assumed they do all the same things.
>
> FYI, the most common thing I do is create ODBC views.
> I need them for MS Access and Excel ODBC users.
> They can't connect to some Progress tables directly.
> Building a view of the Customer has been my most common request.
>
>
>
>
> --- In vantage@yahoogroups.com, "snielsen28" wrote:
> >
> > I am testing Epicor 9.05.701 on Progress 32-bit. We are live on Vantage 8.03.409A, Progress. I don't have any particular situation that I need this for. I've used BPM's to "fix" some minor problems here and there (yes I test it first, am careful, and won't do it unless I'm sure it's safe). I have some UD fields here and there that are no longer being used and have some new ones I want to make use of. I already have working BPMs to clear/update these fields. Currently I run them weekends or evenings since they bog down the server when they run. I want to check into SQuirreL to both have another option if I need to find/fix something and to brush up on SQL query skills. Any word of advice will be appreciated! Thanks.
> >
> > Sue
> >
> > --- In vantage@yahoogroups.com, Ephraim Feldman wrote:
> > >
> > > A few questions in order to help.
> > > I went tru all this and have it working now.
> > > What db do you have progress or sql?
> > > From what version do you upgrade?
> > >
> > > Installing ODBC for progress was quite simple and you don't need any
> > > special kit for it it was in the OE folder
> > >
> > > Ephraim
> > > On 2013-01-23 4:09 PM, "snielsen28" wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Thanks to both you and Vic. I thought 9450 was the port I needed. I did
> > > > install squirrel on my desktop and wondered if I should have installed in
> > > > on the server. I just received my ODBC kit from Epicor. It's got all kinds
> > > > of docs, pdfs, etc. with it. Now I need to decide whether to keep it on my
> > > > client and install ODBC there or install squirrel on the server and give it
> > > > another whirl there. Maybe it would be better on the server and eliminate
> > > > the data going back and forth. There's a certain amount of admin I do on
> > > > the server when I'm connected via remote anyway, plus I can get to it no
> > > > matter where I am. Thanks for the info, it's reassuring to know I may be on
> > > > the right track!
> > > >
> > > > Sue
> > > >
> > > > --- In vantage@yahoogroups.com, "b_ordway" wrote:
> > > > >
> > > > > I believe the ODBC port number will be 9450 for 9.05.701.
> > > > >
> > > > > ODBC should have been set up on your server, so if you installed
> > > > Squirrel there, you should be OK.
> > > > > If you are on a client workstation you'll need to set up ODBC from
> > > > scratch - and it is kind of a pain. There is some setup documentation on
> > > > EpicWeb for this.
> > > > >
> > > > >
> > > > >
> > > > > --- In vantage@yahoogroups.com, "snielsen28" wrote:
> > > > > >
> > > > > > I've installed SQuirreL and am attempting to connect to the Epicor 9
> > > > database I'm testing (9.05.701, 32-bit progress). This is most likely a
> > > > very silly question, but do I need to setup ODBC with Epicor 9 first? I've
> > > > never needed or set up ODBC connections. I'm receiving a connection error
> > > > with the alias I've created (Unexpected Error occured attempting to open an
> > > > SQL connection. Access denied (Authorisation failed)). I've followed Vic's
> > > > instructions from a prior post. I used the Epicor 9 ODBC database port and
> > > > suspect my problem may be because I've never gone thru the ODBC database
> > > > connection process. Should I connect support for the kit before I spend
> > > > more time fiddling with it?
> > > > > >
> > > > > > Thanks!
> > > > > >
> > > > > > Sue
> > > > > >
> > > > >
> > > >
> > > >
> > > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
I've installed SQuirreL and am attempting to connect to the Epicor 9 database I'm testing (9.05.701, 32-bit progress). This is most likely a very silly question, but do I need to setup ODBC with Epicor 9 first? I've never needed or set up ODBC connections. I'm receiving a connection error with the alias I've created (Unexpected Error occured attempting to open an SQL connection. Access denied (Authorisation failed)). I've followed Vic's instructions from a prior post. I used the Epicor 9 ODBC database port and suspect my problem may be because I've never gone thru the ODBC database connection process. Should I connect support for the kit before I spend more time fiddling with it?

Thanks!

Sue
Yep, the ODBC port on E9 is different. I'm unsure what they are, but you
can figure it out within Progress Explorer Tool. But I'm sure someone else
here on E9 Progress knows off the top of their head.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
snielsen28
Sent: Tuesday, January 22, 2013 6:00 PM
To: vantage@yahoogroups.com
Subject: [Vantage] SQuirreL and ODBC





I've installed SQuirreL and am attempting to connect to the Epicor 9
database I'm testing (9.05.701, 32-bit progress). This is most likely a very
silly question, but do I need to setup ODBC with Epicor 9 first? I've never
needed or set up ODBC connections. I'm receiving a connection error with the
alias I've created (Unexpected Error occured attempting to open an SQL
connection. Access denied (Authorisation failed)). I've followed Vic's
instructions from a prior post. I used the Epicor 9 ODBC database port and
suspect my problem may be because I've never gone thru the ODBC database
connection process. Should I connect support for the kit before I spend more
time fiddling with it?

Thanks!

Sue



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2639/5549 - Release Date: 01/21/13




-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2221 / Virus Database: 2639/5550 - Release Date: 01/22/13

[Non-text portions of this message have been removed]
I believe the ODBC port number will be 9450 for 9.05.701.

ODBC should have been set up on your server, so if you installed Squirrel there, you should be OK.
If you are on a client workstation you'll need to set up ODBC from scratch - and it is kind of a pain. There is some setup documentation on EpicWeb for this.



--- In vantage@yahoogroups.com, "snielsen28" wrote:
>
> I've installed SQuirreL and am attempting to connect to the Epicor 9 database I'm testing (9.05.701, 32-bit progress). This is most likely a very silly question, but do I need to setup ODBC with Epicor 9 first? I've never needed or set up ODBC connections. I'm receiving a connection error with the alias I've created (Unexpected Error occured attempting to open an SQL connection. Access denied (Authorisation failed)). I've followed Vic's instructions from a prior post. I used the Epicor 9 ODBC database port and suspect my problem may be because I've never gone thru the ODBC database connection process. Should I connect support for the kit before I spend more time fiddling with it?
>
> Thanks!
>
> Sue
>
Thanks to both you and Vic. I thought 9450 was the port I needed. I did install squirrel on my desktop and wondered if I should have installed in on the server. I just received my ODBC kit from Epicor. It's got all kinds of docs, pdfs, etc. with it. Now I need to decide whether to keep it on my client and install ODBC there or install squirrel on the server and give it another whirl there. Maybe it would be better on the server and eliminate the data going back and forth. There's a certain amount of admin I do on the server when I'm connected via remote anyway, plus I can get to it no matter where I am. Thanks for the info, it's reassuring to know I may be on the right track!

Sue

--- In vantage@yahoogroups.com, "b_ordway" wrote:
>
> I believe the ODBC port number will be 9450 for 9.05.701.
>
> ODBC should have been set up on your server, so if you installed Squirrel there, you should be OK.
> If you are on a client workstation you'll need to set up ODBC from scratch - and it is kind of a pain. There is some setup documentation on EpicWeb for this.
>
>
>
> --- In vantage@yahoogroups.com, "snielsen28" wrote:
> >
> > I've installed SQuirreL and am attempting to connect to the Epicor 9 database I'm testing (9.05.701, 32-bit progress). This is most likely a very silly question, but do I need to setup ODBC with Epicor 9 first? I've never needed or set up ODBC connections. I'm receiving a connection error with the alias I've created (Unexpected Error occured attempting to open an SQL connection. Access denied (Authorisation failed)). I've followed Vic's instructions from a prior post. I used the Epicor 9 ODBC database port and suspect my problem may be because I've never gone thru the ODBC database connection process. Should I connect support for the kit before I spend more time fiddling with it?
> >
> > Thanks!
> >
> > Sue
> >
>
A few questions in order to help.
I went tru all this and have it working now.
What db do you have progress or sql?
From what version do you upgrade?

Installing ODBC for progress was quite simple and you don't need any
special kit for it it was in the OE folder

Ephraim
On 2013-01-23 4:09 PM, "snielsen28" <snielsen.hipco@...> wrote:

> **
>
>
> Thanks to both you and Vic. I thought 9450 was the port I needed. I did
> install squirrel on my desktop and wondered if I should have installed in
> on the server. I just received my ODBC kit from Epicor. It's got all kinds
> of docs, pdfs, etc. with it. Now I need to decide whether to keep it on my
> client and install ODBC there or install squirrel on the server and give it
> another whirl there. Maybe it would be better on the server and eliminate
> the data going back and forth. There's a certain amount of admin I do on
> the server when I'm connected via remote anyway, plus I can get to it no
> matter where I am. Thanks for the info, it's reassuring to know I may be on
> the right track!
>
> Sue
>
> --- In vantage@yahoogroups.com, "b_ordway" wrote:
> >
> > I believe the ODBC port number will be 9450 for 9.05.701.
> >
> > ODBC should have been set up on your server, so if you installed
> Squirrel there, you should be OK.
> > If you are on a client workstation you'll need to set up ODBC from
> scratch - and it is kind of a pain. There is some setup documentation on
> EpicWeb for this.
> >
> >
> >
> > --- In vantage@yahoogroups.com, "snielsen28" wrote:
> > >
> > > I've installed SQuirreL and am attempting to connect to the Epicor 9
> database I'm testing (9.05.701, 32-bit progress). This is most likely a
> very silly question, but do I need to setup ODBC with Epicor 9 first? I've
> never needed or set up ODBC connections. I'm receiving a connection error
> with the alias I've created (Unexpected Error occured attempting to open an
> SQL connection. Access denied (Authorisation failed)). I've followed Vic's
> instructions from a prior post. I used the Epicor 9 ODBC database port and
> suspect my problem may be because I've never gone thru the ODBC database
> connection process. Should I connect support for the kit before I spend
> more time fiddling with it?
> > >
> > > Thanks!
> > >
> > > Sue
> > >
> >
>
>
>


[Non-text portions of this message have been removed]
I am testing Epicor 9.05.701 on Progress 32-bit. We are live on Vantage 8.03.409A, Progress. I don't have any particular situation that I need this for. I've used BPM's to "fix" some minor problems here and there (yes I test it first, am careful, and won't do it unless I'm sure it's safe). I have some UD fields here and there that are no longer being used and have some new ones I want to make use of. I already have working BPMs to clear/update these fields. Currently I run them weekends or evenings since they bog down the server when they run. I want to check into SQuirreL to both have another option if I need to find/fix something and to brush up on SQL query skills. Any word of advice will be appreciated! Thanks.

Sue

--- In vantage@yahoogroups.com, Ephraim Feldman wrote:
>
> A few questions in order to help.
> I went tru all this and have it working now.
> What db do you have progress or sql?
> From what version do you upgrade?
>
> Installing ODBC for progress was quite simple and you don't need any
> special kit for it it was in the OE folder
>
> Ephraim
> On 2013-01-23 4:09 PM, "snielsen28" wrote:
>
> > **
> >
> >
> > Thanks to both you and Vic. I thought 9450 was the port I needed. I did
> > install squirrel on my desktop and wondered if I should have installed in
> > on the server. I just received my ODBC kit from Epicor. It's got all kinds
> > of docs, pdfs, etc. with it. Now I need to decide whether to keep it on my
> > client and install ODBC there or install squirrel on the server and give it
> > another whirl there. Maybe it would be better on the server and eliminate
> > the data going back and forth. There's a certain amount of admin I do on
> > the server when I'm connected via remote anyway, plus I can get to it no
> > matter where I am. Thanks for the info, it's reassuring to know I may be on
> > the right track!
> >
> > Sue
> >
> > --- In vantage@yahoogroups.com, "b_ordway" wrote:
> > >
> > > I believe the ODBC port number will be 9450 for 9.05.701.
> > >
> > > ODBC should have been set up on your server, so if you installed
> > Squirrel there, you should be OK.
> > > If you are on a client workstation you'll need to set up ODBC from
> > scratch - and it is kind of a pain. There is some setup documentation on
> > EpicWeb for this.
> > >
> > >
> > >
> > > --- In vantage@yahoogroups.com, "snielsen28" wrote:
> > > >
> > > > I've installed SQuirreL and am attempting to connect to the Epicor 9
> > database I'm testing (9.05.701, 32-bit progress). This is most likely a
> > very silly question, but do I need to setup ODBC with Epicor 9 first? I've
> > never needed or set up ODBC connections. I'm receiving a connection error
> > with the alias I've created (Unexpected Error occured attempting to open an
> > SQL connection. Access denied (Authorisation failed)). I've followed Vic's
> > instructions from a prior post. I used the Epicor 9 ODBC database port and
> > suspect my problem may be because I've never gone thru the ODBC database
> > connection process. Should I connect support for the kit before I spend
> > more time fiddling with it?
> > > >
> > > > Thanks!
> > > >
> > > > Sue
> > > >
> > >
> >
> >
> >
>
>
> [Non-text portions of this message have been removed]
>
I installed the ODBC from within the the OD102 folder then netsetup.

once i installed this the squirel worked with the right port


On Thu, Jan 24, 2013 at 9:17 AM, snielsen28 <snielsen.hipco@...>wrote:

> **
>
>
> I am testing Epicor 9.05.701 on Progress 32-bit. We are live on Vantage
> 8.03.409A, Progress. I don't have any particular situation that I need this
> for. I've used BPM's to "fix" some minor problems here and there (yes I
> test it first, am careful, and won't do it unless I'm sure it's safe). I
> have some UD fields here and there that are no longer being used and have
> some new ones I want to make use of. I already have working BPMs to
> clear/update these fields. Currently I run them weekends or evenings since
> they bog down the server when they run. I want to check into SQuirreL to
> both have another option if I need to find/fix something and to brush up on
> SQL query skills. Any word of advice will be appreciated! Thanks.
>
> Sue
>
>
> --- In vantage@yahoogroups.com, Ephraim Feldman wrote:
> >
> > A few questions in order to help.
> > I went tru all this and have it working now.
> > What db do you have progress or sql?
> > From what version do you upgrade?
> >
> > Installing ODBC for progress was quite simple and you don't need any
> > special kit for it it was in the OE folder
> >
> > Ephraim
> > On 2013-01-23 4:09 PM, "snielsen28" wrote:
> >
> > > **
>
> > >
> > >
> > > Thanks to both you and Vic. I thought 9450 was the port I needed. I did
> > > install squirrel on my desktop and wondered if I should have installed
> in
> > > on the server. I just received my ODBC kit from Epicor. It's got all
> kinds
> > > of docs, pdfs, etc. with it. Now I need to decide whether to keep it
> on my
> > > client and install ODBC there or install squirrel on the server and
> give it
> > > another whirl there. Maybe it would be better on the server and
> eliminate
> > > the data going back and forth. There's a certain amount of admin I do
> on
> > > the server when I'm connected via remote anyway, plus I can get to it
> no
> > > matter where I am. Thanks for the info, it's reassuring to know I may
> be on
> > > the right track!
> > >
> > > Sue
> > >
> > > --- In vantage@yahoogroups.com, "b_ordway" wrote:
> > > >
> > > > I believe the ODBC port number will be 9450 for 9.05.701.
> > > >
> > > > ODBC should have been set up on your server, so if you installed
> > > Squirrel there, you should be OK.
> > > > If you are on a client workstation you'll need to set up ODBC from
> > > scratch - and it is kind of a pain. There is some setup documentation
> on
> > > EpicWeb for this.
> > > >
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "snielsen28" wrote:
> > > > >
> > > > > I've installed SQuirreL and am attempting to connect to the Epicor
> 9
> > > database I'm testing (9.05.701, 32-bit progress). This is most likely a
> > > very silly question, but do I need to setup ODBC with Epicor 9 first?
> I've
> > > never needed or set up ODBC connections. I'm receiving a connection
> error
> > > with the alias I've created (Unexpected Error occured attempting to
> open an
> > > SQL connection. Access denied (Authorisation failed)). I've followed
> Vic's
> > > instructions from a prior post. I used the Epicor 9 ODBC database port
> and
> > > suspect my problem may be because I've never gone thru the ODBC
> database
> > > connection process. Should I connect support for the kit before I spend
> > > more time fiddling with it?
> > > > >
> > > > > Thanks!
> > > > >
> > > > > Sue
> > > > >
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>


[Non-text portions of this message have been removed]
Also in the Files are setup notes for DBVisualizer, an alternative to SQuirrel.

Files/ODBC/"DBVisualizer setup for Progress.doc".


I found it mentioned in EpicWeb document before I had heard of SQuirrel. It does everything I needed I never bothered to compare the two in detail. But I always assumed they do all the same things.

FYI, the most common thing I do is create ODBC views.
I need them for MS Access and Excel ODBC users.
They can't connect to some Progress tables directly.
Building a view of the Customer has been my most common request.




--- In vantage@yahoogroups.com, "snielsen28" wrote:
>
> I am testing Epicor 9.05.701 on Progress 32-bit. We are live on Vantage 8.03.409A, Progress. I don't have any particular situation that I need this for. I've used BPM's to "fix" some minor problems here and there (yes I test it first, am careful, and won't do it unless I'm sure it's safe). I have some UD fields here and there that are no longer being used and have some new ones I want to make use of. I already have working BPMs to clear/update these fields. Currently I run them weekends or evenings since they bog down the server when they run. I want to check into SQuirreL to both have another option if I need to find/fix something and to brush up on SQL query skills. Any word of advice will be appreciated! Thanks.
>
> Sue
>
> --- In vantage@yahoogroups.com, Ephraim Feldman wrote:
> >
> > A few questions in order to help.
> > I went tru all this and have it working now.
> > What db do you have progress or sql?
> > From what version do you upgrade?
> >
> > Installing ODBC for progress was quite simple and you don't need any
> > special kit for it it was in the OE folder
> >
> > Ephraim
> > On 2013-01-23 4:09 PM, "snielsen28" wrote:
> >
> > > **
> > >
> > >
> > > Thanks to both you and Vic. I thought 9450 was the port I needed. I did
> > > install squirrel on my desktop and wondered if I should have installed in
> > > on the server. I just received my ODBC kit from Epicor. It's got all kinds
> > > of docs, pdfs, etc. with it. Now I need to decide whether to keep it on my
> > > client and install ODBC there or install squirrel on the server and give it
> > > another whirl there. Maybe it would be better on the server and eliminate
> > > the data going back and forth. There's a certain amount of admin I do on
> > > the server when I'm connected via remote anyway, plus I can get to it no
> > > matter where I am. Thanks for the info, it's reassuring to know I may be on
> > > the right track!
> > >
> > > Sue
> > >
> > > --- In vantage@yahoogroups.com, "b_ordway" wrote:
> > > >
> > > > I believe the ODBC port number will be 9450 for 9.05.701.
> > > >
> > > > ODBC should have been set up on your server, so if you installed
> > > Squirrel there, you should be OK.
> > > > If you are on a client workstation you'll need to set up ODBC from
> > > scratch - and it is kind of a pain. There is some setup documentation on
> > > EpicWeb for this.
> > > >
> > > >
> > > >
> > > > --- In vantage@yahoogroups.com, "snielsen28" wrote:
> > > > >
> > > > > I've installed SQuirreL and am attempting to connect to the Epicor 9
> > > database I'm testing (9.05.701, 32-bit progress). This is most likely a
> > > very silly question, but do I need to setup ODBC with Epicor 9 first? I've
> > > never needed or set up ODBC connections. I'm receiving a connection error
> > > with the alias I've created (Unexpected Error occured attempting to open an
> > > SQL connection. Access denied (Authorisation failed)). I've followed Vic's
> > > instructions from a prior post. I used the Epicor 9 ODBC database port and
> > > suspect my problem may be because I've never gone thru the ODBC database
> > > connection process. Should I connect support for the kit before I spend
> > > more time fiddling with it?
> > > > >
> > > > > Thanks!
> > > > >
> > > > > Sue
> > > > >
> > > >
> > >
> > >
> > >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>