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
amathias 0 Newbie Poster
campkev 0 Posting Pro in Training
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.