Query an Access 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=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\test.mdb"))

Set rstSimple = cnnSimple.Execute("SELECT * FROM tbltest")

%>
<P> Connecting to Access with Ole connection </P>

<table border="1">
<%
Do While Not rstSimple.EOF
 %>
 <tr>
  <td><%= rstSimple.Fields(0).Value %></td>
  <td><%= rstSimple.Fields(1).Value %></td>
 </tr>
 <%
 rstSimple.MoveNext
Loop
%>
</table>
<%

rstSimple.Close
Set rstSimple = Nothing
cnnSimple.Close
Set cnnSimple = Nothing
%>

  • 0 Корисниците го најдоа ова како корисно
Дали Ви помогна овој одговор?

Понудени резултати

Insert data into a MS SQL database with .NET SQL Data Provider in ASP.NET

<%@ import namespace="system.data.sqlclient" %><Script runat="server">Sub page_load...

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

<%Dim cnnSimple  ' ADO connectionDim rstSimple  ' ADO recordsetSet cnnSimple =...

Query MS Access Database in PHP

Below is a simple PHP script to demonstrate how to connect to a MS Access database using ODBC...

Query MS Access Database with OleDB in ASP.net

<%@ import namespace="system.data.oleDb" %><Script runat="server">Sub page_load Dim...

Query MS SQL Database with PHP

Below is a simple PHP script to demonstrate how to connect to a MS SQL database using an ODBC...