pyodbc

相关标签：javascript jquery android 多少钱 iPhone

pyodbc and mySQL

I am unable to connect to mySQl db using pyodbc. Here is a snippet of my script: import pyodbc import csv[详细]

2023-01-21 09:41 分类：问答
Using Microsoft Access SQL operators in Python ODBC

Short version: When I try to use Access\'s DatePart function via ODBC, it cannot be reso开发者_开发百科lved.[详细]

2023-01-20 17:59 分类：问答
How to strip "()," from Python, PyODBC, SQL Returns?

I grabbed a bunch of SQL IDs I need to update with Python and PyODBC: import pyodbc cnxn = pyodbc.connect(\'DSN=YesOne;PWD=xxx\')[详细]

2023-01-13 18:24 分类：问答
FreeTDS translating MS SQL money type to python float, not Decimal

I am connecting to an MS SQL Server db from Python in Linux.I am connecting via pyodbc using the FreeTDS driver.When I return a money field from MSSQL it comes through as a float, rather than a Python[详细]

2023-01-09 08:11 分类：问答
How to connect pyodbc to an Access (.mdb) Database file

Here\'s what I\'ve tried: -Find Vista\'s ODBC Data Source Manager* through search, -Add a new File Data Source*, selecting Driver for Microsoft Access (*.mdb), and selecting my mdb file of interest,[详细]

2023-01-07 14:10 分类：问答
import pyodbc results in DLL load failed with error code 193 on Win7

I am running 64-bit Windows 7 and the ActiveState Python 2.5 installation (64-bit version).I just downloaded and installed the pyodbc 2.1.7 win32 package.When I run the installer as an admin it pr开发[详细]

2023-01-07 07:34 分类：问答
pyODBC and Unicode

I\'m working with pyODBC communicate with a MS SQL 2005 Express server. The table to which i\'m trying to save the data consists of nvarchar columns.[详细]

2023-01-03 13:20 分类：问答
Unable to install pyodbc on Linux

I am running Lin开发者_如何学JAVAux (2.6.18-164.15.1.el5.centos.plus) and trying to install pyodbc.I am doing pip install pyodbc and get a very long list of errors, which end in[详细]

2023-01-02 05:23 分类：问答
Binding a null value to a date field in pyodbc

Using pyodbc, if I try and execute this code on a date field: cursor.execute(\'insert into test VALUES (?)\', None)[详细]

2023-01-01 09:20 分类：问答
Python - Linux - Connecting to MS SQL with Windows Credentials - FreeTDS+UnixODBC + pyodbc or pymssql

There doesn\'t seem to be any great instructions for setting this up.Does anyone have any good instructions?I am a linux noob so be gentle.I did see another post that is similar, but no real answer.[详细]

2022-12-31 16:56 分类：问答