
May 3rd, 2000, 08:00 AM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
  
Time spent in forums: < 1 sec
Reputation Power: 24
|
|
|
Error '80004005' Not a valid password, Please help
<i><b>Originally posted by : D. Alpha (d_alpha@zdnetmail.com)</b></i><br />"Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Microsoft Access Driver] Not a valid password. <br /><br />/somefilename.asp, line x"<br /><br />This is the error I received when I try to perform a read-only query on a Ms-Access database. When I tested it in my intranet (NT 4.0), the connector "dataconn0" was working prefectly, but when I ftp them to my web server (NT 4.0) the error occurs.<br /><br />I have other ODBC connectors calling other database with different password/access type and they are working fine. Below is my Global.asa coding and the code I use to perform the query. Thanks in advance.<br /><br />[Global.asa]<br /><SCRIPT LANGUAGE=VBScript RUNAT=Server><br />Sub Session_OnStart<br /><br />Session("DataConn0_ConnectionString") ="DBQ=driveletter:databasename.mdb; DefaultDir=driveletter:;Driver={Microsoft Access Driver (*.mdb)}; DriverId=281; FIL=MS Access; FILEDSN=driveletter:dsnname.dsn; MaxBufferSize=2048; MaxScanRows=8; PageTimeout=5; SafeTransactions=0; Threads=3; UID=admin; UserCommitSync=Yes;"<br /><br /> Session("DataConn0_ConnectionTimeout") = 15<br /> Session("DataConn0_CommandTimeout") = 30<br /> Session("DataConn0_RuntimeUserName") = "admin"<br /> Session("DataConn0_RuntimePassword") = "password"<br /><br />xxxx other connectors xxxx<br /><br />End Sub<br /><br />[somefilename.asp]<br />response.buffer = true<br />Set DataConn0 = Server.CreateObject("ADODB.Connection")<br /><br />DataConn0.ConnectionTimeout = Session("DataConn0_ConnectionTimeout")<br /><br />DataConn0.CommandTimeout = Session("DataConn0_CommandTimeout")<br /><br />DataConn0.Open Session("DataConn0_ConnectionString"), Session("DataConn0_RuntimeUserName"), Session ("DataConn0_RuntimePassword")<br /><br />Set cmdTemp = Server.CreateObject("ADODB.Command")<br />Set rs = Server.CreateObject("ADODB.Recordset")<br />cmdtemp.CommandText = "somequery"<br />cmdTemp.CommandType = 1<br />Set cmdTemp.ActiveConnection = DataConn0<br /><br />rs.Open cmdTemp, , adOpenStatic, adLockReadOnly, adCmdText<br /><br />xxxx other coding xxxx<br /><br />rs.Close<br />Set rs = Nothing<br />dataconn0.Close<br />Set dataconn0 = Nothing<br />
|