dsn less syntax

[shank]

What's wrong with the syntax in this connection string?
It's a DSN less connection to an Access DB.
thanks!

<%
Set Conn = Server.CreateObject("ADODB.Connection")
MM_GenKAccess_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("authors.mdb") & ";" & _
Jet OLEDB:Database Password=48912; & _
Jet OLEDB:System database=" & Server.MapPath("system.mdw") & ";" & _
conn.open MM_GenKAccess_STRING
%>

[Aaron [SQL Server MVP]]

Well, you forgot to put some of your strings inside string delimiters, and
you had a trailing & _ that will likely cause problems. And stop letting
WISIWYG tools create stupid variable names for you! Try:

set conn = CreateObject("ADODB.Connection")

mdb = Server.MapPath("authors.mdb")
mdw = Server.MapPath("system.mdw")

connString = "Provider=Microsoft.Jet.OLEDB.4.0; " & _
"Data Source=" & mdb & ";" & _
"Jet OLEDB:Database Password=48912;" & _
"Jet OLEDB:System database=" & mdw

conn.open connString
--
http://www.aspfaq.com/
(Reverse address to reply.)


"shank" <sh***@tampabay.rr.com> wrote in message
news:uq**************@TK2MSFTNGP10.phx.gbl...

What's wrong with the syntax in this connection string?
It's a DSN less connection to an Access DB.
thanks!

<%
Set Conn = Server.CreateObject("ADODB.Connection")
MM_GenKAccess_STRING = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _ Server.MapPath("authors.mdb") & ";" & _
Jet OLEDB:Database Password=48912; & _
Jet OLEDB:System database=" & Server.MapPath("system.mdw") & ";" & _
conn.open MM_GenKAccess_STRING
%>