Databases With ASP & VBscript

[pradnyesh]

How to use access database within the web directory when you dont have dsn setup on the server

Can anybody tell me or direct me to some link

[Clunietp]

I'm not sure if this is what you're looking for, but here it is.


dim cn
dim rs

set cn = Server.CreateObject("ADODB.Connection")

cn.open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=relativepath\MyDb.mdb"

set rs = cn.execute("Select * from MyTable",,1)

do until rs.eof = true
response.write rs.fields(0).value & "<BR>"
rs.movenext
loop

cn.close
set cn = nothing
set rs = nothing