ASP/Javascript Help

[jdickson]

I receive the following error code on my web hosting client's page:
Microsoft JScript compilation error '800a03f7'

Unterminated string constant

/formationsWeb/Includes/JavaScriptOpenDB.asp, line 9

"Data Source=C:\Inetpub\vhosts\abwa.org\httpdocs\_DataStore\" + dbActive)
-------------------------------------------------------------------------^



Please help! Clueless on ASP/Javascript!

Login Page:
<%@ LANGUAGE = JavaScript%>
<%dbActive = "FormationsWeb.mdb"%>
<!--#include file="Includes/JavaScriptOpenDB.asp"-->

<%
var mySQL = "SELECT * FROM tblFormationContacts " +
"WHERE " +
"FirstName = '" + Request.Form("userName") + "'" +
"AND " +
"UserPassword = '" + Request.Form("userPassword") + "'";
var objRS = adoConnection.Execute(mySQL);

if (!(objRS.Bof == true && objRS.Eof == true))
{
Response.Cookies("ValidUser") = "Yes";
Response.Redirect("Info_Updates.asp");
}
else
{
Response.Cookies("ValidUser") = "No";
Response.Redirect("index.asp?attempt=Failure")
}

%>


Process Page:
<%
var dbActive
//dbActive = "FormationsWeb.mdb"

//Open database with JavaScript OLE-DB Connection method....
var adoConnection = Server.CreateObject("ADODB.Connection")
adoConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;" +
// "Data Source=f:\*\www.*.org\Board\_DataStore\" + dbActive)
"Data Source=C:\Inetpub\vhosts\*.org\httpdocs\_DataStore\" + dbActive)
%>

 

[anantshri]

I am not sure about the error but try one thing

put <!--#include file="Includes/JavaScriptOpenDB.asp"-->

as your second line and replace <%dbActive = "FormationsWeb.mdb"%> with
<% var dbActive = "FormationsWeb.mdb" %>

watch the space.


also removing the comments from the process page for the variable declaration can help you.