Re: VFP 8 and ODBC connection

Using ODBC (or OLEDB, as your error message indicates) in a Foxpro
application to access Foxpro data is pointless and leads to unecessary
complications such as what you're seeing.

Foxpro is perfectly capable of using its native data engine and UNC paths.
Just remember to close any dbf (and dbc) at the end of every method. If you
switch to native table access, you may also get more meaningful error
messages. :-)

Dan

Adrian wrote:
Hi,
I am using software developed in VFP and trying to connect to the
*.DBC on a
different server. Basically the web application part of the software
is on a
dedicated application server and the database part of the software on
another
dedicated database server. I use ODBC system DSN to connect to the
*.DBC from
the web application server. I use UNC instead of map drive. I have
created a
domain user account and has distributed full writes to the servers +
application and IIS. When I run the application I get the first ASP
(classic
ASP) page which is the login page, once the user name and password
has been
eneterd this page should take us to the menu page but instead it
gives me
this error
â??Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.
/weblarms/login1.asp, line 85â??
And line 85 of the login1.asp is

'update the last successful login date
objpwdcontrol.loginupdate(session("uid"))

I have tried giving full access to all the folders available read,
write,
execute etc but it still comes up with this error. Normally â??Cannot
update
the cursorâ?? comes when the folder does not have read/write access
but in this
case they have full access to all the relevant files and folders. I
have even
given â??Everyoneâ?? â??Anonymous Userâ?? â??ASP.NETâ?? â??NETWORK
SERVICESâ?? full access to this folder but still it is not allowing
me to go further. Please any help to
resolve this matter will be very much appreciated.
Many thanks

-----------
Adrian


.

Relevant Pages

  • Re: VFP 8 and ODBC connection
    ... Instead of the overhead of ODBC or OLEDB, ... If the tables are part of a database, ... Microsoft Visual FoxPro MVP ... dedicated application server and the database part of the software on ...
    (microsoft.public.fox.helpwanted)
  • RE: Faulting Application error, Error Reading file
    ... release on all clients. ... Microsoft FoxPro Technical Support ... Windows 2003SP1 server. ...
    (microsoft.public.fox.programmer.exchange)
  • OpenRowset not working on mapped network drives ?
    ... I would like to import foxpro table data from server to client machine. ... server folder is shared and can be viewed while making odbc using Visual ... Foxpro ODBC Driver. ...
    (microsoft.public.sqlserver.programming)
  • Re: Alternative to using DSN to connect to database
    ... you have to use .NET ODBC provider. ... Server is NOT optimized. ... Just because of the Admiistrator thinking DSN is easier for him to control ... > Basically my problem is that the ODBC Connection Manager in Control Panel ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Word mail merge with foxpro
    ... I did come across an article about using FoxPro with earlier Word ... > The dbf is not attached to a dbc as I have always found that more ... The MDAC 2.5 installaion helpded greatly I am just a bit worried ... >> is to switch on ODBC logging in the ODBC administrator. ...
    (microsoft.public.word.mailmerge.fields)