Re: anybody out there who uses Visual Foxpro on Progress (V9) data??

From: Anonymous (none_at_here.com)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 04:37:31 GMT

In article <1102441426.353677.133710@z14g2000cwz.googlegroups.com>,
 "Phil" <pgablem1@twcny.rr.com> wrote:

> ExtraT wrote:
> > Hi,
> > I hope there is someone that reads this and knows how to update data
> > interactively using Visual Foxpro on data in a Progress (V9)
> database.
> > I can read / report on the data, but updates fail.
> > How did you set up the connection properties and the properties of
> the
> > remote view?
> > In the view designer, update criteria tab, I selected the key field
> > and selected update all fields, selected "send SQL Updates" and
> > left other options at their default values.
> > It is a remote view on a single table.
> > The connection's user id has enough authority to read, write and
> > execute.
> > But if I try to update a field in a record it does not change the
> > record, any changes are lost and the original values remain.
> > I am using the Progress SQL92 driver (03.60.0006) (MERANT 3.60
> > 32-BIT).
> > Perhaps it has something to do with the setup of the driver on the
> > server, if so can anybody point me to documentation about how to set
> > it up so updates are allowed?.
>
>
> Please contact me on how to get Foxpro Remote view to work with
> Progress / Vista 6,(a proprietary ERP system authored by Epicor which
> uses Progress as the RDBMS). The connection / remote view is
> established and I can read system tables however I'm getting security
> errors on the Vista tables. Any ideas??

Gotta do the GRANT statements for that user you're connecting as.

Relevant Pages

  • Re: Connecting a remote workstation to a domain
    ... If you have more than a couple of remote workstations connecting to the SBS ... server via VPN, you really need to consider a Terminal Server in the main ... "Log in using a dial up connection" checkbox, ... roaming profile then synchronizes with the server over the VPN); ...
    (microsoft.public.windows.server.sbs)
  • Re: Connecting a remote workstation to a domain
    ... I can remotely join XP Pro computers at the remote ... connection" checkbox so that any user can logon remotely. ... "Log in using a dial up connection" checkbox, either way it loads her cached ... roaming profile then synchronizes with the server over the VPN); ...
    (microsoft.public.windows.server.sbs)
  • Re: autoRepeating Error log ID 20111 (Remote Access)
    ... PPPoE connection software on the server turns what could/should be a full ... >> A Demand Dial connection to the remote interface Small Business ... >> Event Type: Warning ... >> Event Source: MSSQL$SBSMONITORING ...
    (microsoft.public.windows.server.sbs)
  • RE: Remote Office Configuration Suggestions?
    ... Welcome to SBS newsgroup. ... I understand that you want to keep the remote office continue working even ... after the main internet connection on the main office is not available. ... If you want to join the remote server to a SBS domain and become a member ...
    (microsoft.public.windows.server.sbs)
  • Re: Problem with Web based client
    ... Seems like you are having problems accessing the web server on the PC you ... > My remote desktop connection works fine when I connect with a Remote ...
    (microsoft.public.windowsxp.work_remotely)