Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
plz help!! Access into MS Access Database
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