I read this as ""your SQL Server reported the error 'optional feature not
implemented'"" - is that right?
We'll need some more details to help you diagnose - what was the SQL
statement that triggered the problem? Against what version of SQL
Server? Are you calling a stored procedure? What code is in there? Have
you looked in the SQL server logs? etc etc

coming to my sql server its version is 2000.and i haven't used any stored procedure in my code.i don't have any idea of SQL server logs.

-----Original Message-----
I read this as ""your SQL Server reported the error 'optional feature not
implemented'"" - is that right?
We'll need some more details to help you diagnose - what was the SQL
statement that triggered the problem? Against what version of SQL
Server? Are you calling a stored procedure? What code is in there? Have
you looked in the SQL server logs? etc etc
Tim Clarke

(Sorry its taken a while to answer)
Since I can't follow the trail of which ""feature"" might be missing, I'll have to simply work on what I can see which is a missing space before the ""ORDER"" clause of your statement above? I hope that helps at least a little.
Regards
Tim Clarke
-----Original Message-----
Hi,
i am using JSP's for coding and my code is
Calendar tmpCal=null;
java.sql.Date myTmpDate = null;
for(i=0;i<7;i++)
{tmpCal = new GregorianCalendar(startDate.get(startDate.YEAR),
startDate.get(startDate.MONTH),(startDate.get(start Date.DAY_OF_MONTH)+i));
tmpDate = tmpCal.getTime();
myTmpDate = new java.sql.Date(tmpDate.getTime());
pst = con.prepareStatement(""SELECT ttc.PeriodNo, ttc.CSid, cm.CSName, ttc.SubCSId, ""+
""sm.SubjectShort, sm.SubjectName, ttc.BatchId, btm.BatchName, ttc.ClassRoom, ""+
""ttc.DateChange, ttc.AcaYearId FROM ((SubjectMaster AS sm INNER JOIN ""+
""(TimeTableChanges AS ttc INNER JOIN SubjectCSMaster AS scm ON ttc.SubCSId = ""+
""scm.SubCSid) ON sm.SubjectId = scm.SubjectId) INNER JOIN CSMaster AS cm ON ""+
""scm.CSid = cm.CSid) LEFT JOIN CSBatchMaster AS btm ON ttc.BatchId = btm.BatchId ""+
""WHERE (((ttc.TeacherId)='""+userId+""') AND ((ttc.DateChange)=?) AND ""+
""((ttc.AcaYearId=""+acaYear+"") OR (ttc.AcaYearId=""+acaYear1+"")))ORDER BY ttc.PeriodNo "");
//***** FROM HERE I AM GETTING THE ERROR AND I AM UNABLE TO EXECUTE THE CODE FROM HERE
pst.setDate(1,myTmpDate);
rs = pst.executeQuery();
coming to my sql server its version is 2000.and i haven't used any stored procedure in my code.i don't have any idea of SQL server logs.