Latest Contributions by SusanJones

Hi This sounds like a drive issue -- perhaps sqlserver v11 instead of sqlserver v10 What database does the ArcSDE application hang off? Susan ... View more

There are some issues with the SQL Server client tools around ddl access to objects. Despite the user rights and permissions being in place, some access to tables and views was restricted. This was solved by applying the cumulative update of the client tools. ... View more

Hi Mike We had an almost identical issue with SSMS 2008 R2 accessing some objects and not others. There is a patch out for SSMS 2008 R2 which should be applied which fixed the issue for the developers. Susan ... View more

Hi Mike What version of the SQL Server Native Client is installed - 10.0 or 11.0? Susan ... View more

Totally agree - storage format is part of it. For tis particular task I have been using File Geodatbase ... View more

Hi I had exactly this last week with using the arcpy.da.InsertCursor and arcpy.da.SearchCursor. Seems that can only use one cursor at a time. In the end I pulled all my search records into an array and used them as part of my insert/update records. Took a bit of getting my head around, but got there in the end. Here is my logic: #todo: process Layer print "\nProcess CAFS Layer" #todo: search Data recs = arcpy.da.SearchCursor(in_table = "EMU_VIEW", field_names = ["VehicleId", "Timestamp", "Longitude", "Latitude"]) rows = [] for rec in recs:     pt = [rec[2], rec[3]]     row = [pt, rec[1], rec[0], "CAFS", rec[1], rec[2], rec[3]]     rows.append(row) del recs #todo: insert Data print "insert Data" fldList = ["SHAPE@XY", "DateTime", "VehicleID", "FeedType", "Timestamp", "Longitude", "Latitude"] irecs = arcpy.da.InsertCursor(in_table = fc, field_names = fldList) for row in rows:     irecs.insertRow(row) del irecs Susan ... View more

Hi Salman First, What is the value of outputDataset? Second, Output_Coordinate_System is expecting either a projection file (with a prj extension) or a coordinate system object. Not a shp extension. Make sure the Shapefile has a projection, and then set the targetProjection to point to it's prj file. Susan ... View more

Hi Salman Please test the following: tmpDir = "D:\\Tmp" ##tmpDir = r"d:\Tmp" arcpy.env.workspace = tmpDir print arcpy.env.workspace ld = arcpy.ListDatasets("*") print ld What is returned in the ld variable ? Susan ... View more

Hi again Also, I don't think arcpy.ListDataset() is expecting a workspace. Perhaps, spectify the workspace before hand under the arcpy.env.workspace parameter. Susan ... View more

Hi Salman The arcpy.ListDataset() is calling for a wildcard. Not sure if it is optional, but it wouldn't hurt to specifiy the wildcard ("*") See if it works Susan ... View more

Hi Kevin 255 text length is a default when features have been imported from non ArcGIS Formats like excel. It's possible there are trailing spaces which is not being matched to the feature class. Perhaps try trimming the field on both sides Problem sounds like it is on the Table side. Susan ... View more

HiSalman First, Try setting your workspace  before using the arcpy.ListDatasets() eg, arcpy.env.workspace = sourceWorkspace Second, use the correct  arcpy.ListDatasets() arguements (wild card naming and feature type eg, listDataSet = arcpy.ListDatasets(wild_card = "*", feature_type = "Feature") Susan ... View more

Does the ARcGIS Service Account have permissions to the MySQL Database? Which user are you using to create the ODBC Connections? ... View more