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.CreateOb ject("ADODB.Con nection")
ConnDBFcc.Open "Driver=Microso ft Visual FoxPro " _
& "Driver;SourceT ype=DBF;SourceD B=\\servername\ folder\data\;"_
& "BackgroundFetc h=no;"
SQLf = "SELECT * FROM table "
ConnDBFcc.Execu te(SQLf)
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.CreateOb ject("ADODB.Con nection")
ConnDBFcc.Open "Driver=Microso ft Visual FoxPro " _
& "Driver;SourceT ype=DBF;SourceD B=\\servername\ folder\data\;"_
& "BackgroundFetc h=no;"
SQLf = "SELECT * FROM table "
ConnDBFcc.Execu te(SQLf)