Minor problem with ASPdb Free

[Leon Cych]

I have managed to install ASPdb Free on our little school's NT server in a Front Page Directory.

It works fine.

When I log off from the server I cannot read the db and get :

"Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object

/smartdb.asp, line 38"

Any ideas?

This isn't a business environment so, for security, I have to have log off from the server otherwise little hands may well hack into it...

Cheers,

Leon Cych

[mark]

-
Hi Leon,

Here is a possibility:

PROBABLE CAUSE:
Received the following error when running a query on ANY Microsoft
Access database AND the server has no one logged into it locally:

Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object.

SOLUTION:

Using MTS, when you create a Package, the Account it uses is:
'Interactive user - the current logged on user'. That's all well
and good until you log off from the server! The solution to having
your ASPdb DLL run while your server is logged is simple:

1) Open MTS (Internet Service Manager)
2) Click on Computers / My Computer / Packages Installed /
name_of_aspdb_package
3) Right click on that package and choose Properties
4) Choose the IDENTITY tab and click on "This user:"
5) Enter the user id and password for an ID with read and execute
privileges for that DLL.
As a test only, you can just use an Admin id & password.
6) Click OK to apply the changes.

That should fix it.
Mark.


------------
Leon Cych at 11/24/99 9:10:30 AM

I have managed to install ASPdb Free on our little school's NT server in a Front Page Directory.

It works fine.

When I log off from the server I cannot read the db and get :

"Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object

/smartdb.asp, line 38"

Any ideas?

This isn't a business environment so, for security, I have to have log off from the server otherwise little hands may well hack into it...

Cheers,

Leon Cych

[Leon Cych]

Cheers Mark,

Will try that one out!

Leon Cych


------------
mark at 11/24/99 9:24:18 AM

-
Hi Leon,

Here is a possibility:

PROBABLE CAUSE:
Received the following error when running a query on ANY Microsoft
Access database AND the server has no one logged into it locally:

Microsoft VBScript runtime error '800a01ad'
ActiveX component can't create object.

SOLUTION:

Using MTS, when you create a Package, the Account it uses is:
'Interactive user - the current logged on user'. That's all well
and good until you log off from the server! The solution to having
your ASPdb DLL run while your server is logged is simple:

1) Open MTS (Internet Service Manager)
2) Click on Computers / My Computer / Packages Installed /
name_of_aspdb_package
3) Right click on that package and choose Properties
4) Choose the IDENTITY tab and click on "This user:"
5) Enter the user id and password for an ID with read and execute
privileges for that DLL.
As a test only, you can just use an Admin id & password.
6) Click OK to apply the changes.

That should fix it.
Mark.


------------
Leon Cych at 11/24/99 9:10:30 AM

I have managed to install ASPdb Free on our little school's NT server in a Front Page Directory.

It works fine.

When I log off from the server I cannot read the db and get :

"Microsoft VBScript runtime error '800a01ad'

ActiveX component can't create object

/smartdb.asp, line 38"

Any ideas?

This isn't a business environment so, for security, I have to have log off from the server otherwise little hands may well hack into it...

Cheers,

Leon Cych

[Leon Cych]

Thanks Mark,

Works like a dream - one contented teacher and 60 KIDS!!!

Leon Cych

http://www.rmplc.co.uk/eduweb/sites/allsouls/index.html