Latest Contributions by DarinaTchountcheva

I created a little test app, which creates programmatically some radion buttons and buttons, loads a tiled map + feature layer, and shows a legend. Nothing fancy. All works fine in Chrome and Firefox. In IE8 if the Browser History settings are set to "Automatically" to Check for newer versions of the stored pages, the pages load correctly only if I clear the cache. And they do not load correctly after that if I click the refresh browser button or Ctrl+F5. When I debug using the Developer Tools, on a refresh the modules don't load, and the function creating the buttons and the map don't execute. If I change the Browser History settings to "Every time I visit the webpage", it works fine, and if I refresh the pages they load correctly. Attached is my little test project. Hope, someone will have some time to let me know what I am doing wrong. Just learning the AMD loader now, so I might be messing up something. If you have had the same problem and have found a solution, please, advice! Thank  you! ... View more

Hello everybody, Here is what I want to do:    - select data from a SQL Server database, which is not SDE using pyodbc    - insert the records returned by the select into a table in a geodatabase I am getting the following error: *********************************************** Traceback (most recent call last):   File "E:\Workspace\Warehouse\PythonScripts\PerformSpatialJoins.py", line 80, in <module>     arcpyRow.YCoord = row.YCoord   File "C:\Program Files\ArcGIS\Desktop10.0\arcpy\arcpy\arcobjects\_base.py", line 35, in __setattr__     return setattr(self._arc_object, attr, ao) ValueError: Row: Invalid input value for setting *********************************************** I understand that it doesn't like the value of the XCoord, but I don't understand why it doesn't like it. The data type of the XCoord in the SQL Server table is "numeric", and the data type of the XCoord in the geodatabase table is "double". I also tried float and long integer (the coordinates are integer values even if they are in a numeric field). I always get this error. If I don't insert the XCoord and YCoord attributes, the script works as expected. Any idea is greatly appreciated! Below is the python script: # Import arcpy module import arcpy import pyodbc import os  # Set Geoprocessing environments arcpy.env.overwriteOutput = True  DatabaseConnectionString = "Driver={SQL Server Native Client 10.0};SERVER=myserver;DATABASE=mydatabase;Trusted_Connection=yes" LocationsForGISProcessing = "dbo.vw_myview"  ScratchGeodatabasePath = "E:\\Workspace\\Warehouse\\ScratchWorkspace\\Scratch.gdb" TempLocationsForGISProcessing = "LocationsForGISProcessing"   ##################################################################################### # Create ODBC connection    conn = pyodbc.connect(DatabaseConnectionString) cursor = conn.cursor()  print "Connected to database"  ################################################################################## # Insert the data into the geodatabase  TempTable = ScratchGeodatabasePath + "\\" + TempLocationsForGISProcessing      # Process: Delete Rows From Previous Load arcpy.DeleteRows_management(TempTable)  arcpyCursor = arcpy.InsertCursor(TempTable)  cursor.execute("SELECT * FROM " + LocationsForGISProcessing) rows = cursor.fetchall() for row in rows:     arcpyRow = arcpyCursor.newRow()         arcpyRow.Location_Key = row.Location_Key         arcpyRow.From_Date = row.From_Date     arcpyRow.XCoord = row.XCoord     arcpyRow.YCoord = row.YCoord     arcpyCursor.insertRow(arcpyRow)    # Delete the arcypy cursor del arcpyCursor   # Close the connection if (cursor is not None):     cursor.close()     del cursor     if (conn is not None):        conn.close()     del conn ... View more

Hello guys, I have a python script which geocodes data from a SQL Server database. The script uses an OLE DB connection to connect to the data, and the connection uses a SQL Server user  with a password. I have created a SQL Server Agent job to run the script. When the OLE DB connection points to a database on the same server where the Python script is, the SQL Server job starts the Python script and executes it successfully. No problems here. When the OLE DB connection points to a database on a different server (not where the Python script is), the job starts the Python script (I have a log file and it shows that the first few statements are executed) and then when it has to connect to the database just hangs and does nothing. No error. Just hangs. If I run the same Python script from the IDLE, it runs successfully. I believe that the problem comes from the account running the script, which in this case is the account running the SQL Sever job. But I am not sure what I need to do to make this work. Any idea is greatly appreciated! Thank you! Darina ... View more