BaseNow - Database Front-End Software
*
Home Buy Download Details Support
BaseNow Forums 
Home
Login Register Member List
  » BaseNow Forums   » News   » Opening FoxPro and dBase datab...  

Welcome Guest ( Login or Register )


Opening FoxPro and dBase databases
Author
Message
Posted 6/29/2004 4:50 AM
Forum Administrator
Forum Administrator

Group: Advanced Members
Active: 3/7/2010
Posts: 64

To connect BaseNow to a FoxPro database:

1. Press the Open button on the toolbar.
2. Click the Connection tab in the "Data Link Properties" window.
3. Select "Use connection string" option.
4. Enter this value:
Provider=MSDASQL.1;Persist SecurityInfo=False;Driver={Microsoft Visual FoxPro Driver};UID=;SourceDB=[DATABASE];SourceType=DBF;Exclusive=No;BackgroundFetch=No;Collate=Machine;Null=Yes;Deleted=Yes;

Replace [DATABASE] with the location of the folder that has the .dbf files you are trying to open. You can now access and modify the data. The program cannot change the structure of dBase and FoxPro tables.

Please note that a computer running BaseNow must have a "Microsoft Visual FoxPro Driver" installed. This driver comes with Visual FoxPro and many other development tools. You can also download the driver from the Microsoft's Visual FoxPro web site:
http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx

IP Logged
This member is offline.
Showing page 1 of 1 - 1 message found
« Next Oldest :: Next Newest »

Powered by InstantForum.NET v3.4
Copyright © 2002, 2004, InstantASP Ltd. All rights reserved.