I'm trying to learn jscript so that I can program my infopath forms and I'm having a hard time connecting to my database. My database is stored on a shared drive. Does it have to be on my local machine? Heres my code:
function CTRL30_32::OnClick(eventObj)
{
var pobjConnection = new ActiveXObject("ADODB.Connection");
pobjConnection.Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=J:\Dudley\Projects.mdb;User Id=admin;Password=;")
var pstrSQL = "SELECT * FROM Projects";
var pobjRS = pobjConnection.Execute(pstrSQL);
}
I know this doesn't do anything yet but every time I try to run it I get an error that it cannot find the file "J:\DudleyProjects.mdb" It refuses to recognize the second slash mark in my data source. Can someone please tell me what I'm doing wrong and/or how to fix it? Thanks!!