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.
|