Re: Connection String -- What am I doing wrong?

chang — Sun, 20 May 2007 09:20:33 GMT

Try escaping the backslashes like in:

J:\\Dudley\\Projects.mdb

Connection String -- What am I doing wrong?

drrocket0302 — Mon, 14 May 2007 17:27:29 GMT

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!!

SQL Database Integration

Re: Connection String -- What am I doing wrong?

Connection String -- What am I doing wrong?