Re: ?Use of a "view" database
From: Anders Altberg (x_pragma_at_telia.com)
Date: 05/05/04
- Previous message: Cindy Winegarden: "Re: SQL to file"
- In reply to: Jeff Boyce: "Re: ?Use of a "view" database"
- Next in thread: Jeff Boyce: "Re: ?Use of a "view" database"
- Reply: Jeff Boyce: "Re: ?Use of a "view" database"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 6 May 2004 00:33:56 +0200
Hi Jeff
It sounds from your wording "stand-alone VFP table" vs "the VFP database" as
if you aren't creating the same kind of DSN in these cases. If there is a
DBC file to which the DBF file is linked then you check Database and select
the DBC file as source. The .DBC metadata file contains a list of the .DBF
tables that belong to the database. If there's no such .DBC file then you
select the folder where the DBF is stored as source. The folder is
considered to be the 'database'.
Is Exclusive unchecked? I just checked for 'Unsupported commands and
functions' in drvvfp.hlp (in WINNT\System32) and CREATE DATABASE is no
supported by VFPODBC.
By the way, VFPODBC has not been updated since VFP6. VFP has switched to
distributing a VFPOLEDB driver since VFP7.
What is the exact error message?
-Anders
"Jeff Boyce" <JeffBoyce_IF@msn.com-DISCARD_HYPHEN_TO_END> wrote in message
news:eMWqA3pMEHA.140@TK2MSFTNGP09.phx.gbl...
> Anders
>
> On one PC, no problem linking from Access to a stand-alone VFP table using
> VFPODBC. On a second PC, the process of building a DNS using VFPODBC
works
> for the stage of "pointing" at the VFP database, but fails to complete,
> mentioning the need for an index file. Thus, on the second PC, we can't
> even get the DNS fully built to link into the database.
>
> The ideal situation would be that we could link into a "live" VFP database
> and use (but not add/edit/delete) the values contained therein in a
"local"
> Access database, without any need to replicate data. It wouldn't matter
if
> that requires an intermediate, "helper" VFP db that held views.
>
> In SQL Server, I can create the views internally, then link to those,
rather
> than directly to the SQL Server tables.
>
> Thanks again for your ideas and patience...
>
> Jeff
>
> "Anders Altberg" <x_pragma@telia.com> wrote in message
> news:us7Z8hpMEHA.268@TK2MSFTNGP11.phx.gbl...
> > ReadIOnly views by themselves don't affect indexes in any way but they
do
> > open the referenced tables and their indexes. Views use the indexes to
> > optimized performance when the Where clause is ewxactly matched by an
> index
> > key, and for joins. Views also create temporary indexes to support
> > searches. This is where the temporary local database is used as a means
of
> > directing these indexes to a local Temp folder instead of a Temp folder
on
> > the server. Would that apply to you situation.
> > What problems do you encounter relating to indexes?
> > -Anders
> >
> >
> > "Jeff Boyce" <JeffBoyce_IF@msn.com-DISCARD_HYPHEN_TO_END> wrote in
message
> > news:eWVO3wgMEHA.2640@TK2MSFTNGP12.phx.gbl...
> > > Thanks, Anders
> > >
> > > I'm already able to link to stand-alone copy, using the VFPODBC
driver.
> > The
> > > problem seems to be happening on another PC, and perhaps only when the
> VFP
> > > db is running. Your comment about "multiuser issues" makes me wonder
if
> > > that may be why we're getting an error message about an index when we
> try
> > > linking into that database.
> > >
> > > Would setting up a separate VFP database solely for the purpose of
> > > establishing a read-only view get us around the multiuser issues?
> > >
> > > Thanks for your patience.
> > >
> > > Jeff
> > >
> > > "Anders Altberg" <x_pragma@telia.com> wrote in message
> > > news:uL3aSNeMEHA.1192@TK2MSFTNGP11.phx.gbl...
> > > > You'd still need VFPODBC or VFPOLEDB to connect to this database. If
> you
> > > can
> > > > connect to the current database or folder you can send the same
> queries
> > as
> > > > those that define the views. The use of temporary databases with
views
> > > > created on the fly is a way of getting around some multiuser issues
> with
> > > > views.
> > > > -Anders
> > > >
> > > >
> > > > "Jeff Boyce" <JeffBoyce_IF@msn.com-DISCARD_HYPHEN_TO_END> wrote in
> > message
> > > > news:e3EVY5dMEHA.620@TK2MSFTNGP10.phx.gbl...
> > > > > I work in MS Access, but have need to "see" data in a VFP table.
I
> > was
> > > > > pointed to a KB article that suggests that a new, empty VFP
database
> > can
> > > > be
> > > > > created, and "views" created inside that db, as a way of getting
> > around
> > > > > issues with indexes in the original VFP db. I don't need to
update
> > > > anything
> > > > > in the VFP db.
> > > > >
> > > > > Anyone have any experience/caveats about setting up a "view-only"
> VFP
> > > db?
> > > > > And/or using MS Access to link to those views?
> > > > >
> > > > > Thanks!
> > > > >
> > > > > Jeff
> > > > >
> > > >
> > >
> >
>
- Previous message: Cindy Winegarden: "Re: SQL to file"
- In reply to: Jeff Boyce: "Re: ?Use of a "view" database"
- Next in thread: Jeff Boyce: "Re: ?Use of a "view" database"
- Reply: Jeff Boyce: "Re: ?Use of a "view" database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
