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
1answer
64 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
161 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
545 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
442 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
425 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
794 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 ...