Invalid character on dsn-less connection to Access

karizmatic · #1 (**permalink**) 04-26-04, 17:23

I have set up a connection to a database on a sharepoint that looks exactly like this (I've removed the path for brevity):

Code:

<%
Set connPSC = Server.CreateObject("ADODB.Connection")
connPSC.Open (Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("\\path"))
%>

I also created a page that tests this connection (simple query that returns ONE record). When I try to run the test page, I get the following error:

Code:

Microsoft VBScript compilation error '800a0408' 

Invalid character 

/isreports/sc/connPSC.inc, line 5 

connPSC.Open (Driver={Microsoft Access Driver (*.mdb)};DBQ=" &_
---------------------^

I actually copied this from one of the hundreds of examples out there for connecting dsn-less to an Access database... I'm not sure why my brackets are being interpreted as invalid. I also tried it without the brackets, but then it expects the close parenthesis right after the string "Microsoft"... any ideas?

rokslide · #2 (**permalink**) 04-26-04, 22:55

try this....

connPSC.Open ("Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("\\path"))

Note the first set of quotes

Bullschmidt · #3 (**permalink**) 04-27-04, 18:49

Here's a good connections resource, and it's advised that you use Jet instead of Microsoft Access for the DSN-less connection to an Access database:

Able Consulting - ADO Connection String Samples
http://www.able-consulting.com/ADO_Conn.htm

Internet Services

Web Development

Digital Marketing

Consumer Tech