Hi<BR><BR>I am trying to use SQL Server 7 with ASP<BR>when I retrieved data from SQL<BR>and assigned it to a vairable I end<BR>up with this error :<BR><BR><BR>Error Type:<BR>(0x80020009)<BR>Exception occurred.<BR><BR><BR>the line that caused this probelm is :<BR><BR>lastone = rs("my_data_id")<BR><BR>anything else works fine , any suggestions ?<BR><BR>BTW<BR><BR>the same code worked with I Used access insted of SQL Server<BR><BR>