error ASP, sql and crystal reprots

[JKingdom]

am using asp, sql server and crystal reports .. but am getting this error ..

Error Occurred Reading Records: The table '' could not be found.

 

[JKingdom]

it works with acces database(directly or dsn) boths working fine .. .. but not working with sql server ..

 

[DotNetGnat]

please show us some code snippet...

-DNG

 

[DotNetGnat]

may be the table doesnt exist on sql server...recreate the table and try again...

-DNG

 

[JKingdom]

its working fine when i use access database but not with sql .. although the report is working fine when i open it directly not through sql !!


session("oRpt").RecordSelectionFormula = CStr("{dept.dept_Id} =21")


On Error Resume Next

session("oRpt").ReadRecords

If Err.Number <> 0 Then
Response.Write "Error Occurred Reading Records: " & Err.Description
Set Session("oRpt") = nothing
Set Session("oApp") = nothing
Session.Abandon
Response.End
Else
If IsObject(session("oPageEngine")) Then
set session("oPageEngine") = nothing
End If
set session("oPageEngine") = session("oRpt").PageEngine
End If