Setting up connectionless database

[hwakern]

good day,
i have database.mdb access file and want to use connectionless to connect the dababase.please help.
Below is the code i try but i can't get it worked

<%
Dim objDB
Dim DBName

DBName = "driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.MapPath("../db/database.mdb")
Set objDB = Server.CreateObject("ADODB.Connection")
objDB.Open DBName
%>

[Chris]

perhaps you can do this...


<%
Set Conn = Server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\db\database.mdb"
%>

[hwakern]

i'm upload my files to host server.
and i not sure the directory my database.mdb are put in.
please help

[monte96]

With an Access database you *MUST* know where it is.

You can't have a connection-less database. You can create connectionless recordsets that are not based on a database at all, but in order to use a database, you need a connection whether you create one explicitly or implicitly.

You need to contact your host provider and get the information or use the server.mappath method.