MS Access DSNLess Connection

[zzfive03]

Hello, this thing is turning out to be a huge pain.
I usualy use SQL server, so Access is new to me. I need to connect to my MS Access server across a DSNLess connection via ASP.

Here is what I have:
Dim DB, RS, DSNString
Set DB = Server.CreateObject("adodb.connection&quot
Set RS = Server.CreateObject("adodb.recordset&quot
DSNString="DRIVER={Microsoft Access Driver (*.mdb)};" & "DBQ=" & server.mappath("MyDatabase.mdb&quot
DB.Open DSNString

It works if I comment out the last line. then, how do i Run my SQL = "select * from {table}"?

Thanks for your help

 

[hojoho]

try it this way.

DSNString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & server.mappath("myDatabase.mdb&quot

DB.Open DSNString
RS.open SQL, DB

Work for me maybe it will work for you.

 

[codestorm]

Remove the curly brackets {} from around the driver.
codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>