Re: VFP 8 and ODBC connection

Hi Dan,

Thanks for your advice. I am pretty new for VFP, I am actually trying to
built up and debug from a project which has been going on for a while (from
2001). I am much more comfortable with VB and ASP. Could you please give me
more details on you comment "Foxpro is perfectly capable of using its native
data engine and UNC paths. If you switch to native table access"
Apologies for the trouble.
Many thanks
--
Adrian


"Dan Freeman" wrote:

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

  • VFP 8 and ODBC connection
    ... dedicated application server and the database part of the software on another ... I use ODBC system DSN to connect to the *.DBC from ... 'update the last successful login date ... I have tried giving full access to all the folders available read, write, ...
    (microsoft.public.fox.helpwanted)
  • Re: Sp1 and Eval SBS 2003 Unable to Install
    ... > * Use Outlook to export the contents in the public folders to .pst files ... > partition and clean install SBS 2003 server. ... > Another way is to create a local profile, ...
    (microsoft.public.windows.server.sbs)
  • Re: Sp1 and Eval SBS 2003 Unable to Install
    ... * Use Outlook to export the contents in the public folders to .pst files ... partition and clean install SBS 2003 server. ... Another way is to create a local profile, ...
    (microsoft.public.windows.server.sbs)
  • RE: Offline Address Book error on send/receive
    ... Hi Jenny...I've done this reset successfully on a test server so I will be ... The folders are system folders. ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: no remote folder in Remote Web Workplace
    ... You can check the files and folders for RWW site as follows (You can find ... no remote folder in Remote Web Workplace ... If the value of the key is '1', it reveals the server is at SP1. ...
    (microsoft.public.windows.server.sbs)