Member Avatar for amathias

I am trying to access a SQL database and run a query. I am brand new with ASP and simply need the syntax to login and the for SQL queries in ASP. Any help would be appreciated, Thanks!

Andrew

  • 2 Contributors
  • 1 Reply
  • 94 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by campkev
Member Avatar for campkev

are you looking for something like this?

Set dbConn = Server.CreateObject("ADODB.Connection")
dbConn.ConnectionTimeout = 60 
dbConn.CommandTimeout = 300
dbConn.Open "DSN=DSNNAME;DATABASE=DATABASENAME","USERNAME","PASSWORD"

Set rsCustomers = Server.CreateObject("ADODB.RecordSet")
rsCustomers.ActiveConnection = dbConn


strSQL = "Select * From Customer where customerid = 1"
rsCustomers.Open strSQL,,1,3
If NOT(rsCustomers.EOF) Then
  customerName = rsCustomers("CustomerName")
  password = rsCustomers("CustomerPassword")
End If


rsCustomers.Close 
Set rsCustomers = NOTHING
dbConn.Close  
Set dbConn  = NOTHING
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.