trouble when using m$ access in Active Server Object with ADO

kaven

Delphi Developer

Fri, 04 Feb 2005 17:25:26 GMT

trouble when using m$ access in Active Server Object with ADO

I am developing a Active Server Object which uses ADO to connect a m$
Access database. But in normal setting IIS server don't reply
when I visit asp using this asp component. When I debug it,
I will get error
Project DLLHOST.EXE raised exception class EOleException with Message
'unknown error'.
When using SQL Server, It works fine. But It is too small to using SQL
Server.
Now I find a way to let it work fine with m$ Access:
Set anonymous connect to windows account form IUSR_computername to
Adminstrator.
But it is too dangerous and trouble when I need use this component in
other computers.
Anyone can give me some advice?

Kaven

Andreas Schmid

Delphi Developer

Fri, 04 Feb 2005 22:48:17 GMT

Re:trouble when using m$ access in Active Server Object with ADO

"kaven" <unm...@sf.com> schrieb im Newsbeitrag
news:3D60B986.8060803@sf.com...

Quote

> I am developing a Active Server Object which uses ADO to connect a m$
> Access database. But in normal setting IIS server don't reply
> when I visit asp using this asp component. When I debug it,
> I will get error
> Project DLLHOST.EXE raised exception class EOleException with Message
> 'unknown error'.
> When using SQL Server, It works fine. But It is too small to using SQL
> Server.
> Now I find a way to let it work fine with m$ Access:
> Set anonymous connect to windows account form IUSR_computername to
> Adminstrator.
> But it is too dangerous and trouble when I need use this component in
> other computers.
> Anyone can give me some advice?

Does the user "IUSR_computername" have read and write access to your
database file?

Does this user have the right to create a file in the directory
where your db file is stored? (the jet engine wants to create the
file xxx.ldb)

If not, give this user the explicit permission
(explorer->properties->security)
to read/write the directory.

greetings
Andreas Schmidt

Other Threads

1. ADO connection from Active Server Object app

2. How to get the number of active connections in SQL Server (using ADO)

3. Active X Library, Active Server Object and ASP

4. Displaying Embedded OLE Object using ADO from MS Access DB

5. Manipulating MS Access OLE object fields using ADO

6. Access Denied problem when calling a server object using DCOM

7. Active Server Page objects?

8. Active Server Object

9. Problem with Active Server Object

10. Problem with IIS and Active Server Object