Incorrect syntax near 'nvarchar

an unhandled exception [sqlException (0x80131904): Incorrect syntax near ?nvarchar?.]
After selecting through the files I find I have no ?nvarcher?.
I redo the table for First Name Last Name Email Address and Comments, Redo the web page,and Redo the FormView. I have tried these and even moved from XP to Vista and EW to WE2.
The page will not submit without the (0x80131904) response. I dont think now it is something in my page. Can you help?

Regards, column2

 

Hi,
There are several things that can cause this error, most are from the code page.
Look for things like spaces in your table object names, if you do have space trap them better or rename them with an underscore.
Other things that cause this are placing the tickmark in All when you create the SQLdatasource, it should be done with each field instead.
My guess is the problem will be found in the actual query.
Salute,
Mark


Technical Evangelist for DiscountASP.NET
http://www.iis7test.com/webcasts/
http://weblogs.asp.net/markwisecarver/
http://blogs.windowsclient.net/wisecarver/default.aspx

(Microsoft IT Usability http://msitusability.multiply.com/)