Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Open DBF Table in C# .NET
Message
From
16/05/2016 18:49:09
 
General information
Forum:
Visual FoxPro
Category:
Visual FoxPro and .NET
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01636458
Message ID:
01636462
Views:
72
>Hi friends,
>
>I need to open a VFP9 free table (DBF) in C # .NET.
>
>I'm trying via ODBC but is presenting the msg:
>
>ERROR [IM002] [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified
>
>My font:
>
>public static DataTable GetDataTableDBF(string strFileName)
> {
> System.Data.Odbc.OdbcConnection conn = new System.Data.Odbc.OdbcConnection( "Driver={testdbf};SourceType=DBF;SourceDB=c:\\windows\\syswow64\\;Exclusive=No");
>
>
> conn.Open(); // The error is here
>
> }
>
>Can someone help me ?
>
>Thanks in advance,
>
>[]´s
>
>Dionísio

This works for me
 connectionString="Provider=VFPOLEDB.1;DELETED=YES;Data Source=d:\apps\yourdata\" providerName="System.Data.OleDb"
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.
Previous
Reply
Map
View

Click here to load this message in the networking platform