"Operation Cancelled" ?? Adodb error.

Everything was going fine, my scripts were all working in harmony with one another and smack I hit a brick wall.

I'm getting an "Operaction Cancelled" error when I try to execute an sql query.

The error is eactly this..

Microsoft OLE DB Provider for ODBC Drivers error '80040e4e'

Operation Canceled

/odyssey/register_register.asp, line 50


Line 50 is my rs.Open statement for the query...

sqlCheckUser = "SELECT * FROM Users WHERE Username ='"&Username&"'"
sqlCheckEmail = "SELECT * FROM Users WHERE Email = '" & Email & "'"

rs.Open sqlCheckUser, conn


I've rewritten all that a few times and printed to the screen and when I try to register I just get the error. I've never seen it before.

HELP! :D

Reserved word maybe ?!? Try wrapping the Username variable (or table Users) with [] brackets.

I know in SQL Server that User is a reserved word, have to use [User] instead. Just guessing here, I've never received that error... perhaps a google search might turn something up of use...

http://support.microsoft.com/default.aspx?scid=KB;en-us;q249350