Skip to main content
A
Anonymous
March 14, 2008
Question

Problem Connecting to VFP Free Table

  • March 14, 2008
  • 2 replies
  • 377 views
ODBC Error Code = S0002 (Base table not found)

I am having a problem connecting to a data source with ColdFusion 5.0.

I have data sources setup FoxPro on both the same server that ColdFusion is installed on and another server in the domain. I also have a data source setup for a 3rd server using SQL.

I have no problems connecting to the VFP tables that are on the same server where ColdFulsion is installed. The path is setup like E:\Inetpub\wwwroot\website\databses. No problems

No problem connecting to the SQL Server databases either.

My problem comes when trying to connect to a VFP table on another server where the path is setup as \\SBT-SERVER\SBT\PRO50\. The connection is verified. I can paste this path into Windows Explorer and brings up the files and folders in this folder easily so that eliminates permissions (I think). Since I can open VFP tables on the ColdFusion server then I know it's not just a VFP driver issue.

Another issue I fnd strange is that I can change the path on the data sources to just about anything and they will verify... How can that be?

I just don't get it. Any ideas?

This topic has been closed for replies.

2 replies

A
Anonymous
March 14, 2008
You hit the nail on the head. I thought it had to be a permissions issue but couldn't get myself to check the service. Thanks a million!
N
Newsgroup_User
Inspiring
March 14, 2008
twestfall wrote:
> Another issue I fnd strange is that I can change the path on the data sources
> to just about anything and they will verify... How can that be?

I do not know, but it gives me encouragement that of this solution.

By default ColdFusion runs under the 'localsystem' user on a Windows
server. By default this user has no permissions to access resources not
on the local system such as your '\\SBT-SERVER\SBT\PRO50\'.

To allow this you need to configure the ColdFusion service in the
Windows Services Panel to run under a user that has the necessary
permissions to access the location. Ideally a specific user designed
for ColdFusion to give it permissions necessary for your requirements
and nothing more.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices