Re: invalid path error while accessing FOXPRO table from c#
- From: "Cindy Winegarden" <CindyWinegarden@xxxxxxxxxxxxxxxx>
- Date: Fri, 2 Jun 2006 15:45:35 -0400
Hi Abhay,
I recommend that you use the OLE DB data provider for FoxPro and Visual
FoxPro.
There are two formats that the connection string should take, depending on
what data you have.
For FoxPro "free" tables use just the path to the directory where the DBFs
are: "Provider=VFPOLEDB.1;Data Source=C:\Temp;" Note that the Data Source is
not in quotes it's delimited bye the equal sign and the semicolon. When you
want to work with a specific table you'll specify it in your SQL string:
strSQL = "Select * From SomeTable" (Table is C:\Temp\SomeTable.dbf)
For Visual FoxPro tables that belong to a "Database Container" you need to
specify the DBC in the connection string: "Provider=VFPOLEDB.1;Data
Source=C:\Temp\MyDBC.dbc;" If a DBC file is present with the DBFs then use
this format, otherwise use the free table format. Again refer to a specific
table in your SQL command: strSQL = "Select * From SomeTable"
--
Cindy Winegarden MCSD, Microsoft Most Valuable Professional
cindy@xxxxxxxxxxxxxxxxxxx
<abhayjoukani@xxxxxxxxx> wrote in message
news:1149152593.375819.122600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
string strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\mmyyyy.dbf;Extended Properties=DBASE IV;";
System.Data.OleDb.OleDbException: 'c:\mmyyyy.dbf' is not a valid path.
PN :- i have tries this connection string also
"Provider=VFPOLEDB.1;Data Source="C:\mmyyyy.dbf;"
.
- References:
- invalid path error while accessing FOXPRO table from c#
- From: abhayjoukani
- invalid path error while accessing FOXPRO table from c#
- Prev by Date: invalid path error while accessing FOXPRO table from c#
- Next by Date: Re: SQLConnection still working after KILL the SQL process
- Previous by thread: invalid path error while accessing FOXPRO table from c#
- Next by thread: Re: SQLConnection still working after KILL the SQL process
- Index(es):
Relevant Pages
|
|
