By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,162 Members | 1,038 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,162 IT Pros & Developers. It's quick & easy.

Visual Fox Pro DBF connection saying Not A Table

P: 1
I have a legacy system that I am maintaining 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\data\;"_
& "BackgroundFetch=no;"

SQLf = "SELECT * FROM table "
ConnDBFcc.Execute(SQLf)
Jun 14 '17 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.