Re: VFP 8 and ODBC connection
- From: "Fred Taylor" <ftaylor@xxxxxxxx!REMOVE>
- Date: Sun, 4 May 2008 10:29:00 -0700
Instead of the overhead of ODBC or OLEDB, FoxPro can directly access it's
own tables via the USE command.
USE \\server\share\yourtable
If the tables are part of a database, open the database first.
OPEN DATABASE \\server\share\yourdatabase
Once the database is open, at that point you can now reference tables that
are in that database with just
USE yourtable
--
Fred
Microsoft Visual FoxPro MVP
"Adrian" <Adrian@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0A793112-78C4-49FE-9B16-412439FA7DBE@xxxxxxxxxxxxxxxx
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
â?oMicrosoft 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 â?oCannot
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 â?oEveryoneâ?? â?oAnonymous Userâ?? â?oASP.NETâ?? â?oNETWORK
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
- VFP 8 and ODBC connection
- Prev by Date: Product key invalid
- Next by Date: Re: Product key invalid
- Previous by thread: Re: VFP 8 and ODBC connection
- Next by thread: Re: VFP 8 and ODBC connection
- Index(es):
Relevant Pages
|
