VFP 8 and ODBC connection
- From: Adrian <Adrian@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 2 May 2008 09:01:01 -0700
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
.
- Follow-Ups:
- Re: VFP 8 and ODBC connection
- From: Dan Freeman
- Re: VFP 8 and ODBC connection
- Prev by Date: Re: disable read only
- Next by Date: Re: VFP 8 and ODBC connection
- Previous by thread: disable read only
- Next by thread: Re: VFP 8 and ODBC connection
- Index(es):
Relevant Pages
|
