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

Hi Cindy,

Thanks for taking the time to respond to my posting.

Yes, it seems like a permission issue to me, but I don't know specifically
where. The VFP database itself doesn't have a password on it, although the
application that normally accesses the database does require a user password.
So, I don't think that is where the permission issue lies. For example, I can
open and manipulate the database on the server using the VFP development
system without any passwords.

But, you raise the question of ADO (and VFPOLEDB) permissions or user. Do
you know of I way that I can check on that?

Note that Excel (using VFPOLEDB) seems able to connect to the database, but
also has trouble beyond that.

Are there any debugging tools (like ODBC tracing) that can be used to tease
this problem apart?

Jim


"Cindy Winegarden" wrote:

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: 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: 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)
  • Re: Connection problem with Access
    ... If you don't need the Word object to connect, remove the relevant code as it's probably a distraction. ... However, I'm not sure you can manually connect Word to an Access data source that has a securit database, unless the Admin username and a blank password will give you access to the table you need. ... I think you'd probably have to do it the way I suggested, at lleast for an OLE DB connection. ... permissions can be relatively fine-grained, ...
    (microsoft.public.word.mailmerge.fields)
  • VFPOLEDB works on local copy of DB, but not always with network co
    ... The following is transcript of an exchange that I have had in a VFP ... What is odd is that this application works fine when the VFP database is ... and its Data Connection Wizard to create the connection to my database on ... The database on my computer is a copy of the one on the network server. ...
    (microsoft.public.win32.programmer.ole)