Fox Pro and odbcException: NO_DATA

[Chris Podmore]

I am trying to access some Fox Pro tables but for some table I get an
odbcException: NO_DATA

Some tables work and others don’t, anyone have any ideas?

Any help will be much appreciated.
Thanks in advance.
Chris.

Rather than include my applications actual code I have put some sample code
together. The code below lives in a button click handler. The ODBC driver is
6.01.8629.01

Dim odbcConn As New OdbcConnection
odbcConn.Connec tionString = "DSN=OperaI I"
odbcConn.Open()
Dim strSQL As String = "SELECT * FROM Z_CNAME"
Dim odbcAdapter As New OdbcDataAdapter (strSQL, odbcConn)
Dim dt As New DataTable

Try
odbcAdapter.Fil l(dt)
DataGrid1.DataS ource = dt
Catch ex As Exception
MsgBox(ex.ToStr ing)
End Try

If Not odbcConn Is Nothing Then
If odbcConn.State = ConnectionState .Open Then odbcConn.Close( )
odbcConn.Dispos e()
End If
odbcConn = Nothing

[Chris Podmore]

OK I think I have established what the problem is. If the Fox table contains
a memo field then I can't do SELECT *. If I SELECT field1, field2, field3 but
not the memos then it works.
"Chris Podmore" wrote:

I am trying to access some Fox Pro tables but for some table I get an
odbcException: NO_DATA

Some tables work and others don’t, anyone have any ideas?

Any help will be much appreciated.
Thanks in advance.
Chris.

Rather than include my applications actual code I have put some sample code
together. The code below lives in a button click handler. The ODBC driver is
6.01.8629.01

Dim odbcConn As New OdbcConnection
odbcConn.Connec tionString = "DSN=OperaI I"
odbcConn.Open()
Dim strSQL As String = "SELECT * FROM Z_CNAME"
Dim odbcAdapter As New OdbcDataAdapter (strSQL, odbcConn)
Dim dt As New DataTable

Try
odbcAdapter.Fil l(dt)
DataGrid1.DataS ource = dt
Catch ex As Exception
MsgBox(ex.ToStr ing)
End Try

If Not odbcConn Is Nothing Then
If odbcConn.State = ConnectionState .Open Then odbcConn.Close( )
odbcConn.Dispos e()
End If
odbcConn = Nothing

[Cindy Winegarden]

Hi Chris,

Have you considered using the Visual FoxPro OLE DB data provider? It's
downloadable from
http://msdn.microsoft.com/vfoxpro/do...s/default.aspx and works
with all versions of FoxPro tables.

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
ci************* *@msn.com www.cindywinegarden.com
"Chris Podmore" <Ch**********@d iscussions.micr osoft.com> wrote in message
news:5C******** *************** ***********@mic rosoft.com...

OK I think I have established what the problem is. If the Fox table
contains
a memo field then I can't do SELECT *. If I SELECT field1, field2, field3
but
not the memos then it works.

I am trying to access some Fox Pro tables but for some table I get an
odbcException: NO_DATA

Some tables work and others don't, anyone have any ideas?