Declarar conexion con password en la base de datos

[maestro]

¿Como configuro el password en una base de datos ACCESS al declarar la conexion?.

oConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("fpdb\audio.mdb")

Donde va el password??

Jose Maria Fernandez
<a href="mailto:[email protected]">Webmaster @expansionweb.net</a>
<a target="_blank" href="Http://www.expansionweb.net">Http://www.expansionweb.net</a>

[Zurfo]

solo agregale ,,elpassword algo asi:

Base.Open &quot;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=&quot; &amp; Server.MapPath(&quot;111.mdb&quot;),,password

[vlah]

Podria ser asi..


con DNS Usando nombre de usuario/password
&lt;%
set conn = Server.CreateObject(&quot;ADODB.Connection&quot;)
conn.open &quot;DSNname&quot;,&quot;username&quot;,&quot;pas sword&quot;
%&gt;

De hecho existen pequeñas variaciones, dependiendo POR (ODBC,ORACLE,MYSQL)

[maestro]

He probado todas estas variantes y no me funciona.

oConn.Open &quot;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=&quot; &amp; Server.MapPath(&quot;fpdb\audio.mdb&quot;),,passwo rd

oConn.Open &quot;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=&quot; &amp; Server.MapPath(&quot;fpdb\audio.mdb&quot;),passwor d

oConn.Open &quot;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=&quot; &amp; Server.MapPath(&quot;fpdb\audio.mdb&quot;),&quot;p assword&quot;

oConn.Open &quot;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=&quot; &amp; Server.MapPath(&quot;fpdb\audio.mdb&quot;),,&quot; password&quot;

Este el error que obtengo

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
default.asp, line 181


Jose Maria Fernandez
<a href="mailto:[email protected]">Webmaster @expansionweb.net</a>
<a target="_blank" href="Http://www.expansionweb.net">Http://www.expansionweb.net</a>

[juanangt]

Prueba esto:

oConn.Open &quot;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=&quot; &amp; Server.MapPath(&quot;fpdb\audio.mdb&quot;) &amp; &quot;; Password=LaContrasenya &quot;

Ya me dirás