driver does not support the requested properties. (error message)

[FlatHead]

ID = Request.QueryString ("ID&quot
oRecord1.Open "Exec sp_peo_UserSkills " & id,oConnect,1
Response.Write &quot;<table border=1><tr>&quot;
Response.Write &quot;<th align=center>Skill Name</th>&quot;
Response.Write &quot;<th align=center>Skill Grade</th>&quot;
Response.Write &quot;</tr>&quot;
do until........
Response.Write &quot;<td><p align=center>&quot; & oRecord1(&quot;SkillsName&quot & &quot;</td>&quot;
Response.Write &quot;<td><p align=center>&quot; & oRecord1(&quot;SkillsGrade&quot & &quot;</td>&quot;

------This bit is working perfect and return a a table with some records which is a simple 2*2 table in the example.-------------------------------------------------------

-----------------But on the next one???????????Please help me ----------------------------

CourseID = Request.QueryString (&quot;CourseID&quot
oRecord1.Open &quot;Exec sp_peo_Courses&quot; & id,oConnect,1

Response.Write &quot;<table border=1><tr>&quot;
Response.Write &quot;<th align=center>Course Name</th>&quot;
Response.Write &quot;<th align=center>Course Grade</th>&quot;
Response.Write &quot;</tr>&quot;
do until ....................(eof....).
Response.Write &quot;<td><p align=center>&quot; & oRecord1(&quot;CourseID&quot & &quot;</td>&quot;
Response.Write &quot;<td><p align=center>&quot; & oRecord1(&quot;CourseName&quot & &quot;</td>&quot;
Response.Write &quot;</tr>&quot;

---------------------The seccond bit is not working but both the 2 excamples are excactly the same and they excecuting the same commands and linked to 2 different tables with the same number of fields on every record.

The excpected result is again a 2*2 table on the screen but unfortunally Im taking the following error messageMicrosoft OLE DB Provider for ODBC Drivers error '80040e21'
ODBC driver does not support the requested properties.
/tpeople/viewuser.asp, line 270)
Please help me [sig][/sig]

 

[palbano]

Dear FlatHead,

I see two things that I question. Your code follows

// the one that works
>ID = Request.QueryString (&quot;ID&quot
> oRecord1.Open &quot;Exec sp_peo_UserSkills &quot; & id,oConnect,1

// the one that doesn't work
>CourseID = Request.QueryString (&quot;CourseID&quot
> oRecord1.Open &quot;Exec sp_peo_Courses&quot; & id,oConnect,1

First, in the second piece of code there is no space after the stored procedure name therefore if id were equal to '11' your string concatination would result in:

&quot;Exec sp_peo_Courses11&quot;

Second in the second piece of code you store a request variable named &quot;CourseID&quot; in a local variable named &quot;CourseID&quot;, but then in the next line of code you use the variable &quot;id&quot; which was used in the first piece of code.

Hope this helps
-pete
[sig][/sig]