Re: Accessing Foxpro tables from ADO

Hullo Gerard -
I can't pinpoint what the problem is exactly - but -
IF the database is ON the webserver - then I would suggest to you that
somehow the index file is set to read only access for the web server account
of iUSR (or some similar name).

If the database resides on a network share FROM the webserver, then there's
some other things you'll need to do for user rights for the webservers iUSR
account...

Sorry I can't be more specific - perhaps someone else here can pick this up?
regards [Bill]

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"Gerard Harris" <gerard.harris@xxxxxxxxxx> wrote in message
news:#VBNurTQGHA.720@xxxxxxxxxxxxxxxxxxxxxxx
The development PC is XP service pack2

The webserver is IIS 5.1


It's using version 9.0.0.3504 of vfpoledb.dll

Regards


Gerard


"swdev2" <wsanders@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uTS8ymTQGHA.4900@xxxxxxxxxxxxxxxxxxxxxxx
Hullo Gerard -

what is name/version of webserver software?
what os does the webserver run on?
what version of the vfp oledb driver set is installed on the web server
machine?

regards [Bill]

--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.terrafox.net www.viasqlserver.net

"Gerard Harris" <gerard.harris@xxxxxxxxxx> wrote in message
news:#vn9hiTQGHA.4900@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

We wish to access a Foxpro database from a web page and use the
follwing
connection string


Set coni = Server.CreateObject("ADODB.Connection")
coni.ConnectionString = "Provider=vfpoledb.1; data source=" &
thisSuperstore
& "items.dbc;exclusive='No';"
coni.open

Set rs2=Server.CreateObject("adodb.recordset")
rs2.CursorLocation = adUseServer
rs2.Open "items", coni, adOpenKeyset, adLockOptimistic,
adCmdTableDirect
rs2.Index = "prod_code"

It all goes wrong on the last line with the message:

Error Type:
ADODB.Recordset (0x800A0CB3)
Current provider does not support the necessary interface for Index
functionality.


Anone any idea on how to fix this problem?
Gerard Harris
gerard.harris@xxxxxxxxxx








.

Relevant Pages

  • Re: database trying to open localy instead of off server.
    ... > The shown address is an absolute address on the web server ... > with a connection to the DSN name of the database but access ... >>> I have placed my database onto my webserver and opened the data access ... >>> How can I tell this connection string to look on my webserver for the ...
    (microsoft.public.access.gettingstarted)
  • Re: Jails and loopback interfaces
    ... * runs webserver ... binds to real interface with real, ... * runs database server ... it is a good idea to _always_ bind jails to non- ...
    (FreeBSD-Security)
  • Re: database trying to open localy instead of off server.
    ... The shown address is an absolute address on the web server ... I can see that Front Page will insert database components ... >> I have placed my database onto my webserver and opened the data access ... >> How can I tell this connection string to look on my webserver for the ...
    (microsoft.public.access.gettingstarted)
  • Re: Query regarding virtual path and physical path
    ... anything Web Server specific. ... I have httpd webserver and once i give it goes to remote ... The database file cannot be found. ... I set virtual path in my webserver. ...
    (microsoft.public.windowsce.embedded)
  • Re: freebsd jail: web and database server config questions
    ... The webserver will need to connect to the database system on startup and update the database based on client access. ... I would setup two jails on the system and run the database in one jail and the webserver in the other. ... I thought that a key-feature of a jailed system is that it can't access resources outside the jail. ...
    (freebsd-questions)
Loading