OLE DB Connection String for FoxPro

OLE DB Connection String for FoxPro
JPTenoreAsked:
Who is Participating?
 
DhaestConnect With a Mentor Commented:
FoxPro tables can come in either of two formats. They can be "free" tables, meaning that each table is independent of the others, or they can be part of a "database container" which holds metadata and allows additional features for the tables. If you see a file with a DBC extension then you've got a database.

Here are two connection strings:

*-- Free table directory
Provider=VFPOLEDB.1;Data Source=C:\My Documents\Visual FoxPro
Projects;Password="";Collating Sequence=MACHINE

*-- Database Container
Provider=VFPOLEDB.1;Data Source=C:\My Documents\Visual FoxPro
Projects\Test.DBC;Password="";Collating Sequence=MACHINE

(http://www.connectionstrings.com/)

 Using connection as new OleDbConnection("Provider=VFPOLEDB.1;Data Source=C:\My Documents\Visual FoxPro Projects;Password='';Collating Sequence=MACHINE")
     connection.Open()
     ' Use the connection
 End Using

Open in new window

0
 
petr_hlucinCommented:
0
 
rachitkohliCommented:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\FOLDERNAME;Extended Properties=dBASE IV;User ID=Admin;Password=;
0
 
JPTenoreAuthor Commented:
petr_hlucin:

I will ask Question:
List of Connections Strings  and give you Credit (Hold on I will ask it) 500pts A Grade

0
 
JPTenoreAuthor Commented:
ID:23792934

petr_hlucin:
Here is your Question
0
All Courses

From novice to tech pro — start learning today.