[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 896
  • Last Modified:

OLE DB Connection String for FoxPro

OLE DB Connection String for FoxPro
0
JPTenore
Asked:
JPTenore
1 Solution
 
petr_hlucinCommented:
0
 
rachitkohliCommented:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\FOLDERNAME;Extended Properties=dBASE IV;User ID=Admin;Password=;
0
 
DhaestCommented:
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
 
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

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now