I have a python code that uses ArcPy command "arcpy.TableToTable_conversion" to convert a database table to a dbf file.
The input table is from a SQL Server database through an odc Database Connection in ArcCatalog.
When run straight from ArcCatalog, the code worked perfectly. However, after it was published as a Geoprocessing service on ArcGIS Server 10, it failed to run.
Error Error Executing Task. Error executing tool.: : Failed to execute. Parameters are not valid. ERROR 000732: Input Rows: Dataset "Database Connections\myDb_DEV.odc\dbo.V_Locations" does not exist or is not supported Failed to execute (TableToTable). Failed to execute (ExportToBOMAWS). Code: 500
Could anybody help with any idea why and how to make it work as geoprocessing service?