OdbcConnection.GetSchema("tables") all wrong for .dbf file

[David Thielen]

Hi;

I do the call:

using (OdbcConnection conn = new OdbcConnection("Driver={Microsoft
dBase Driver (*.dbf)};datasource=c:\test\60118.DBF"))
{
conn.Open();
DataTable schemaTable = conn.GetSchema("tables");

and it returns 4 tables, none of which are actual tables in the
database. Any idea why?

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Lingzhi Sun [MSFT]]

Hi David,

There are some known scenarios where dBase Driver does not co-operate with
FoxPro well. Generally we suggest customers using OLE DB Provider for
Visual FoxPro:
http://www.microsoft.com/downloads/details.aspx?familyid=e1a87d8f-2d58-491f-
a0fa-95a3289c5fd4&displaylang=en#filelist

The sample connection strings of this OLE DB Provider for Visual FoxPro can
be found here:
http://www.connectionstrings.com/visual-foxpro

You can refer to the following code snippet to retrieve the data schemas.
======================
OleDbConnection conn =
new OleDbConnection(
@"Provider=vfpoledb;Data Source=c:\test\");
conn.Open();
DataTable dt = conn.GetSchema("tables");
conn.Close();
======================

Please note:
The data source is the folder that contains the .dbf files, the above code
snippet will get all the data table information of the .dbf files inside
the folder. Please modify the connection string or move the .dbf file to
other folder based on your detailed target.

If you have any other questions, please be free to let me know.


Regards,
Lingzhi Sun ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/en-us/subscriptions/aa948868.aspx#notifications.

MSDN Managed Newsgroup support offering is for non-urgent issues where an
initial response from the community or a Microsoft Support Engineer within
2 business day is acceptable. Please note that each follow up response may
take approximately 2 business days as the support professional working with
you may need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.