2. ASPRunnerPro General questions
  3. Microsoft VBScript compilation (0x800A0401)
This topic is locked

Microsoft VBScript compilation (0x800A0401)

 		6/2/2008 12:41:53 AM
ASPRunnerPro General questions
A
 agmoraojr author

hello,
I changed the path of my dbconnection and follow the updateable query error solution found on your website, and gives FULL permissions(Everyone) to the folder that contains the mdb, sad to say this is the error I got.
Error:

Error Type:

Microsoft VBScript compilation (0x800A0401)

Expected end of statement

/record/include/dbconnection.asp, line 2, column 36

strConnection = "DBQ=H:\db\Employee.mdb";Driver={Microsoft Access Driver (.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=;PWD=jong"
================================================

My declared dbconnection.asp

<%

strConnection = "DBQ=H:\db\Employee.mdb";Driver={Microsoft Access Driver (.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=;PWD=jong"

%>
Sergey Kornilov admin 6/3/2008

Remove a double quote character after Employee.mdb.

<%

strConnection = "DBQ=H:\db\Employee.mdb;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=;PWD=jong"

%>
A
 		agmoraojr author 6/3/2008

a bunch of thanks admin... it's now workin'

Remove a double quote character after Employee.mdb.


<%

strConnection = "DBQ=H:\db\Employee.mdb;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=;PWD=jong"

%>