...

View Full Version : "Operation Cancelled" ?? Adodb error.



Mhtml
02-16-2003, 08:22 AM
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

whammy
02-16-2003, 05:27 PM
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...

whammy
02-16-2003, 05:29 PM
http://support.microsoft.com/default.aspx?scid=KB;en-us;q249350



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum