OK, I know how to fix this for Win2K & MS Access 2000



i) Make sure your actual database has security permissions setup 

appropriately. Use explorer to goto the database location ie for Access 

x.mdb get the properties up and select the security tab and set the 

IUSR_MachineName account to full access at first. ie click the 'ADD' 

button if the machine name is not present then select your computer name 

etc.



ii) 



a)Go into the Internet services manger in Administration Tools in control 

panel and get the properties for the relevant website ie right click.

b) Goto the home directory tab and remove the current application checking 

with anyone else who may be using this for UAT / Development. Add a new 

appliction and then set the Execute permissions to 'Scripts Only' and 

Application Protection to 'High (Isolated)'.

c) Enter the configuration and enable caching on all ISAPI applications.

d) Click apply and then retry the code it should work.

e) It is advisable to reduce permissions on the database one by one from 

full control as soon as you are happy until it gets to the stage of not 

working due to permissions.



Sorry for the long widiness of the above text but it seems to work and all 

of the items are required. Sorry not sure if performance is affected by 

setting the Application Protection to High :-(



Sub 





> I've got error when executing .asp file contains script below :

> 

> -----------

> <%Set Conn = Server.CreateObject("ADODB.Connection")

> Conn.Open Session("ConnectionString")                        ' <------

> Browser said this line has an error

> Set RS = Conn.Execute("SELECT * FROM Customers")

> %>

> ----------

> 

> and error type:

> 

> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

> [Microsoft][ODBC Driver Manager] Data source name not found and no 

default

> driver specified

> /

> 

> I've got error when I run the .asp script file on windows2000 with IIS,

> But If I run

>  on my Windows98 with PWS ... that .asp file run smoothly , no error 

found

> 

> What I have to do to fix the problem ?????

> 

> THanx

> 

> 

Setting the Application protection to "High (isolated)" does *nothing*.



The original poster needs to change the NTFS permissions for the folder that

the database is in, and change the permissions for the actual file.



This has nothing to do with the IIS MMC Snapin permissions.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: <sub@c...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Friday, May 04, 2001 8:20 PM

Subject: [asp_database_setup] Re: Microsoft OLE DB Provider for ODBC Drivers

(0x80004005) Error





: OK, I know how to fix this for Win2K & MS Access 2000

:

: i) Make sure your actual database has security permissions setup

: appropriately. Use explorer to goto the database location ie for Access

: x.mdb get the properties up and select the security tab and set the

: IUSR_MachineName account to full access at first. ie click the 'ADD'

: button if the machine name is not present then select your computer name

: etc.

:

: ii)

:

: a)Go into the Internet services manger in Administration Tools in control

: panel and get the properties for the relevant website ie right click.

: b) Goto the home directory tab and remove the current application checking

: with anyone else who may be using this for UAT / Development. Add a new

: appliction and then set the Execute permissions to 'Scripts Only' and

: Application Protection to 'High (Isolated)'.

: c) Enter the configuration and enable caching on all ISAPI applications.

: d) Click apply and then retry the code it should work.

: e) It is advisable to reduce permissions on the database one by one from

: full control as soon as you are happy until it gets to the stage of not

: working due to permissions.

:

: Sorry for the long widiness of the above text but it seems to work and all

: of the items are required. Sorry not sure if performance is affected by

: setting the Application Protection to High :-(

:

: Sub

:

:

: > I've got error when executing .asp file contains script below :

: >

: > -----------

: > <%Set Conn = Server.CreateObject("ADODB.Connection")

: > Conn.Open Session("ConnectionString")                        ' <------

: > Browser said this line has an error

: > Set RS = Conn.Execute("SELECT * FROM Customers")

: > %>

: > ----------

: >

: > and error type:

: >

: > Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

: > [Microsoft][ODBC Driver Manager] Data source name not found and no

: default

: > driver specified

: > /

: >

: > I've got error when I run the .asp script file on windows2000 with IIS,

: > But If I run

: >  on my Windows98 with PWS ... that .asp file run smoothly , no error

: found

: >

: > What I have to do to fix the problem ?????

: >

: > THanx