ASP Discovery

nathan schmoll's
aspdiscovery

back to main page

e-mail me

<script language="javascript" src="http://ads.aspalliance.com/displayad.aspx?t=2&m=1&target=_parent&js=1&s=aspdiscovery&page=0.3141652374089424"></script>

<script language="javascript" src="http://ads.aspalliance.com/displayad.aspx?t=2&m=1&target=_parent&js=1&s=aspdiscovery&page=0.9175976144619518"></script>

<script language="javascript" src="http://ads.aspalliance.com/displayad.aspx?t=2&m=1&target=_parent&js=1&s=aspdiscovery&page=0.5697095333068163"></script>

<script language="javascript" src="http://ads.aspalliance.com/displayad.aspx?t=2&m=1&target=_parent&js=1&s=aspdiscovery&page=0.6368288973918567"></script>

DSN-less Database Connections!

OK, if you wanted to connect to a database in an ASP script, you'd probably connect to it using a Data Source Name (DSN), right? Why would you do that? You can open up and work with any Access database by just opening it up! That's right. There is a way to get the script to open up an Access database directly from the code. And it's actually fairly simple, too! Here's how.

Okay, we start off by mapping a path to the Access database. We'll use a database file called "salesstuff".

<%
Set MyConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("salesstuff.mdb")
MyConn.Open "Driver={Microsoft Access Driver _
(*.mdb)}; DBQ=" & MdbFilePath & ";"
%>

Then we tell the script what to select and from which table to select it from. In this example, we'll just select all the records in a table called "sales".

<%
SQL_query = "SELECT * FROM sales"
%>

You're done! All you have to do is use regular SQL commands. Now you can easily query a database without having to make a DSN to the database and bugging the heck out of the technical support people at your hosting company!