strSQL Error

I'm working on my new site and I have the following problem:

• i have the Access file, that contains the tables, tblClassment and tblPoints, etc.
  
• now in Access i can relate the 2 tables with a very simple Query, and I can go in the SQL view and copy the following SQL Code:
  
  SELECT tblClassment.Pilot_ID, Sum(tblPoints.Points) AS SommaDiPoints
  FROM tblPoints RIGHT JOIN tblClassment ON tblPoints.Position = tblClassment.Position_Pilot
  GROUP BY tblClassment.Pilot_ID;
  
• in Access this query works very good but when i copy the code in ASP and I edit it, it didn't work and the ASP site give me an "Unspecified error". The ASP Code is the following:
  
  <%
      Dim rsClassment
      Set rsClassment = Server.CreateObject("ADODB.Recordset")
      strSQL = "SELECT DISTINCT tblClassment.Pilot_ID, Sum(tblPoints.Points) AS SommaDiPoints"
      strSQL = strSQL & " FROM tblPoints RIGHT JOIN tblClassment ON tblPoints.Position = tblClassment.Position_Pilot"
      strSQL = strSQL & "GROUP BY tblClassment.Pilot_ID;"
      rsClassment.Open strSQL, adoCon
       %>
  

Can anyone help my to solve this problem. Where is the error??

Thank's to all.

No, thats not the problem .

Thanks