I'm now trying to establish a connection into Access.
Here is my code first.
dim strUser, strPassword, strSQL
strUser = Request.form("txtUser")
strPassword = Request.form("txtPassword")
set objConn = Server.CreateObject("ADODB.Connection")
set objrsUsers = Server.CreateObject("ADODB.Recordset")
strSQL = "select * from tblUser where UID='" &strUser& "'" & " AND PWD='" &strPassword&"'"
objrsUsers.Open strSQL, objConn, adOpenForwardOnly, adLockReadOnly, adCmdText
and I got this error msg:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/abcomm/ConfirmLogin.asp, line 20
Basically what I'm trying to do is creat a login page of a website that using MS Access as database. I think connection is already established but somehow it says argument are wrong and I tried every argument like adOpenKeySet..or adLockPessimistic... but nothing's worked.
I tried both DSN-less and DSN way.
I'm using Win2000 pro NTFS formatted.
It worked before but it's not working anymore.
any suggesting plz?
thanks in advance