p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/)
-   Classic ASP Professional (http://p2p.wrox.com/classic-asp-professional-63/)
-   -   Connect to DBF table, saying not a table. (http://p2p.wrox.com/classic-asp-professional/99554-connect-dbf-table-saying-not-table.html)

lithgowers June 14th, 2017 04:30 PM

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.


All times are GMT -4. The time now is 03:30 AM.

Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
2013 John Wiley & Sons, Inc.