Solved

OLE DB  Connection String for FoxPro

Posted on 2008-10-07
5
881 Views
Last Modified: 2012-08-14
OLE DB Connection String for FoxPro
0
Comment
Question by:JPTenore
5 Comments
 
LVL 4

Expert Comment

by:petr_hlucin
ID: 22657149
0
 
LVL 14

Expert Comment

by:rachitkohli
ID: 22657174
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\FOLDERNAME;Extended Properties=dBASE IV;User ID=Admin;Password=;
0
 
LVL 53

Accepted Solution

by:
Dhaest earned 500 total points
ID: 22657181
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
 

Author Comment

by:JPTenore
ID: 22657227
petr_hlucin:

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

0
 

Author Comment

by:JPTenore
ID: 22657269
ID:23792934

petr_hlucin:
Here is your Question
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question