DSN-less connection help

[SpyderWeb]

I need the database connection to DSN-less, can I replace
'AAA with 'BBB and have it work correctly or is 'BBB incorrect coding - I am not familiar with this layout for referencing a database.

'AAA
'Replace with your database connection information
with cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = "c:\inetpub\wwwroot\email.mdb"
.Open
end with

'BBB
'Replace with your database connection information
with cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString = Data Source=" & Server.MapPath("\myfolder\mydatabase.mdb")
.Open
end with

[Easy_Coder]

set cnn = server.createobject("ADODB.Connection")
cnn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\anydatabase.mdb"

[SpyderWeb]

No error now with the minor corrections below:

'Replace with your database connection information
with cn
.Provider = "Microsoft.Jet.OLEDB.4.0"
.ConnectionString =Server.MapPath("\myfolder\mydatabase.mdb")
.Open
end with

[TheDave]

Your first one would've worked, you were just missing a quote between the first = and Data, ie:

.ConnectionString = "Data Source=" & Server.MapPath("\myfolder\mydatabase.mdb")

[webdevsf]

Btw, server.mappath is relatively slow. you might want to put that connection string in the application object after you've constructed it, and then just use it from there.

[SpyderWeb]

>Btw, server.mappath is relatively slow. you might >want to put that connection string in the >application object after you've constructed it, and >then just use it from there.

...after you've constructed it? Can I view physical path this why and hard code it for greater speed?

ConnectionString =Server.MapPath("\myfolder\mydatabase.mdb")

Response.write ConnectionString