Also, because all progress files in epicor have compiled triggers, most
writes will fail anyway unless you can find a way to disable the
triggers.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Wednesday, June 01, 2011 5:53 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Create a read and write Progress ODBC
connection ?
Not to be a cocky a**hole. But I know my Epicor very very very well, and
also progress. Let me tell you how horrible of an idea writing directly
to it is.
Please DO NOT UNDER any circumstance write to the database SPECIALLY
through ODBC unless you hate your job and would like to destroy your DB.
If you tell us what you are trying to accomplish we may be able to help
you through other methods.
Progress is NOT SQL!
*Jose C Gomez*
*Software Engineer*
*
*
*
CHECK OUT MY NEW BLOG <http://www.usdoingstuff.com> OR CONTACT ME
DIRECTLY*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
writes will fail anyway unless you can find a way to disable the
triggers.
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jose Gomez
Sent: Wednesday, June 01, 2011 5:53 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Create a read and write Progress ODBC
connection ?
Not to be a cocky a**hole. But I know my Epicor very very very well, and
also progress. Let me tell you how horrible of an idea writing directly
to it is.
Please DO NOT UNDER any circumstance write to the database SPECIALLY
through ODBC unless you hate your job and would like to destroy your DB.
If you tell us what you are trying to accomplish we may be able to help
you through other methods.
Progress is NOT SQL!
*Jose C Gomez*
*Software Engineer*
*
*
*
CHECK OUT MY NEW BLOG <http://www.usdoingstuff.com> OR CONTACT ME
DIRECTLY*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez>
<http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez>
<http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>
*Quis custodiet ipsos custodes?*
On Wed, Jun 1, 2011 at 4:44 PM, Clive <clive.1972@...> wrote:
>
>
> Ouch, locked tables.
>
> Hmm, I best tread carefully...
>
>
> --- In vantage@yahoogroups.com, "cooner_55421" <cooner_55421@...>
wrote:
> >
> > >Access can't write to the tables
> > It usually can write if you change the isolation level to blank on
> > the
> ODBC connection.
> > I only do this after hours, it locks tables.
> >
> > --- In vantage@yahoogroups.com, "Clive" <clive.1972@> wrote:
> > >
> > > All computers already have a system DSN setup using just this
> users/pass, however it's read only (or at least Access can't write to
> the tables, I've been testing against an unused UD table)
> > >
> > > --- In vantage@yahoogroups.com, Waffqle <waffqle@> wrote:
> > > >
> > > > Requisite 'You should go through the BO instead of ODBC'
> > > > diatribe,
> aside...
> > > >
> > > > There is an account that comes preset with the DB.
> > > > un: sysprogress
> > > > pw: sysprogress
> > > >
> > > > On Wed, Jun 1, 2011 at 11:45 AM, Clive <clive.1972@> wrote:
> > > >
> > > > >
> > > > >
> > > > > I'm now in a Progress environment after having worked in an MS
> > > > > SQL environment for many years, and I'm stumped as to how to
> > > > > go about
> creating
> > > > > the required account in Progress so that I can create a read
> > > > > and
> write ODBC
> > > > > connection to our live DB.
> > > > >
> > > > > I'd like to update a large amount of data using MS Access but
> > > > > the
> ODBC
> > > > > connection I have is read only.
> > > > >
> > > > > Can anyone help ?.
> > > > >
> > > > > Thanks.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > *Waffqle Driggers*
> > > > *High End Dev, System Design, Profit Drinking
> > > > *
> > > > *:: 904.962.2887*
> > > > *:: waffqle@*
> > > > *:: NO FAXES*
> > > >
> > > > *
> > > >
> > > > *
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> >
>
>
>
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links