pyodbc
MSSQL2008 - Pyodbc - Previous SQL was not a query
I can\'t figure out what\'s wrong with the following code, The syntax IS ok (checked with SQL Management Studio), i have access as i should so that works too.. but for some reason as soon as i try to[详细]
2023-04-12 23:00 分类:问答Cant Create tables in access with pyodbc
I am trying to create tables in a MS Access DB with python using pyodbc but when I run my script no tables are created and no errors are given. My code:[详细]
2023-04-12 09:13 分类:问答SQL Update fails - pyodbc - informix
Updates to an 开发者_Python百科informix database via a python script using pyodbc are silently failing.[详细]
2023-04-07 10:59 分类:问答pyodbc returns SQL Server DATE fields as strings
I\'m using pyodbc to query a SQL Server 2008 database table with columns of DATE type. The resulting rows of data contain date strings rather than python datetime.date or datetime.datetime instances[详细]
2023-03-30 14:20 分类:问答handling None values in conversion to numpy recarray
Is there a graceful way of handling None values in a conversion of a list of tuples to a numpy recarray using the single call to np.rec.fromrecords?Assuming I know what I want the missing value to be[详细]
2023-03-28 10:43 分类:问答PyODBC - cursor record value rounding
I am working on a Python script (Python version 2.5.1 on Windows XP) that involves connecting to a Microsoft Access (.mdb) database to read values from a table. I\'m getting some unexpected results wi[详细]
2023-03-26 13:38 分类:问答Python: using pyodbc and replacing row field values
I\'m trying to figure out if it\'s possible to replace record values in a Microsoft Access (either .accdb or .mdb) database using pyodbc. I\'ve poured over the documentation and noted where it says th[详细]
2023-03-19 06:46 分类:问答How do I select the last 5 minutes of data from an ms access db using pyodbc?
I have the following query (python pyodbc on windows 7 accessing an access db .mdb): SQL = \'SELECT acq_spill_3_1_sec.time_stamp, acq_spill_3_1_se开发者_如何学编程c.float_value[详细]
2023-03-16 01:53 分类:问答Pyodbc utf-8 bind param error With FreeTDS and unixODBC
FreeTDS version 0.82 unixODBC version 2.3.0 pyodbc version 2.1.8 freetds.conf: tds version = 7.0 client charset = UTF-8[详细]
2023-03-06 09:53 分类:问答pymysql vs. pyodbc - pymysql is sloooooooooooow
I\'ve been having an issue trying to get my simple data analysis program that uses MySQL to work correctly.[详细]
2023-03-02 21:31 分类:问答