Access using asp.net and password

Discussion in 'Databases' started by needrepairn, Dec 1, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. needrepairn

    needrepairn

    I am using an asp.net page to display data from Access database. Works if not password protected, but when I add a password to the database, then upload and change my asp.net code by adding ;password=thepassword; I get the following error:

    Server Error in '/' Application.

    Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

    Following is query.aspx file:

    <%@ Page Language="VB" Debug="true" %>
    <%@ Import namespace="System.Data" %>
    <%@ Import namespace="System.Data.OleDb" %>

    <html>
    <head>
    <title>Connecting to Access Database</title>
    </head>



    <H3>Connecting to an Access Database</H3>
    <asp:Datagrid id="dgSuppliers" runat="server" />
    </body>

    </html>

    <script language="VB" runat="server">

    Sub Page_Load(Source As Object, E as EventArgs)
    Dim strConnection As String = "Provider=Microsoft.Jet.Oledb.4.0;data source=E:\web\needrepairn\htdocs\blank.mdb;password=mytele;"

    Dim objConnection as New OleDbConnection(strConnection)

    Dim strSQL as string = "Select * from bills"

    dim objCommand as New OleDbCommand(strSQL, objConnection)
    <%--server.mappath --%>
    objConnection.Open()
    dgSuppliers.Datasource = objCommand.ExecuteReader()
    dgSuppliers.DataBind()
    objConnection.Close()
    End Sub
    </script>
     
    needrepairn, Dec 1, 2003
    #1
  2. needrepairn

    needrepairn

    I added ;User Id=admin; and get the same error. It does work with asp code without supplying a user id. I know the password is correctly database protected as I must supply the password when I use the ASP code. You can check it out at www.needrepair.net/query.asp.

    try sql of select * from clients; pwd is mytele
     
    needrepairn, Dec 2, 2003
    #2
  3. needrepairn

    needrepairn

    that would be database is correctly password protected.
     
    needrepairn, Dec 2, 2003
    #3
  4. needrepairn

    needrepairn

    This works after change to source= line:
    http://beta.experts-exchange.com/Programming/Programming_Languages/Dot_Net/Q_20663455.html

    <%@ Page Language="VB" Debug="true" %>
    <%@ Import namespace="System.Data" %>
    <%@ Import namespace="System.Data.OleDb" %>

    <html>
    <head>
    <title>Connecting to Access Database</title>
    </head>



    <H3>Connecting to an Access Database</H3>
    <asp:Datagrid id="dgSuppliers" runat="server" />
    </body>

    </html>

    <script language="VB" runat="server">

    Sub Page_Load(Source As Object, E as EventArgs)
    Dim strConnection As String = "Provider=Microsoft.Jet.Oledb.4.0;data

    source=E:\web\needrepairn\htdocs\blank.mdb;User Id=admin;Jet OLEDB:Database Password=mytele;"

    Dim objConnection as New OleDbConnection(strConnection)

    Dim strSQL as string = "Select * from clients"

    dim objCommand as New OleDbCommand(strSQL, objConnection)
    <%--server.mappath --%>
    objConnection.Open()
    dgSuppliers.Datasource = objCommand.ExecuteReader()
    dgSuppliers.DataBind()
    objConnection.Close()
    End Sub
    </script>
     
    needrepairn, Dec 2, 2003
    #4
  5. Bruce

    Bruce DiscountASP.NET Staff

    Did you password protect your database?

    You can do that in MS Access

    - Tools -> Security -> Set database password

    In addition, you'll need to specify the useraccount, default is admin

    Add this to your connection string

    User Id=admin

    quote:Originally posted by needrepairn

    I am using an asp.net page to display data from Access database. Works if not password protected, but when I add a password to the database, then upload and change my asp.net code by adding ;password=thepassword; I get the following error:

    Server Error in '/' Application.

    Cannot start your application. The workgroup information file is missing or opened exclusively by another user.

    Following is query.aspx file:

    <%@ Page Language="VB" Debug="true" %>
    <%@ Import namespace="System.Data" %>
    <%@ Import namespace="System.Data.OleDb" %>

    <html>
    <head>
    <title>Connecting to Access Database</title>
    </head>



    <H3>Connecting to an Access Database</H3>
    <asp:Datagrid id="dgSuppliers" runat="server" />
    </body>

    </html>

    <script language="VB" runat="server">

    Sub Page_Load(Source As Object, E as EventArgs)
    Dim strConnection As String = "Provider=Microsoft.Jet.Oledb.4.0;data source=E:\web\needrepairn\htdocs\blank.mdb;password=mytele;"

    Dim objConnection as New OleDbConnection(strConnection)

    Dim strSQL as string = "Select * from bills"

    dim objCommand as New OleDbCommand(strSQL, objConnection)
    <%--server.mappath --%>
    objConnection.Open()
    dgSuppliers.Datasource = objCommand.ExecuteReader()
    dgSuppliers.DataBind()
    objConnection.Close()
    End Sub
    </script>
    </blockquote id="quote"></font id="quote">
     
    Bruce, Dec 2, 2003
    #5
  6. needrepairn

    needrepairn

    In the asp.net code it is not possible. In the asp code, it is possible to delete records by providing a sql statement.
     
    needrepairn, Dec 3, 2003
    #6
  7. steurm

    steurm

    quote:Originally posted by needrepairn

    I added ;User Id=admin; and get the same error. It does work with asp code without supplying a user id. I know the password is correctly database protected as I must supply the password when I use the ASP code. You can check it out at www.needrepair.net/query.asp.

    try sql of select * from clients; pwd is mytele
    </blockquote id="quote"></font id="quote">

    I hope this is only a demo-database ... otherwise everybody could now delete all your records ...
    If not, change your password as quick as possible !

    --
    Steurm
    www.steurm.net/steurm
     
    steurm, Dec 3, 2003
    #7
  8. needrepairn

    needrepairn

    The name of my database is blank.mdb, so no, it is not production. Also, I have actually deleted it, changed the password and haven't uploaded it again, yet, so it won't work anymore. I hope having the working code posted here is helpful to some to jumpstart their learning or not have to go through the troubleshooting and research that I did. I think I tried the change before from password= to Jet OLEDB:Database Password= and still got an error, so perhaps adding the user id= is also necessary.
     
    needrepairn, Dec 3, 2003
    #8
  9. Bruce

    Bruce DiscountASP.NET Staff

    This is not possible.

    Unlike many other hosting companies (1 user for the whole server), we run each website using unique credential. Other websites do not have permission to even open the database.



    quote:Originally posted by steurm

    quote:Originally posted by needrepairn

    I added ;User Id=admin; and get the same error. It does work with asp code without supplying a user id. I know the password is correctly database protected as I must supply the password when I use the ASP code. You can check it out at www.needrepair.net/query.asp.

    try sql of select * from clients; pwd is mytele
    </blockquote id="quote"></font id="quote">

    I hope this is only a demo-database ... otherwise everybody could now delete all your records ...
    If not, change your password as quick as possible !

    --
    Steurm
    www.steurm.net/steurm
    </blockquote id="quote"></font id="quote">
     
    Bruce, Dec 3, 2003
    #9
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page