Hi Pappas,



Well, the host is me actually (IIS5). The one who is in DB trouble. The 

other, public one (IIS4), is still working alright.



And I have done some upgrading lately, namely Win2000pro and maybe 

something more. I'm not sure (Windows update).



And what concerns the security business, this is really still something 

like a dark spot to me. So i'm not sure about how to correctly set all 

the permission and security settings. I guess they comprise both the Win 

system aswell as the webserver itself and the projects and 

subdirectories and files...



Anyway I gave full access to everyone on the datastore folder where the 

databases resides. But the problem is still there.



Maybe I missed something out?  Please tell me if you know.

Your problem is like the problems I had in the past

The database seems to be read only or 

the read write permissions for the folder that contains the database are not set properly.

Or cursor type-location properties but you said it is working in another server.

=================================

set myConnection = Server.CreateObject("ADODB.Connection")



set rs = Server.CreateObject("ADODB.Recordset")



myConnection.Open "Driver={Microsoft Access Driver (*.mdb)};" & _

      "Dbq=" & Server.Mappath("../datastores/Movie2000.mdb ")& ";" ,IUSR,"" 



SqlString = "SELECT * FROM ........ WHERE ..... = ...........



rs.open SqlString ,myConnection,3,3 



If (rsTitleList.BOF) AND (rsTitleList.EOF) then

  Response.Write("Sorry anable to find item ")



ELSE

............do what you want here

end if

============================

try this connection

check the path (datastores in this one is out of the root directory) and modify it.

Also a very very helpfull site on connections and the error you get

visit kens site ( great work Ken thank you )

http://www.adopenstatic.com/



Let me know if it helps

Regards

Nikos



At 09:01 μμ 6/7/2001 +0200, you wrote:

>Hi Pappas,

>

>Well, the host is me actually (IIS5). The one who is in DB trouble. The 

>other, public one (IIS4), is still working alright.

>

>And I have done some upgrading lately, namely Win2000pro and maybe 

>something more. I'm not sure (Windows update).

>

>And what concerns the security business, this is really still something 

>like a dark spot to me. So i'm not sure about how to correctly set all 

>the permission and security settings. I guess they comprise both the Win 

>system aswell as the webserver itself and the projects and 

>subdirectories and files...

>

>Anyway I gave full access to everyone on the datastore folder where the 

>databases resides. But the problem is still there.

>

>Maybe I missed something out?  Please tell me if you know.

>

>

>