Error when trying to run reports on 1 PC through Switchboard & ODBC

[Hillary]

We have 1 PC in our company that we are having problems accessing reports in the database. The error is similar to, "Can not excute command". (I don't have the exact error but I can get it if anyone thinks they need it) The data is accessed from a switchboard via the Oracle ODBC driver. There is a form based off the same query the report is based off of and the form opens fine, just not any reports.

It doesn't matter who signs into the database. We even ran the database on the administrator profile and got the same result. Access was re-installed and taken from 2000 SR-1 to 2000 SP-3. Other PC's are at SR-1 and the database works fine.

Does anyone know what the problem could be???

Windows 2000
Access 2000
Oracle ODBC Driver

Thanks,

Hillary

 

[tracy1234]

Hillary - The only thing I can think of is to check the tnsnames.ora file on that PC to see if the Oracle instance name matches up with what you are using on the ODBC connection.

But I have some doubts about this since you report that this PC is able to run the query that populates the report.

-Tracy