String data returned from ADO Recordset not being printed.

[bscox]

I developed a report in the RDC using ODBC connection to SQL Server invoking a stored procedure. I converted the database driver to ADO and used the SetDataSource method within my VB code to point to the recordset produced by invoking the stored procedure using ado command object. When the report is printed all fields returned in the recordset that have either datetime/numeric datatypes are printing OK but the fields that have a string datatype are not being printed.
Does anyone have any ideas !
Thanks

 

[melginger]

Did you "Verify the database" after your change? (database/ verify database or (within VB) right click / verify database). Sometimes that's put everything in the right place...