Query a SQL database with ASP using a DSN-less connection

Dim cnnSimple  ' ADO connection
Dim rstSimple  ' ADO recordset
Set cnnSimple = Server.CreateObject("ADODB.Connection")
' DSNLess
cnnSimple.Open "Provider=SQLOLEDB;Data Source=YOURDBSERVER;" _
            & "Initial Catalog=YOURDBNAME;User Id=YOURUSERID;Password=YOURPASSWORD;" _
            & "Connect Timeout=15;"
Set rstSimple = cnnSimple.Execute("SELECT * FROM tbltest")
<P> Connecting to SQL DB with DSNless connection </P>
<table border="1">
Do While Not rstSimple.EOF
              <td><%= rstSimple.Fields("id").Value %></td>
              <td><%= rstSimple.Fields("name").Value %></td>
Set rstSimple = Nothing
Set cnnSimple = Nothing
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

SQL server- network related or instance-specific error happened while connection establishing

  Instance-specific or network related error happening while connecting to SQL server   Please...

OleDB connection string examples

OleDB connection string examples MS Access (Jet) "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA...

Do you allow custom COM components?

Do you allow custom COM components? We are not offering to install the custom COM components...

Error when accessing a WCF services

Error when accessing a WCF services Error when accessing a WCF service: "IIS specified...

How to cache static contents to client with UseMaxAge?

You can consider to caches static contents to the client with UseMaxAge if your website has too...