Results 1 to 3 of 3

Thread: View this question ?

  1. Oct 26th, 2000, 06:33 PM #1
    bservello
    bservello is offline

    Thread Starter
    Junior Member
    Join Date
    Apr 2000
    Posts
    29
    How do you open a Foxpro *.dbf database file using ADO.

    Simple open please.
    Reply With Quote Reply With Quote
  2. Oct 27th, 2000, 04:47 AM #2
    VBKNIGHT
    VBKNIGHT is offline
    Fanatic Member VBKNIGHT's Avatar
    Join Date
    Oct 2000
    Location
    Port25
    Posts
    619

    Question uhmm..

    use ODBC?
    Reply With Quote Reply With Quote
  3. Oct 27th, 2000, 07:16 AM #3
    bar
    bar is offline
    Member
    Join Date
    Aug 2000
    Posts
    60
    Here's the connection string that you use.
    ADOConnectionObject.ConnectionString = "Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceDB=<path>;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Nu ll=Yes;Deleted=Yes;"

    The <path> tag refers to the folder where the .dbf file is and not the filename of the .dbf file. When opening the recordset object use the .dbf's name.
    Barend
    JHB-SA

    Nothing is impossible, except skiing through a revolving door.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width