Re: VC++ ADO VFPOLEDB: DB locally works; DB on NT server does not

Hi Jim,

As you've realized, you've got a permissions issue. ADO seems to be using a
different user than you when you access the data. Have you tried specifying
a password in the connection string? Is there anything in your AppConfig
file that might influence security permissions?

--
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@xxxxxxx www.cindywinegarden.com


"Jim Walsh" <JimWalsh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E10FEF14-C64A-41ED-A3FA-0087EB6F5E61@xxxxxxxxxxxxxxxx
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.

Thanks,



.

Relevant Pages

  • Re: Reading with ADO from Access database over network
    ... I suspect the *problem* isn't the failure to open the folder ... check the active Connection ... Perhaps you could follow the above instructions and post the *ADO* ... > exclusively the database. ...
    (microsoft.public.excel.programming)
  • Re: ActiveConnection works at one host but not at another
    ... I'd set the permissions for the .mdb file, ... I used a connection string because I'd read some forum ... Access 2002 database. ... I notice that instead of an explicit connection object, ...
    (microsoft.public.inetserver.asp.db)
  • Re: Reading with ADO from Access database over network
    ... Is your ADO code trying to open the Connection with exclusive locks ... If so, instead consider locking the ... workgroups security so the database is only locked when someone with ...
    (microsoft.public.excel.programming)
  • RE: Jet database access problem from web service
    ... "Sonya" wrote: ... > I have trouble connecting to Access database from my web service. ... > normal user who has full permissions over Data directory; ... > I also tried an Odbc connection with with the follwoing string: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: (Newbie)Application Roles
    ... level: the database itself. ... SQL Server accommodates these needs through the use of application ... the user's connection through a specific application. ... the connection permanently loses all permissions applied to ...
    (microsoft.public.sqlserver.security)