Hi Imar
 I am referring your Beginning Dreamweaver MX book
 and on chapter 10
 i'm set a Login page and the connectionstring was
 succesful and i have the database both on C:\.. and
 c:\wwwroot\...
 when i browse the Login page and when i sign in with
 the right password and username i get this results:
 Error Type:
 Microsoft JET Database Engine (0x80004005)
 Could not use ''; file already in use.
 /westminster/TMPe5t8kwolo5.asp, line 15

 i'm trying to built a same web site as the The SoccerSite in which the database works well on TheSoccerSite but not on my new one.

> the code is :
> <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
> <!--#include file="Connections/connwestminster.asp"
> -->
> <%
> ' *** Validate request to log in to this site.
> MM_LoginAction = Request.ServerVariables("URL")
> If Request.QueryString<>"" Then MM_LoginAction =
> MM_LoginAction + "?" + Request.QueryString
> MM_valUsername=CStr(Request.Form("txtUserName"))
> If MM_valUsername <> "" Then
> MM_fldUserAuthorization=""
> MM_redirectLoginSuccess="admin/nominated
> teachers.asp"
> MM_redirectLoginFailed="login.asp"
> MM_flag="ADODB.Recordset"
> set MM_rsUser = Server.CreateObject(MM_flag)
> MM_rsUser.ActiveConnection =
> MM_connwestminster_STRING
> MM_rsUser.Source = "SELECT Name, Password"
> If MM_fldUserAuthorization <> "" Then
> MM_rsUser.Source = MM_rsUser.Source & "," &
> MM_fldUserAuthorization
> MM_rsUser.Source = MM_rsUser.Source & " FROM Users
> WHERE Name='" & Replace(MM_valUsername,"'","''") &"'
> AND Password='" &
> Replace(Request.Form("txtPassword"),"'","''") & "'"
> MM_rsUser.CursorType = 0
> MM_rsUser.CursorLocation = 2
> MM_rsUser.LockType = 3
> MM_rsUser.Open
> If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then
> ' username and password match - this is a valid
> user
> Session("MM_Username") = MM_valUsername
> If (MM_fldUserAuthorization <> "") Then
> Session("MM_UserAuthorization") =
>
CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization ).Value)
> Else
> Session("MM_UserAuthorization") = ""
> End If
> if CStr(Request.QueryString("accessdenied")) <>
> "" And false Then
> MM_redirectLoginSuccess =
> Request.QueryString("accessdenied")
> End If
> MM_rsUser.Close
> Response.Redirect(MM_redirectLoginSuccess)
> End If
> MM_rsUser.Close
> Response.Redirect(MM_redirectLoginFailed)
> End If
> %>
> i would apreciate your help as you always did .
>
> all the best for all of you
> take care
> Adam

Hi Adam,

This error sounds like a security issue to me.
Did you grant the IUSR_MachineName the required permissions to the folder with the database?

What version of the book are you using? AFAIK, databases aren't covered until Chapter 11 or 12, depending on the book version....
If you're using the 2004 version, pages 390 and further discuss changing permissions. For the MX version look at page 421 and further.

HtH,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: I'm Hiding by KoRn (Track 13 from the album: Untouchables) What's This?

Hi Imar


i thank you for the last reply its worked perfectly:) i also hope you doung well.
i'm using the same the SoccerSite's technique to my website.

ah!! i have 1 more problem here which is on chapter 14 pages 510-515.
when i try to create and even i get an error message:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/westminster/admin/TMP7i2vfxce9t.asp, line 115

line 115 is: MM_editCmd.Execute

it is the same problem on the SoccerSite on line 138 which is:MM_editCmd.Execute

i am using windows xp pro /MS access 2000/IIS 6.0

How can i solev the problem plz help :)
also i want to build a screening Form with a chart result at then end of the report .which 1 of your books would you recommned ?

Many thanks

Adam

Hi Adam,

The error you're getting ("Operation must use an updateable query") looks like the previous error, and looks like a security issue to me.
What security settings did you change? Did you give the required permissions to the IUSR account for the Databases folder?
And which version of the book are you using? Are the database and the .mdb files not marked as read-only?

Re; Charting: The book doesn't cover charting, so you'll need to look elsewhere. Are you willing to pay for a third party component? Or do you want to create your own solution (not too easy....)

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Car Crash by Tricky (Track 4 from the album: Vulnerable) What's This?

Hello again

I am using the beginning dreamweaver MX

i have set the security to the database i gave the full access to the full control to
 IUSR account on the C:/folder/database and C:/wwwroot/folder/database

the database is marked Read only on the IIS
and now i am having the error :
 rsCategory.ActiveConnection = MM_connweaz_STRING

can i delete the conection and connect a new one? or what would you suggest?

Re:Chartering: i wanted to create my own 1 but as you said is not too easy then i'm willing to pay for it . could do you that and how much will you charge?

thanks again

Adam

What do you mean with this:

the database is marked Read only on the IIS

Is it read only or not? It shouldn't be, because then you cannot write to the database.
How does your connectionstring look like? What error do you get now? If you want you can delete and recreate the connection, but I don;t think that is necessary. Just open the connection page (in the Connections folder) and edit the connection string, if necessary.

I could design and build a charting component, but I don't think you want that. There are already many third party components available, like Dundas Chart: http://www.dundas.com/products/asp/i...px?Section=ASP but there are many many others as well.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi Imar
i know it is a week end and hope you will enjoy it.

i recreated a connection and set up up the database ar read, modify and write .
on the permission access to the datbase i have 3 users
System
Administrators and my account IUSR_machine name
now the problem is i'm getting an error saying:
The Microsoft Jet database engine cannot open the file 'C:\Inetpub\wwwroot\westminster\database\WEAZ.mdb' . It is already opened exclusively by another user, or you need permission to view its data.
/westminster/TMP2o1x8xeab2.asp, line 14
line 14 is: MM_rsUser.ActiveConnection = MM_connweaz_STRING

i couldn't solve the connection problem how can you help plz?

Adam

1 more thing sorry .
there is the code string coonection

<%
' FileName="Connection_ado_conn_string.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_connweaz_STRING
MM_connweaz_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source= C:\Inetpub\wwwroot\westminster\database\WEAZ.mdb; User Id=admin; Password="
%>

Hi Adam,

Where did you assign the permissions? I assume you changed the NTFS permissions and not anything in the database itself?
If you changed the NTFS permissions, did you set them for the WEAZ.MDB file or for the folder C:\Inetpub\wwwroot\westminster\database\ ??

Imar

Thanks Imar

I set the NTFS permissions for
the C:/westminster/database
and to C:\Inetpub\wwwroot\westminster\databasebut not to the WEAZ.MDB file

Thanks again