Re: Connection to local DB works, but not to DB on network server

Richard,

Thanks for responding to my posting.

The database that I am having trouble with is on the network server, which
runs Win NT server. So, file sharing is turned on.

I have a VFP application that I developed that is in use regularly to access
that databases from workstations around the network.

I am the author of both this application, and the database that I am
attempting to access.

I can access the database on the server from my local computer using my
dedicated VFP application (that I mentioned above), and also by the VFP
development system.

My suspicion is that there is something wrong with the way the database is
configured that is causing VFPOLEDB to reject it. Incidentally, did you
notice that when I attempt to set it up as a datasource in Excel, the "Test
Connection" button is successful.

Again, I appreciate any additional help you can give me.

Jim


"Richard Mueller" wrote:

Jim Walsh wrote:

I've written an application in VC++ in VS2005 that includes access to a
VFP 9
database using ADO and the VFPOLEDB driver.

I'm using ADO (msado15.dll).

What is odd is that this application works fine when the VFP database is
on
my own computer, but when it is on the network server, and I attempt to
open
the RecordSet, I get an error saying "Feature is not available".

To test this outside of my own program, I used Excel, Import External
Data,
and its Data Connection Wizard to create the connection to my database on
the
server. When I click Test Connection, I get a message saying connection
succeeded. I then select Access permissions Read and Share Deny None. The
window that would allow me to select the table to use is empty.

If I repeat this using the VFP database on my own computer, the window
lists
all of the tables in the database.

The database on my computer is a copy of the one on the network server.

I am logged into the network using an administrative account.

I can use VFP, and open the database on the server from my computer
without
a problem.

I would appreciate your help.

Hi,

Does the remote machine with the database have File and Printer Sharing
enabled? Otherwise, I've never had trouble accessing databases (assuming I
have permissions) whether local or remote. I assume you have permissions to
access the database. Being Administrator on the computer may not be enough,
depending on how security is setup. In SQL Server you can deny permission to
everyone except those that are members of a role. If you can connect will
logged in locally, but not remotely, then I would suspect that File and
Printer Sharing is disabled.

--
Richard
Microsoft MVP Scripting and ADSI
Hilltop Lab - http://www.rlmueller.net



.