Click here to Skip to main content
16,005,491 members
Home / Discussions / ASP.NET
   

ASP.NET

 
QuestionPlace your current page path on Label Pin
Rajeshiam13-Jun-08 21:24
Rajeshiam13-Jun-08 21:24 
AnswerRe: Place your current page path on Label Pin
Christian Graus14-Jun-08 3:39
protectorChristian Graus14-Jun-08 3:39 
Questiondrop down list in asp.net 2.0 Pin
vijaylumar13-Jun-08 21:07
vijaylumar13-Jun-08 21:07 
AnswerRe: drop down list in asp.net 2.0 Pin
Anand Desai13-Jun-08 21:22
Anand Desai13-Jun-08 21:22 
QuestionHow a pdf file open in new window Pin
Masood Kochi,SSF13-Jun-08 20:43
Masood Kochi,SSF13-Jun-08 20:43 
AnswerRe: How a pdf file open in new window Pin
Anand Desai13-Jun-08 20:58
Anand Desai13-Jun-08 20:58 
Questionurl rewriting Pin
Pankaj Garg13-Jun-08 18:40
Pankaj Garg13-Jun-08 18:40 
QuestionProblem using FillSchema Pin
FerJones13-Jun-08 14:18
FerJones13-Jun-08 14:18 
Hi people,

my name is Fernando, and about 50 days ago i started with a problem, and couldnt solve it yet.

I have an asp.net application, in version framework 1.1 yet, used to manage content. Its published in a host company, and they use windows server 2003 32 bit, up to date.
In my company i do all windows updates, but i use win xp.

So, for almost 2 years it worked fine. I have 4 customer web sites in the same host, with this application replicated, and as i told, all of them worked properly until 23/04/08.

In this day, all of them stopped, and i started receiving an error: "Incorrect syntax near the keyword 'WHERE'"
Well, usually i would think that a SQL instruction has a problem. But not: They were not modified, and the database also don´t. But when i do a remote connection in the host database, but with pages, dll and framework from my machine, everything works fine. We moved the application from machines in the host company, many times, and nothing. Just in on that are not up to date, everything worked.

I started to check all possibilities, and using trace i could see the origin.

When the 'Application_start' event is fired, i read information of schemas of table, writing them in a XML file, used to have all the definitions in my hand. This is useful for many things, like automatic validation for example.
I read data by Fillschema method from DataAdapter to get the information, and here is the problem.

In the machines that DONT show any problem, the trace showed:
"SET FMTONLY ON SELECT * FROM FUNCAO_SISTEMA FUNCAO_SISTEMA ORDER BY COD_FUNCAO_STR SET FMTONLY OFF"

And in the machines where nothing works, the trace showed:
"SET FMTONLY ON SELECT * FROM FUNCAO_SISTEMA FUNCAO_SISTEMA ORDER BY COD_FUNCAO_STR WHERE 1=2 SET FMTONLY OFF"

This WHERE 1=2 is the problem.
I Think SQL is intending to process SET FMTONLY OFF as a condition from WHERE, and this is the problem.
Maybe something was changed in a framework lib from Microsoft, and update in 23/04/08.


WEll, first part is over.
Now, how can i send this to Microsoft for correction?
I really tried in their website, but i haven´t a contract of support, and there´s no place no send error information. So, i´m here, and don´t know what to do.

Do some of you have the same error? Can you try to make it, if you have win server 2003?
Do you agree with my point of view, about the WHERE 1 = 2?
Can somebody help me?

Thanks!

PS: I published this also in VB.Net area, but this asp.net area is the correct. It was a mistake, sorry.
AnswerRe: Problem using FillSchema Pin
Parwej Ahamad13-Jun-08 18:46
professionalParwej Ahamad13-Jun-08 18:46 
QuestionRe: Problem using FillSchema [modified] Pin
FerJones14-Jun-08 6:09
FerJones14-Jun-08 6:09 
Questionwhat is session () ?? Pin
ahemoudi13-Jun-08 11:07
ahemoudi13-Jun-08 11:07 
AnswerRe: what is session () ?? [modified] Pin
Christian Graus13-Jun-08 16:20
protectorChristian Graus13-Jun-08 16:20 
AnswerRe: what is session () ?? Pin
Masood Kochi,SSF13-Jun-08 19:27
Masood Kochi,SSF13-Jun-08 19:27 
GeneralRe: what is session () ?? Pin
ahemoudi15-Jun-08 7:11
ahemoudi15-Jun-08 7:11 
GeneralRe: what is session () ?? Pin
Masood Kochi,SSF15-Jun-08 19:03
Masood Kochi,SSF15-Jun-08 19:03 
QuestionSidebar Pin
Dan Neely13-Jun-08 5:42
Dan Neely13-Jun-08 5:42 
AnswerRe: Sidebar Pin
ToddHileHoffer13-Jun-08 5:49
ToddHileHoffer13-Jun-08 5:49 
GeneralRe: Sidebar Pin
Dan Neely13-Jun-08 7:05
Dan Neely13-Jun-08 7:05 
QuestionRe: Sidebar Pin
Dan Neely13-Jun-08 7:14
Dan Neely13-Jun-08 7:14 
GeneralRe: Sidebar Pin
Dan Neely13-Jun-08 8:41
Dan Neely13-Jun-08 8:41 
GeneralRe: Sidebar Pin
ToddHileHoffer13-Jun-08 8:58
ToddHileHoffer13-Jun-08 8:58 
GeneralRe: Sidebar Pin
Dan Neely13-Jun-08 9:06
Dan Neely13-Jun-08 9:06 
GeneralRe: Sidebar Pin
ToddHileHoffer13-Jun-08 9:08
ToddHileHoffer13-Jun-08 9:08 
AnswerRe: Sidebar Pin
Dan Neely13-Jun-08 9:13
Dan Neely13-Jun-08 9:13 
GeneralRe: Sidebar Pin
ToddHileHoffer13-Jun-08 9:16
ToddHileHoffer13-Jun-08 9:16 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.