Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple databases - local and remote
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00326924
Message ID:
00329159
Views:
39
Garry,

>Yes, the remote database does appear in the database combobox, but the expected remote views do not appear after it is selected and ADD is selected in the builder window. I am sure the connection is okay, because the remote views are easily opened in the Data Session window.>

If you've added the record correctly to metadbc.dbf your remote views should definitely appear in the list when you select the remote database in the combobox. Here's a few things to check:

1. When you added the new record to MetaDBC.dbf, in this context, you should specify the path/name of the remote .dbc in the cLocalDBC field rather than the cRemoteDBC field. I know this sounds confusing, but in this context you're simply setting up a new record for the data environment builder to access. I've actually changed this in later versions of the Framework!

2. Are you entering the path to the VFP .dbc that contains the remote views? You don't want to point to the actual remote database (i.e. SQL Server). You need the record in metadbc to point to the .dbc that contains that remote views.

3. Check to make sure the path to your VFP .dbc as specified in MetaDBC is correct.

4. Make sure you also specify the .dbc itself in MetaDBC.cLocalDBC. For example:

remotedata\projmgr.dbc

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform