H
Hemil
Hello Friends,
We have an access application which calls a report based
on a single parameter selected. Depending on the
parameter selected, we have different SQL's being passed
to the single report.
My access application is being able to connect to the
database correctly and all the reports are running fine.
But with one of the reports(parameter), I am facing the
error "3146: ODBC Call Failed". I have double checked
the DSN settings. I have also tried running the SQL
being passed to the report manually on the SQL Server
2000 backend and it runs fine.
Please help with any ideas that you might think of to
resolve the problem. Let me know if you need more
information.
Thanks & Regards,
Hemil.
We have an access application which calls a report based
on a single parameter selected. Depending on the
parameter selected, we have different SQL's being passed
to the single report.
My access application is being able to connect to the
database correctly and all the reports are running fine.
But with one of the reports(parameter), I am facing the
error "3146: ODBC Call Failed". I have double checked
the DSN settings. I have also tried running the SQL
being passed to the report manually on the SQL Server
2000 backend and it runs fine.
Please help with any ideas that you might think of to
resolve the problem. Let me know if you need more
information.
Thanks & Regards,
Hemil.