Please do not use those connection strings. Only use:
Set db = Server.CreateObject("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" &
Server.MapPath("database.mdb") & ";"
The DBQ approach results in many random errors see:
http://www.learnasp.com/learn/dbopen.asp
for a more detailed explanation.
The DSN approach results in slow as molasses connection and errors as well.
On Mon, 14 Mar 2005 21:19:57 -0800, Ryan Olshan <[EMAIL PROTECTED]> wrote:
> Connect to the Database
>
> Microsoft Access 2000 Database (OLE-DB):
>
> Microsoft Access 2000 Database:
>
> Set db = Server.CreateObject("ADODB.Connection")
> db.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
> Server.MapPath("database.mdb") & ";UID=;PWD="
>
> Connecting to a database using a DSN:
>
> Set db = Server.CreateObject("ADODB.Connection")
> db.Open "DSN=mydsn;UID=username;PWD=password"
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
