ASP connect SQL Server 7 problem

A

autopost

Guest
I have this error mesg at line "rs.Open sql, conn, 3, 3" saying:
Error Type:
(0x80040E4D)


conn="Provider=SQLOLEDB.1;UID=;Password=;Initial Catalog=eleave;Data Source=mypcdomain"

strUserID = Request.Form("userid")
strPassword = Request.Form("password")
chkSaveLogin = Request("chkSave")

sql = "SELECT * FROM employee "
sql = sql & " WHERE login_UserID = '" & strUserID & "' AND login_Pwd = '" & strPassword & "' "
rs.Open sql, conn, 3, 3


How do I fix this? Thanks.<!-- m --><a class="postlink" href="http://support.microsoft.com/kb/q307002/">http://support.microsoft.com/kb/q307002/</a><!-- m -->

seems to be the answer....ok, thanks.
 
You must log in or register to reply here.
Back
Top