Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Unanswered: Connecting database to website

    I am trying to develop an ordering system for a food shop. It should allow customers to place orders over the web. Customers should be able to log in with a unique user name and password.

    I have no problems creating the database. I can also create the website but my problem is how do I actually connect an access database to a website that I am going to create?

    Would an alternative database application such as oracle be easier to implement?

    Any suggestions would be very much appreciated. Thanks

  2. #2
    Join Date
    Jan 2004
    Location
    austin
    Posts
    146
    this is what i used in ASP.NET (look in your help file(s)

    Code:
        Dim strSource As String = "blockers.mdb"
        'Holds connection string
        Dim strConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\Aus-reporting\auditing\Tools\" & strSource
        'Holds connection parameters to database
        Dim oleConn As OleDbConnection = New OleDbConnection(strConnection)
        'Provides access to data in database
        Dim oleDataAdapter As OleDbDataAdapter
    
        Public Sub OpenDataSet(ByVal DS As DataSet, ByVal strQuery As String, ByVal strTableName As String)
            ' purpose: to open a connection, data adapter, and dataset
            ' inputs: SQL statement and name of table/query in dataset
            ' outputs: none directly, but it opens and fills the dataset
            ' author:  Fred Koonz
            ' date: 3/10/2004
    
            ' define data connection and data adapter
            oleConn = New OleDbConnection(strConnection)
            oleDataAdapter = New OleDbDataAdapter(strQuery, oleConn)
            ' open the connection and dataset 
            Try
                oleConn.Open()
                ' fill the dataset
                oleDataAdapter.Fill(DS, strTableName)
    
            Catch ex As Exception
                Response.Write(ex.Message)
            Finally
                oleConn.Close()
            End Try
        End Sub
    
    
    
    sub BLAH()
    
                Dim strSQL As String
                strSQL = "INSERT INTO tblBlockers (BlockerNum, ReportName, Purpose, Criteria, ClaimsReview) VALUES (" & txtBlockerNum.Text & ", " & Chr(34) & txtReportName.Text & Chr(34) & ", " & Chr(34) & txtPurpose.Text & Chr(34) & ", " & Chr(34) & txtCriteria.Text & Chr(34) & ", " & Chr(34) & txtClaimsReview.Text & Chr(34) & ")"
                'insert data into tblBlockers
                dsData.Clear()
                Try
                    OpenDataSet(dsData, strSQL, "tblBlockers")
                Catch ex As Exception
                    Response.Write(ex.Message)
                    addOK = False
                End Try
    end sub

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    PHP -> MySQL is the generally accepted standard for active web content. Asp is what you need if you're dead set on using ms access or have a line on cheap MSSQL server hosting.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •