Skip to main content

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
1 answer

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 ...
Kubson's user avatar
  • 614
-2 votes
1 answer

Writing rows from file geodatabase Table to NonGDB Table in SQL Server using Python [closed]

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 ...
Rex's user avatar
  • 596
2 votes
1 answer

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 ...
gischimp's user avatar
  • 184
0 votes
1 answer

Install pyodbc module for ArcGIS 10.5 [closed]

My script calls: import pyodbc ...but returns error: Traceback (most recent call last): File "C:\MyPyScripts\", line 1, in <module> import pyodbc ImportError: No module ...
Matt Goodman's user avatar
2 votes
1 answer

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 ...
branchini's user avatar
  • 177
1 vote
3 answers

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 ...
nanunga's user avatar
  • 533
0 votes
1 answer

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') ...
alextc's user avatar
  • 2,013
8 votes
2 answers

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 ...
dklassen's user avatar
  • 2,920