View Single Post
  #1 (permalink)  
Old June 14th, 2017, 04:30 PM
lithgowers lithgowers is offline
Registered User
Points: 35, Level: 1
Points: 35, Level: 1 Points: 35, Level: 1 Points: 35, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: May 2012
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connect to DBF table, saying not a table.

I have a legacy system and am trying to read the entries of a DBF file. It is free standing, does not have a container. I can read other DBF files in the directory however this one throws the error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Visual FoxPro Driver]Not a table.


This is my connection string that works for the other DBF tables in the directory:

Set ConnDBFcc = Server.CreateObject("ADODB.Connection")
ConnDBFcc.Open "Driver=Microsoft Visual FoxPro " _
& "Driver;SourceType=DBF;SourceDB=\\servername\folde r\database\;"_
& "BackgroundFetch=no;"

SQLf = "SELECT * FROM people "
ConnDBFcc.Execute(SQLf)


Thanks for any help.
Reply With Quote