Questions tagged [pyodbc]

pyodbc is a Python 2.x and 3.x module that allows you to use ODBC to connect to almost any database from Windows, Linux, OS/X, and more.

Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

What does the ArcGIS10.2 sde_state_id suffix 'L' mean in delta tables, when read using pyodbc in Python?

Enterprise geodatabase sits in MS SQL Server database. I'm using Python's pyodbc SQL driver to read SDE delta tables. I'm running the following query: select delete_table.SDE_STATE_ID, ...
0
votes
1answer
244 views

Query containing special characters passed by pyodbc works differently in standalone ArcGIS script and toolbox

I am passing few queries through pyodbc in my script to get data from Access database and write them to layers table. Everything was fine when I have been running script from PyCharm, but when I put ...
-1
votes
1answer
221 views

Write rows from file geodatabase Table to NonGDB Table in SQL Server using Python

I have data in a file geodatabase table that I want to write into an existing table in SQL Server (not enterprise-enabled) using Python. I am already using pyodbc to read SQL data elsewhere, but am ...
2
votes
1answer
1k views

How do I decide what sort of spatial index to build for a SQL Server table with a Geometry column?

Let’s say an organization manages a lot of GIS data stored in Sql Server and leverages Esri software. To ensure that users can access the data with reasonable speed, I want to make sure the spatial ...
0
votes
1answer
2k views

Install pyodbc module for ArcGIS 10.5 [closed]

My script calls: import pyodbc ...but returns error: Traceback (most recent call last): File "C:\MyPyScripts\extract.py", line 1, in <module> import pyodbc ImportError: No module ...
2
votes
1answer
463 views

ArcSDE reconcile versions and keep edit version in its current state

Reconciling versions makes both target and source(s) point to the same state. I have an arcpy script that essentially will create a version from a parent of the db - in a state that is empty - adds ...
1
vote
3answers
448 views

QGIS 2.8 Wien - dll pyodbc not found

I just installed QGIS Wien 2.8.1, first the OSGEO4W Installer and later the standalone installer (32bits) and when I write import pyodbc on the Python console I get a message that the dll was not ...
0
votes
1answer
881 views

Error in Select Numeric type column in pyodbc with ArcCatalog?

I created a python script that uses "pyodbc" plugin to connect a SQL Server database and write out data. It was imported in an ArcGIS 10.1 tool and run from there. try: arcpy.AddMessage('FLAG 0') ...
8
votes
2answers
3k views

Converting File Geodatabase Table to Access 2007 ACCDB table programmatically?

Does anyone know of a method to convert a File Geodatabase Table into an Access 2007 Table programmatically. I have been trying using the PYODBC library and a series of insert statements but am ...