Well..

• • Reply

  18 years ago

  by Nigorr

  Nicholas Orr

  Brisbane, Australia, Australia

  Joined 19 years ago

  What I have here is the basics for connecting to a database. I have done a bit of ASP stuff and I don't know if it is the same but you can try.
  

  
  

  Code:

  
   ' * Database connection Strings * '
   strdbname = databse.mdb
   
   ' * Open Database * '
   Set oConn = CreateObject("ADODB.Connection")
   oConn.Open ("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & strdbname & ";")
   strdbsql = "SELECT * FROM tablehere ORDER by " & 'variable here
   Set oRS = oConn.Execute(strdbsql)
  

  
   ' * Close Database * '
   oConn.Close
   Set oRS = Nothing
   Set oConn = Nothing
  

  Report abuse