Failed getting Rowset(s) from Current Data Source

I'm getting this error when accessing an SQL Server database for a data report: Failed getting Rowset(s) from current data source. I'm passing a variable to the sql command like this: deInventory.Purchases CInt (txtPurchasor.text)
Then displaying the report. My sql statement is SELECT * FROM AccountLog WHERE Purchaser = ?. ie The purchaser who is logged in can get a report displaying all his purchases to date.

Thanks,

casox

Hi, there.

Check this site, there is a sample code:

http://support.microsoft.com/support...&SA=ALLKB&FR=0

Larisa

hi guys i have a problem with my datareport in vb6.0 m using sql server 2008 .. i created a data environment and added the command with the following sql query

"SELECT * FROM Tax_Form WHERE RegNo = ?"

in the form i have a command button and text box

the code for my command button is


" With DataEnvironment1
If .rsCommand1.State = adStateOpen Then
.rsCommand1.Close
End If
.Command1 Text1.Text
If .rsCommand1.RecordCount > 0 Then
MsgBox "Found " & .rsCommand1.Fields("RegNo").Value
Else
MsgBox "No Record found"
End If
End With
Set DataReport1.DataSource = DataEnvironment1
DataReport1.Show "

i get the error wen i run the program and give the input
it shows "failed getting rowset(s) from current data source"

plz help me how to display my specific data in the datareport