Hi all,

I have been wrestling with the support team at my ISP all weekend regarding DSN-less connections.

I cant make it work <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle> - and they dont give a fly)

Im using Dreamweaver MX - and I having problems when editing the connection string.

The asp files are located in a folder name HTDOCS

The database is located in a folder named Scripts.

HTdocs and Scripts are both located at the same server at same level.

When i ask the support team how to setup the connections do I only get following :

set conn = server.createobject("ADODB.connection"

conn.Open "DBQ=" & server.mappath("../scripts/data.mdb" & ";Driver={Microsoft Access Driver (*.mdb)}"

sql="select * from brugere"
set rs= conn.Execute(sql)

I even tried to type all of thise into the custom connection string field. - when hitting test i get failure.

Then did i try the exsample found in the similar topic - I have placed an asp file named mappath, and it gives me following :

Path to database:

d:\home\aspmydomaincon\htdocs\nameofyourdatabase.mdb

Anybody please help

Regards

Ivan

Yo,
try this one:

conn.Open "DBQ=" & server.mappath("\scripts\data.mdb" & ";Driver={Microsoft Access Driver (*.mdb)}"

sukses,

Masor, Netherlands

Thx

It worked <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Back on track...