Failed getting Rowset(s) from Current Data Source

[casox]

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

[LG]

Hi, there.

Check this site, there is a sample code:

http://support.microsoft.com/support/kb/articles/Q244/7/79.ASP?LNG=ENG&SA=ALLKB&FR=0

Larisa