Connecting to Access through Ado in Web service


Hello All,

Could anyone throw some light on connecting to access
database through TAdoConnection in a D7 web service.

We tried setting the connection strings datasource property
as "http://localhost/Webservice/testdb.mdb"; at design time and
tested it at design time and it fails.
We have also tried setting the database path in network format,
and get the same error.

The .mdb file resides in the same virtual directory from
which the web service runs.

The webservice is a simple D7 web service.

The connection is set using MsJet 4 and Db is
Access 2000

Any help would be greatly appreciated,

with regards,
Senthil.S


.

Relevant Pages

  • Re: One Web Service updates SQL, another cant?
    ... I guess its because this is my first Web Service and I ... it opens the database connection. ... > Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.security)
  • Re: REPOST: One Web Service updates SQL, the other cant
    ... One Web Service can access and update the database via ADO ... > possible using the following connection string: ... > Columnist, SQL Server Professional ...
    (microsoft.public.vb.database.ado)
  • Jet database access problem from web service
    ... I have trouble connecting to Access database from my web service. ... permissions into the directory where database is located; ... I also tried an Odbc connection with with the follwoing string: ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Connected := False {does not close the connection}
    ... >process is idle. ... >This is seen even at design time: ... >Drop a TADOConnection and connect to the database. ... >You will see the design-time connection in the list. ...
    (borland.public.delphi.database.ado)
  • Web Service Error
    ... I'm trying to get a web service to access a remote database, and provide a connection between the data and a Windows client. ... public bool VerifyDBAccess() { ...
    (microsoft.public.dotnet.xml)