ExamGuru IT/.Net Guru : Reading FoxPro Date field frpm ODBC on microsoft.public.dotnet.framework.odbcnet

.NETGURU

Reading FoxPro Date field frpm ODBC

Messages

Related Types

This message was discovered on microsoft.public.dotnet.framework.odbcnet.

Enzo

Ok, what is the trick!!!

I am using C# to read a FoxPro DBF file.

I do the following:

Private DataSet getDBFData(string dbfFile)
{
DataSet ds = new DataSet();
string Sql;
int dbfNameStart = dbfFile.LastIndexOf(@"\");
string dbfTableName = dbfFile.Substring(dbfNameStart + 1);
//Define a connection string with file path as parameter
string Connection = "Provider=MSDASQL/SQLServer ODBC;Driver={Microsoft Visual FoxPro Driver};" +
@"SourceType=DBF;SourceDB=D:\DA197\OfficeDepot\Cleaned Data;" +
"InternetTimeout=300000;Transact Updates=True";

//This simple query is all u need to extract data. Make sure you specify filename
//with extension
Sql = "select * from " + dbfTableName;
OdbcDataAdapter OdbcConn = new OdbcDataAdapter(Sql, Connection);
OdbcConn.Fill(ds);
OdbcConn.Dispose();

return ds;
}

The problem is that the file has a date field and it is return like this: 36459.704756944

First of all, why does the driver return it like this and not a normal date, and second, how do I fix this problem???

Reply to this message...

Paul Clement

On Thu, 1 Jul 2004 21:29:01 -0700, "Enzo" <Click here to reveal e-mail address> wrote:

¤ Ok, what is the trick!!!
¤
¤ I am using C# to read a FoxPro DBF file.
¤
¤ I do the following:
¤
¤ Private DataSet getDBFData(string dbfFile)
¤ {
¤ DataSet ds = new DataSet();
¤ string Sql;
¤ int dbfNameStart = dbfFile.LastIndexOf(@"\");
¤ string dbfTableName = dbfFile.Substring(dbfNameStart + 1);
¤ //Define a connection string with file path as parameter
¤ string Connection = "Provider=MSDASQL/SQLServer ODBC;Driver={Microsoft Visual FoxPro Driver};" +
¤ @"SourceType=DBF;SourceDB=D:\DA197\OfficeDepot\Cleaned Data;" +
¤ "InternetTimeout=300000;Transact Updates=True";
¤
¤ //This simple query is all u need to extract data. Make sure you specify filename
¤ //with extension
¤ Sql = "select * from " + dbfTableName;
¤ OdbcDataAdapter OdbcConn = new OdbcDataAdapter(Sql, Connection);
¤ OdbcConn.Fill(ds);
¤ OdbcConn.Dispose();
¤
¤ return ds;
¤ }
¤
¤ The problem is that the file has a date field and it is return like this: 36459.704756944
¤
¤ First of all, why does the driver return it like this and not a normal date, and second, how do I fix this problem???

Yeah, that looks rather bizarre. Have you tried using the OLEDB provider?

http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForVisualFoxPro

Paul ~~~ Click here to reveal e-mail address
Microsoft MVP (Visual Basic)

Reply to this message...

	System.Data.DataSet
	System.Data.Odbc.OdbcDataAdapter

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification