473,378 Members | 1,621 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Visual Fox Pro DBF connection saying Not A Table

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
0 3290

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

Similar topics

6
by: Harlan Messinger | last post by:
When a table has multiple layers of column and/or row headings, as we know, there are a couple of options for making the table accessible. Using a *scope* attribute is fine as long as the number of...
1
by: V.V. Singh | last post by:
Hi Everyone, This is my code for making a connection to a Visual FoxPro free table and querying it. I get the following error message File iddxstrippunc.prg does not exist I have tested...
14
by: jj | last post by:
Is it possible to call a remote php script from within Access? I'm thinking something like: DoCMD... http://www.domain.com/scripts/dataquery.php DoCmd.OpenQuery "update_data", acNormal, acEdit...
6
by: Chris Szabo | last post by:
I've created a data access layer for a .NET web application. I'm using C# and framework 1.1. I'm getting an error from time to time when I close a connection saying: ...
1
by: kito | last post by:
Hi, I have a problem, when I want to access to my SQL Server Express database from my ASP.NET application. My workstation ID is KITOLAP-HP My username is user01 Now I built the following...
11
by: Deluxe flame | last post by:
I created a program where the user can click a button that will add a button into the table layout. I was wondering if there was a way/code that can enable me to give the new button functions for...
3
by: Sludge | last post by:
Hi! I am brand new here. I am extracting data from a database table in access and then populating an array in visual basic (VBA in access currently). I would like to reformat this array and...
7
by: Allie | last post by:
Here's an example of what I'm trying to do: <table> <tr style="text-align:left; font-size:10pt; font-weight:bold"> <!-- I want this word to align to the left --> ' ||CRPT|| ' <!-- I want this...
0
by: dsmelser83 | last post by:
This is my first attempt at using a CrystalReportViewer control, so please forgive me if I'm making some obvious mistake. Here are the steps I'm taking to try to populate it with a very simple...
0
by: moekeria | last post by:
Why is importrows not working in my code: dsportalresas is a dataset with 1 row from a connection and i want to copy these rows to another table (same structure) in another connection, i have no...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.