Using ASP without ODBC

[nickc]

Can anyone point me in the direction of some ASP code that doesn't involve using an ODBC source to open an access database? Thanks.

Nick

[paulhiles]

Hi Nick,

This taken from Aspin.com:

Dim cnDB
Dim Rs
Dim strConn

set cnDB = server.CreateObject ("ADODB.Connection")
strConn = "Data Source=" & Server.MapPath("Wherever\YourDatabase")
cnDB.Open "Provider=Microsoft.Jet.OLEDB.4.0; " & strConn
set Rs = server.CreateObject ("ADODB.Recordset")
Rs.Open "SELECT * FROM YourTable WHERE YourCondition, cnDB, 1

You need to be looking for references to DSN-less connections or connection strings that use OLEDB or ADO. Here are a couple of links to be going on with.

http://www.prezzatech.com/support/kbarticle.asp?ID=2
http://stardeveloper.com:8080/articl...0120101&page=1

Hope that helps,

Paul