Trying to connect to Access database on server called "msgboard.mdb" and extract from a table called BBS with all files in same folder...
---
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "msgboard.mdb"
SQL="SELECT ID,Name,Posted,Subject FROM BBS WHERE NEXT=0 ORDER BY Posted DESC"
set RS=Conn.Execute(SQL)
do while NOT RS.EOF
---
Returns error Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Have you created an ODBC Driver? If not, go to Control panel->Administrative Tools ->Data Sources (ODBC), double -click it and choose the System DSN tab.Click Add and find Microsoft Access Driver. On the next screen, click select and choose your database. After that define an alias name in the "data source name" textbox.Make the change below in your script:

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DSN=the_alias_name"

The other way around is a DSN-less connection, in which you have to define the Driver and the physical path to the database in one big string :). More info on this link:
http://www.able-consulting.com/ADO_Conn.htm

Take a look at DNSLess Connection and OLEDB Provider For Microsoft Jet

Cheers
Kostas Lagos

Set Conn=Server.CreateObject("ADODB.Connection")
Conn.open "Provider=Microsoft.JET.OLEdb.4.0; data source=" & Server.MapPath("/path to your *.mdb")
sql="SELECT ID,Name,posted,Subject FROM BBS WHERE next='0' order by posted DESC"
Set RecSet=Server.Createobject("ADODB.RecordSet")
RecSet.open sql,Conn

If RecSet.EOF Then
Response.Write("There are no records in the database")
Else
Do While Not RecSet.EOF

Do something

RecSet.MoveNext
Loop



Here you have some code that might help you...........