topic ListDatasets problem with Geoprocessing Service in Python Questions https://community.esri.com/t5/python-questions/listdatasets-problem-with-geoprocessing-service/m-p/262222#M20147 <HTML><HEAD></HEAD><BODY><P>I create a Python Script as Show below to print the list of Datasets in arcpy.AddMessage() this script run successfully for (*.gdb, *.sde) but when publish this script as Geoprocessing Service it work successfully for (*.gdb) only and return empty list for (*.sde).</P><P>Note: The two workspaces I used as “E:\WSTest.gdb” and “E:\WSTest.sde” where SDE is for SQL Server Express 2008R2</P><P>WS_in is string for the path of Workspace</P><PRE class="lia-code-sample line-numbers language-none"> import arcpy WS_in = arcpy.GetParameterAsText(0) arcpy.env.workspace = WS_in arcpy.AddMessage(arcpy.env.workspace) lst = arcpy.ListDatasets() arcpy.AddMessage(lst) for i in lst: &nbsp;&nbsp;&nbsp; arcpy.AddMessage(i) </PRE><PRE class="lia-code-sample line-numbers language-none"> </PRE><PRE class="lia-code-sample line-numbers language-none"> </PRE></BODY></HTML> Sat, 11 Dec 2021 12:51:22 GMT Mohamed_MagdyMohamed_Hussain 2021-12-11T12:51:22Z ListDatasets problem with Geoprocessing Service https://community.esri.com/t5/python-questions/listdatasets-problem-with-geoprocessing-service/m-p/262222#M20147 <HTML><HEAD></HEAD><BODY><P>I create a Python Script as Show below to print the list of Datasets in arcpy.AddMessage() this script run successfully for (*.gdb, *.sde) but when publish this script as Geoprocessing Service it work successfully for (*.gdb) only and return empty list for (*.sde).</P><P>Note: The two workspaces I used as “E:\WSTest.gdb” and “E:\WSTest.sde” where SDE is for SQL Server Express 2008R2</P><P>WS_in is string for the path of Workspace</P><PRE class="lia-code-sample line-numbers language-none"> import arcpy WS_in = arcpy.GetParameterAsText(0) arcpy.env.workspace = WS_in arcpy.AddMessage(arcpy.env.workspace) lst = arcpy.ListDatasets() arcpy.AddMessage(lst) for i in lst: &nbsp;&nbsp;&nbsp; arcpy.AddMessage(i) </PRE><PRE class="lia-code-sample line-numbers language-none"> </PRE><PRE class="lia-code-sample line-numbers language-none"> </PRE></BODY></HTML> Sat, 11 Dec 2021 12:51:22 GMT https://community.esri.com/t5/python-questions/listdatasets-problem-with-geoprocessing-service/m-p/262222#M20147 Mohamed_MagdyMohamed_Hussain 2021-12-11T12:51:22Z Re: ListDatasets problem with Geoprocessing Service https://community.esri.com/t5/python-questions/listdatasets-problem-with-geoprocessing-service/m-p/262223#M20148 <HTML><HEAD></HEAD><BODY><P>you might need to register the database connection on the server.</P><P>Here's a link in case you are unfamiliar with this setup.</P><P><A href="http://resources.arcgis.com/en/help/main/10.2/#/Registering_your_data_with_ArcGIS_Server_using_Manager/01540000056s000000/" title="http://resources.arcgis.com/en/help/main/10.2/#/Registering_your_data_with_ArcGIS_Server_using_Manager/01540000056s000000/">ArcGIS Help (10.2, 10.2.1, and 10.2.2)</A> </P></BODY></HTML> Mon, 03 Nov 2014 13:51:06 GMT https://community.esri.com/t5/python-questions/listdatasets-problem-with-geoprocessing-service/m-p/262223#M20148 DallasShearer 2014-11-03T13:51:06Z Re: ListDatasets problem with Geoprocessing Service https://community.esri.com/t5/python-questions/listdatasets-problem-with-geoprocessing-service/m-p/262224#M20149 <HTML><HEAD></HEAD><BODY><P>Thank you it work</P></BODY></HTML> Thu, 06 Nov 2014 13:33:58 GMT https://community.esri.com/t5/python-questions/listdatasets-problem-with-geoprocessing-service/m-p/262224#M20149 Mohamed_MagdyMohamed_Hussain 2014-11-06T13:33:58Z