Dbase asp

Results 1 to 3 of 3

Thread: Dbase asp

  1. #1
    Margaret Prinke Guest

    Default Dbase asp

    I would like to know how to make a dns-less connection to dbase III or IV tables. If anyone has a sure fire method I&#039d appreciate it. Access works great sql works fine, but I have no end of trouble with dbase tables.

  2. #2
    Join Date
    Dec 1969

    Default Here are two ways

    Here are a couple of connection strings that should get you started.<BR><BR>cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:msdbsmydbase.dbf;Extended Properties=dBASE III&#124dBASE IV;Persist Security Info=False"<BR><BR>cn.ConnectionString = "Provider=MSDASQL.1;Driver={Microsoft Access Driver (*.mdb)};Extended Properties=""DBQ=E:msdbsmydbase.dbf;dBASE III&#124dBASE IV"";Persist Security Info=False"<BR><BR>The first one will definitely work. The second one (or a close facsimile) should also work but I don&#039t have dbase so I can&#039t test it. Similar syntax to both of these works for Excel.

  3. #3
    Margaret Prinke Guest

    Default Thanks

    It helps a lot, thanks.

Posting Permissions

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