Re: VFP 8 and ODBC connection

• From: "Dan Freeman" <spam@xxxxxxxxxxxxx>
• Date: Mon, 5 May 2008 08:51:41 -0700

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

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

• References:
  • VFP 8 and ODBC connection
    • From: Adrian
  • Re: VFP 8 and ODBC connection
    • From: Dan Freeman
  • Re: VFP 8 and ODBC connection
    • From: Adrian

• Prev by Date: Re: VFP 8 and ODBC connection
• Next by Date: newbie IF FILE() not working on Map drive
• Previous by thread: Re: VFP 8 and ODBC connection
• Next by thread: Product key invalid
• Index(es):
  • Date
  • Thread

• Windows
• Science
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint