Parametrised V B data reports using ODBC connection 1

[Hotguy]

i am having problems to create reports in visual basic 6 when i try to pass parameters to get data from databases connected through ODBC
Can anyone help me please?
thanks

 

[tlbroadbent]

It is much easier to help if we have more info.

What are the ODBC databases?
What problems occur?
Does the query error? What is the error?
Does it return incorrect or no data?
Can you post the connection string, query, error message, ...?

Thanks, Terry
------------------------------------
People who don't take risks generally make about two big mistakes a year. People who do take risks generally make about two big mistakes a year. -Peter Drucker

 

[Hotguy]

Actually the sql builder does not accept parameters. If the same report is created using connection string, the parameter is accepted by the sql builder, but in case i try it with the database being on the server, even though i put the parameter in the sql buider, it does not recognise the parameter. Can anyone tell how i can overcome this problem?