Dreamweaver connection no workie

[mother]

I have designed a deamweaver shopping cart locally on my server running XP Pro and Access XP and works fine connecting to my local database, however cannot connect to DSP'sDB at _\database\educoncert.mdb. When I try using remote server custom string.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath[\_database\educoncert.mdb]". Says it's to long

I tried a simple connection string and it connects but it stops working when I add a form element.

<%
Dim cnnSimple ' ADO connection
Dim rstSimple ' ADO recordset
Set cnnSimple = Server.CreateObject("ADODB.Connection")
' DSNLess
cnnSimple.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &amp; Server.MapPath("\_database\educoncert.mdb"))
Set rstSimple = cnnSimple.Execute("SELECT * FROM customers")
%>

I just want to use the files from my local work on there sever and help appreciatd.
is there a workaround or connection string for remote that I can use.

[wisemx]

Hi,
Shown below is a Dreamweaver and Access conn string I use for testing on a DASP IIS6 server:
[quote]

Dim MM_Conn2_STRING
MM_Conn2_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &amp; Server.MapPath("/_database/educoncert.mdb") &amp; ";"</CODE>



Technical Evangelist for DiscountASP.NET
http://www.iis7test.com/webcasts/
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

(Microsoft IT Usability http://msitusability.multiply.com/)

[mother]

Thanks have it working.