"Too few parameters"??

[adamsoderqvist]

I keep getting the same err msg when I connect to an access DB;

"Microsoft OLE DB Provider for ODBC Drivers error '80040e10'

[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1."

And the code is;

---begin code---

Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection&quot
objConn.ConnectionString = "DRIVER={Microsoft Access Driver
(*.mdb)}; " & "DBQ=" & Request.ServerVariables("APPL_PHYSICAL_PATH&quot & "ptrl\Members.mdb"
objConn.Open

'Declare recordset object...
Dim objRS
Set objRS = Server.CreateObject("ADODB.Recordset&quot

'Declare SQL query...
Dim strSQL
strSQL = "SELECT UserName, Password, LastLogin, UserLevel FROM tblMember WHERE UserName='" & strUserName & "'"

'Open the database and get the requested info!
objRS.Open strSQL, objConn

---end code---

What's wrong?? What bugs is that this code is the EXACT same as I've used in another project, and it worked perfectly.
I've also tried: "objConn.Execute strSQL", with the same result

Pls hlp!!

 

[jracine]

this error happens when you try to select from an Access
database using a column name that doesnt exist, check your select statement again. If you have not misspelled anything you may be using reserved words in the select statement, you cang et around this by renaming your columns in the dbase or putting brackets ([]) around the column names in the select statement.

good luck
Jeremy

 

[moxie249]

I think the problem is with your field called UserName. I'd rename that one first.

Good luck!

Brenda

 

[lobstah]

Password is a reserved word.

Could also be an error if your variable strUserName is empty.

add

response.write strSQL

before

objRS.Open strSQL, objConn

to see what is actually passed into your sql statement.