dBase file in VB.Net ?

[Kirsten]

Is there a way to read a simple dBase file using vb.net (2008)?

[Frinavale]

Is there a way to read a simple dBase file using vb.net (2008)?

I'm not sure what a dBase file is.
What have you tried so far to solve your problem?
Have you researched the problem yet and have any questions about what you've discovered so far?

-Frinny

[Kirsten]

I tried:

            Dim ConString = "Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceType=DBF;" & "SourceDB=h:\act\order;Exclusive=NO;BackgroundFetch=No;Collate=Machine;"
 
            Dim odbcConn As New Odbc.OdbcConnection(ConString)
 
            odbcConn.Open()
            Dim odbcComm As New Odbc.OdbcCommand
            odbcComm.Connection = odbcConn
            odbcComm.CommandText = "select * from inv"
            Dim Dreader1 As Odbc.OdbcDataReader
            Dreader1 = odbcComm.ExecuteReader
 

And get error on the
odbcConn.Open()

ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function:

I'm not sure what a dBase file is.
What have you tried so far to solve your problem?
Have you researched the problem yet and have any questions about what you've discovered so far?

-Frinny

[Frinavale]

I tried:

            Dim ConString = "Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;SourceType=DBF;" & "SourceDB=h:\act\order;Exclusive=NO;BackgroundFetch=No;Collate=Machine;"
 
            Dim odbcConn As New Odbc.OdbcConnection(ConString)
 
            odbcConn.Open()
            Dim odbcComm As New Odbc.OdbcCommand
            odbcComm.Connection = odbcConn
            odbcComm.CommandText = "select * from inv"
            Dim Dreader1 As Odbc.OdbcDataReader
            Dreader1 = odbcComm.ExecuteReader
 

And get error on the
odbcConn.Open()

ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function:

I've never used Visual FoxPro before.
I found an awesome resource online though, it's a book titled .NET for Visual FoxPro Devlopers. I think you'd be most interested in Chapter 7: Data Access with ADO.NET. The first section in that chapter talks about the history of ODBC and FoxPro...I think this chapter may help you to understand and fix our problem (there's a lot of information there).

-Frinny