Looks like you're trying to execute a table name as a stored procedure:
i.e. something like
Set ocmd = Server.CreateObject("AODB.Command")
ocmd.commandtext = "table_name"
ocmd.commandtype = adcmdstoredproc
This will fail with an error similar to the one you're reporting.
As Joe wrote above - it's difficult to diagnose without a code snippet or at least the SQL you're trying to execute.
The future is a foreign country, they do things differently there.
(Stolen from Arthur C Clarke)