VBScript - End of statement error.

VegaLA · Joined: 04 Jan 2008 Posts: 6

Hi all,
I have set up my new site and hosted it on GoDaddy since it allows me to use an Access.mdb as a source for my VBScript ASP pages. I have created ASP pages with a SQL source in the past from a internal webserver but never Access in a Host companys site before. I am using Dreamweaver MX 2004 to create my ASP and at home, on the local pc my ASP page displays perfectly from the web browser however not so from the site itself. I have managed to resolve various different errors that have directed me to my connection coe but this last one has me stumped. The error is as follows: Microsoft VBScript compilation error '800a0401' Expected end of statement

And my code is below:

<%
' FileName="Connection_ado_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_access_MyDB_STRING
MM_access_MyDB_STRING = "Driver={Microsoft Access Driver(*.mdb)};DBQ=Server.MapPath("MyDB.mdb")"
%>

Can anyone assist with this problem ?

Thanks in advance,
Mitch.......

camoman666 · Posted: Tue Jan 15, 2008 12:51 pm

You have quotes inside other quotes, change the last line to: