Help!
I am using VB 6 Data Environment and Report Designer to generate some reports for my application. I created a Data Environment Command using SQL statement with a parameter for String. The Data Type is adVarChar and Host Data Type is STRING.
However, I keep getting the error msg "application defined or object defined error" when I run the query in my form. If I defined Data Type as adInteger and Host Data Type as INTEGER, and pass it an integer variable, it is working fine.

What's the correct way to pass a string to a Data Environment Command? Can someone enlighten me?

Thanks