Learn how to a build a cloud-first strategyRegister Now

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

ASP.NET - Connection string for FoxPro

Hi,

I want to create a connection string for the FoxPro database,
can any one help me in this, how to do from asp.net.

Thanks
Venkat
0
tvenkat9
Asked:
tvenkat9
  • 2
1 Solution
 
TornadoVCommented:
Database container (.DBC):
"Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine"

Free table directory:
"Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Collating Sequence=general"

Force the provider to use an ODBC DSN:
""Provider=vfpoledb.1;DSN=MyDSN""

Here are a couple of good articles :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fox7help/html/dggrfOLEDBProviderforVisualFoxPro.asp

http://www.west-wind.com/presentations/VFPDOTNETiNTEROP/VFPDOTNETINTEROP.HTM#_COM_Interoperability

0
 
TornadoVCommented:
May I ask why did you give me 'B'?
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

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