ANN: eGenix mxODBC 3.3.6 - Python ODBC Database Interface

2016-11-16 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Python ODBC Database Interface Version 3.3.6 mxODBC is our commercially supported Python extension providing

ANN: eGenix mxODBC 3.3.5 - Python ODBC Database Interface

2015-08-19 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Python ODBC Database Interface Version 3.3.5 mxODBC is our commercially supported Python extension providing

ANN: eGenix mxODBC 3.3.4 - Python ODBC Database Interface

2015-08-12 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Python ODBC Database Interface Version 3.3.4 mxODBC is our commercially supported Python extension providing

ANN: eGenix mxODBC 3.3.3 - Python ODBC Database Interface

2015-06-25 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Python ODBC Database Interface Version 3.3.3 mxODBC is our commercially supported Python extension providing

ANN: eGenix mxODBC 3.3.2 - Python ODBC Database Interface

2015-03-12 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Python ODBC Database Interface Version 3.3.2 mxODBC is our commercially supported Python extension providing

ANN: eGenix mxODBC 3.3.1 - Python ODBC Database Interface

2014-07-09 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Python ODBC Database Interface Version 3.3.1 mxODBC is our commercially supported Python extension providing

ANN: eGenix mxODBC Connect 2.1.0 - Python ODBC Database Interface

2014-05-28 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Connect Python ODBC Database Interface Version 2.1.0 mxODBC Connect is our commercially supported client-server product

ANN: eGenix mxODBC Connect 2.0.5 - Python ODBC Database Interface

2014-04-24 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Connect Python ODBC Database Interface Version 2.0.5 mxODBC Connect is our commercially supported client-server product

Re: Python 2.3 and ODBC

2014-04-08 Thread Mark Lawrence
On 08/04/2014 21:18, Gabor Urban wrote: Hi guys, [snip] BTW if my demo will be good, we hope to have an aproval to change to Python 3.3 Why 3.3? 3.4 has just been released and has lots of new batteries, so why not use them? Thanks in advance -- Urbán Gábor Linux is like a wigwam: n

Re: Python 2.3 and ODBC

2014-04-08 Thread Tim Chase
d extracting data into Oracle > tables. > > Now I am almost ready, but need to use an ODBC module with Python. > What do you suggest? Your project sounds remarkably like one I maintain for a local business, though I have the luxury of working with Python 2.*4* under XP on that proje

Re: Python 2.3 and ODBC

2014-04-08 Thread Larry Martell
incoming > XML files and extracting data into Oracle tables. > > Now I am almost ready, but need to use an ODBC module with Python. What do > you suggest? I do not know anything about Windows, but on Linux I'm pretty sure pyodbc requires python 2.7 or higher. -- https://mail.py

Python 2.3 and ODBC

2014-04-08 Thread Gabor Urban
ready, but need to use an ODBC module with Python. What do you suggest? BTW if my demo will be good, we hope to have an aproval to change to Python 3.3 Thanks in advance -- Urbán Gábor Linux is like a wigwam: no Gates, no Windows and an Apache inside. -- https://mail.python.org/mailman

ANN: eGenix mxODBC 3.3.0 - Python ODBC Database Interface

2014-04-08 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Python ODBC Database Interface Version 3.3.0 mxODBC is our commercially supported Python extension providing

ANN: eGenix mxODBC Connect 2.0.4 - Python ODBC Database Interface

2014-02-12 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Connect Python ODBC Database Interface Version 2.0.4 mxODBC Connect is our commercially supported client-server product

ANN: eGenix mxODBC Django Database Engine - Django ODBC Adapter 1.2.0

2013-06-18 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Django Database Engine MS SQL Server ORM and ODBC Adapter for the Django Web Framework Version 1.2.0 The

ANN: eGenix mxODBC 3.2.3 - Python ODBC Database Interface

2013-05-06 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Python ODBC Database Interface Version 3.2.3 mxODBC is our commercially supported Python extension providing

ANN: eGenix mxODBC Connect - Python ODBC Database Interface 2.0.3

2013-04-09 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Connect Python ODBC Database Interface Version 2.0.3 mxODBC Connect is our commercially supported client-server product

ANN: eGenix mxODBC 3.2.2 - Python ODBC Database Interface

2013-03-25 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Python ODBC Database Interface Version 3.2.2 mxODBC is our commercially supported Python extension providing

PyPyODBC 1.0.5 released. (DBI 2.0 ODBC module compatible with PyPy, IronPython and SQLAlchemy)

2013-03-10 Thread 江文
Changes in Ver 1.0.5 (and 1.0.4, 1.0.3, 1.0.2, 1.0.1) - *Fix several bugs under Python 3.x* - *Add Mac / iODBC platform support* - *Improved ODBC ANSI / unicode mode support* Features - *One pure Python script, runs on CPython / IronPython<https://code.google.com/p/pypyodbc/w

PyPyODBC 1.0 (Pure Python ODBC) released with Python 3.3 support

2013-02-21 Thread 江文
PyPyODBC, the single script Python ODBC module, now runs under both Python 2.x and Python 3.3 PyPyODBC - A Pure Python ctypes ODBC module > > Features > >- *One pure Python script, runs on CPython / > IronPython<http://ironpython.codeplex.com/> > / PyPy <http

ANN: eGenix mxODBC 3.2.1 - Python ODBC Database Interface

2012-09-25 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Python ODBC Database Interface Version 3.2.1 mxODBC is our commercially supported Python extension providing

ANN: eGenix mxODBC 3.2.0 - Python ODBC Database Interface

2012-08-28 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC Python ODBC Database Interface Version 3.2.0 mxODBC is our commercially supported Python extension providing

PyPyODBC 0.8 released (Pure Python ODBC module)

2012-08-24 Thread 江文
PyPyODBC - A Pure Python ctypes ODBC module Changes in version 0.8: Added the getinfo() method to the connection object Changes in version 0.7: Fixed the ntext/nchar/nvarchar string truncat problem Changes in version 0.6: Added Cursor.commit() and Cursor.rollback(). Added readonly keyword to

Re: sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'f2f68'

2012-08-17 Thread Peter Otten
sqlalchemy.create_engine("mssql+pyodbc://DumpResult:123456@localhost/DumpResult") > c = engine.execute(cmdTest1) > > > !!!!! > case1 :wrong,(sqlalchemy.exc.ProgrammingError: (ProgrammingError) > ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL

Re: sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'f2f68'

2012-08-17 Thread Alain Ketterlin
e = > sqlalchemy.create_engine("mssql+pyodbc://DumpResult:123456@localhost/DumpResult") > c = engine.execute(cmdTest1) > > > ! > case1 :wrong,(sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('42000', > "[42000] [Microsoft][ODBC SQL Server Driv

sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'f2f68'

2012-08-17 Thread nepaul
DumpResult") c = engine.execute(cmdTest1) ! case1 :wrong,(sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]'f2f68') case2:work! -- http://mail.python.org/mailman/listinfo/python-list

PyPyODBC 0.6 released! (A Pure Python ODBC module)

2012-07-04 Thread 江文
PyPyODBC - A Pure Python ctypes ODBC module Changes in version 0.6: Added Cursor.commit() and Cursor.rollback(). It is now possible to use only a cursor in your code instead of keeping track of a connection and a cursor. Added readonly keyword to connect. If set to True, SQLSetConnectAttr

PyPyODBC 0.5 alpha released! (A Pure Python ODBC module)

2012-06-15 Thread 江文
PyPyODBC - A Pure Python ctypes ODBC module Features -Pure Python, compatible with PyPy (tested on Win32) -Almost totally same usage as pyodbc You can simply try pypyodbc in your existing pyodbc powered script with the following changes: #import pyodbc

ANN: eGenix mxODBC - Python ODBC Database Interface 3.1.2

2012-04-26 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC - Python ODBC Database Interface Version 3.1.2 mxODBC is our commercially supported Python extension providing ODBC database connectivity to

Re: Working with databases (ODBC and ORMs) in Python 3.2

2011-11-10 Thread Jerry Zhang
2011/11/11 tkp...@hotmail.com > We are in the process of trying to decide between Python 2.7 and 3.2 > with a view to making a 5-10 year commitment to the right platform, > and would appreciate some guidance on how best to connect to SQL > databases in 3.2. ceODBC 2.01 provides an

Re: Working with databases (ODBC and ORMs) in Python 3.2

2011-11-10 Thread Nathan Rice
> and would appreciate some guidance on how best to connect to SQL > databases in 3.2. ceODBC 2.01 provides an ODBC driver for Python 3.2, > does anyone have experience using it? Also, are there any ORMs (object > relational mapper)s that work well with 3,2? > > Thanks in advance &g

Working with databases (ODBC and ORMs) in Python 3.2

2011-11-10 Thread tkp...@hotmail.com
We are in the process of trying to decide between Python 2.7 and 3.2 with a view to making a 5-10 year commitment to the right platform, and would appreciate some guidance on how best to connect to SQL databases in 3.2. ceODBC 2.01 provides an ODBC driver for Python 3.2, does anyone have

Re: An ODBC interface for Python 3?

2011-07-02 Thread Roger Upole
plain; I'm just stating it out in > the open so that it's known. Indeed, even if one doesn't want to use > MSSQL, the only free ODBC interface I know of that works on Python 3 > is ceODBC, and it is not supported by other modules such as > SQLAlchemy. > > I

An ODBC interface for Python 3?

2011-07-01 Thread kozmikyak
doesn't want to use MSSQL, the only free ODBC interface I know of that works on Python 3 is ceODBC, and it is not supported by other modules such as SQLAlchemy. I'm wondering how I could best make something like this happen. I've written to the SQLAlchemy and pyodbc projects. I ha

ANN: eGenix mxODBC - Python ODBC Database Interface 3.1.1

2011-05-25 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC - Python ODBC Database Interface Version 3.1.1 mxODBC is our commercially supported Python extension providing ODBC database connectivity to

ANN: eGenix mxODBC - Python ODBC Database Interface 3.1.0

2010-08-19 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC - Python ODBC Database Interface Version 3.1.0 mxODBC is our commercially supported Python extension providing ODBC database connectivity to

Re: An ODBC interface for Python 3?

2010-07-21 Thread Neil Cerutti
On 2010-07-21, Tim Golden wrote: > On 21/07/2010 2:15 PM, Neil Cerutti wrote: >> A quick web search yielded no current support for the ODBC >> interface for Python 3. >> >> I'd like to get a simple "tracer bullet" up and running ASAP. I >> need to c

Re: An ODBC interface for Python 3?

2010-07-21 Thread Tim Golden
On 21/07/2010 2:15 PM, Neil Cerutti wrote: A quick web search yielded no current support for the ODBC interface for Python 3. I'd like to get a simple "tracer bullet" up and running ASAP. I need to connect to an MSSQL database from Windows XP/2000, using an ODBC interface. Is th

An ODBC interface for Python 3?

2010-07-21 Thread Neil Cerutti
A quick web search yielded no current support for the ODBC interface for Python 3. I'd like to get a simple "tracer bullet" up and running ASAP. I need to connect to an MSSQL database from Windows XP/2000, using an ODBC interface. Is this a case where I'll need to g

Re: Python 2.6 and modules dbi AND odbc

2010-03-11 Thread Kev Dwyer
On Wed, 10 Mar 2010 16:17:29 -0800, robert somerville wrote: > hi; > i am trying to get some legacy python code (which i no nothing about) > working with tries to import dbi and odbc (the import fails ...) it > looks like these modules are deprecated ?? if so is there a work aroun

Python 2.6 and modules dbi AND odbc

2010-03-10 Thread robert somerville
hi; i am trying to get some legacy python code (which i no nothing about) working with tries to import dbi and odbc (the import fails ...) it looks like these modules are deprecated ?? if so is there a work around , if not deprecated, what am i doing wrong ?? i see no Ubuntu packages that look

Re: How to access ODBC databases ?

2009-09-06 Thread Timothy Madden
Martin P. Hellwig wrote: Timothy Madden wrote: [...] It has been a couple of years, but I remember vaguely that back in the days of PossgreSQL 6, if you want ODBC support you needed to compile PG a bit different then normal, I am not really sure what options those where and if this still

Re: How to access ODBC databases ?

2009-09-06 Thread Martin P. Hellwig
, Timothy Madden It has been a couple of years, but I remember vaguely that back in the days of PossgreSQL 6, if you want ODBC support you needed to compile PG a bit different then normal, I am not really sure what options those where and if this still applies, I decided to not use ODBC because it

Re: How to access ODBC databases ?

2009-09-05 Thread Timothy Madden
Martin P. Hellwig wrote: Timothy Madden wrote: Martin P. Hellwig wrote: Timothy Madden wrote: >>> conn = pyodbc.connect('DRIVER={PostgreSQL Unicode};Servername=127.0.0.1;UID=pikantBlue;Database=pikantBlue') Traceback (most recent call last): File "", line 1, in pyodbc.Error: ('0', '[0

Re: How to access ODBC databases ?

2009-09-04 Thread Martin P. Hellwig
Timothy Madden wrote: Martin P. Hellwig wrote: Timothy Madden wrote: >>> conn = pyodbc.connect('DRIVER={PostgreSQL Unicode};Servername=127.0.0.1;UID=pikantBlue;Database=pikantBlue') Traceback (most recent call last): File "", line 1, in pyodbc.Error: ('0', '[0] [nxDC (202) (SQLDriverCo

Re: How to access ODBC databases ?

2009-09-04 Thread Timothy Madden
Martin P. Hellwig wrote: Timothy Madden wrote: >>> conn = pyodbc.connect('DRIVER={PostgreSQL Unicode};Servername=127.0.0.1;UID=pikantBlue;Database=pikantBlue') Traceback (most recent call last): File "", line 1, in pyodbc.Error: ('0', '[0] [nxDC (202) (SQLDriverConnectW)') Not sure (i

Re: How to access ODBC databases ?

2009-09-04 Thread Martin P. Hellwig
Timothy Madden wrote: >>> conn = pyodbc.connect('DRIVER={PostgreSQL Unicode};Servername=127.0.0.1;UID=pikantBlue;Database=pikantBlue') Traceback (most recent call last): File "", line 1, in pyodbc.Error: ('0', '[0] [nxDC (202) (SQLDriverConnectW)') Not sure (i.e. wild guess) but that l

How to access ODBC databases ?

2009-09-04 Thread Timothy Madden
Hello I would like to use a database through ODCB in my python application. I have Slackware Linux, but I would not mind a portable solution, since python runs on both Unixes and Windows. I would like a free/open-source solution and the python module for ODBC access that I have found is

ANN: eGenix mxODBC - Python ODBC Database Interface 3.0.3

2009-09-01 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC - Python ODBC Database Interface Version 3.0.3 mxODBC is our commercially supported Python extension providing ODBC database connectivity to

Re: connect to ms sql server with odbc

2009-08-30 Thread Sean DiZazzo
On Aug 30, 10:08 pm, mierdatutis mi wrote: > Hi, > > I'm newbie in python. I try to connect to remote server with ms sql > server from my ubuntu. I install pyodbc and I do: > >  >>> conn = >>> Conn = >  pyodbc.connect("DRIVER= > {FreeTDS};SERVER=defekas62;UID=emuser;PWD=temporal;DATABASE=em620") >

connect to ms sql server with odbc

2009-08-30 Thread mierdatutis mi
Hi, I'm newbie in python. I try to connect to remote server with ms sql server from my ubuntu. I install pyodbc and I do: >>> conn = >>> Conn = pyodbc.connect("DRIVER= {FreeTDS};SERVER=defekas62;UID=emuser;PWD=temporal;DATABASE=em620") pyodbc.connect ( "DRIVER = () FreeTDS; SERVER = defekas62;

Re: [egenix-info] Re: ANN: eGenix mxODBC - ODBC Database Interface for Python 3.0.2

2008-10-15 Thread eGenix Team: M.-A. Lemburg
On 2008-10-15 20:30, Terry Reedy wrote: > FYI > I initially parsed the subject line as > "eGenix mxODBC - ODBC Database Interface" for "Python 3.0.2" > and thought, "Wow, already prepared for the future" (6 months to a year) > ;-). It's going to

Re: ANN: eGenix mxODBC - ODBC Database Interface for Python 3.0.2

2008-10-15 Thread Terry Reedy
FYI I initially parsed the subject line as "eGenix mxODBC - ODBC Database Interface" for "Python 3.0.2" and thought, "Wow, already prepared for the future" (6 months to a year) ;-). tjr -- http://mail.python.org/mailman/listinfo/python-list

ANN: eGenix mxODBC - ODBC Database Interface for Python 3.0.2

2008-10-15 Thread eGenix Team: M.-A. Lemburg
ANNOUNCING eGenix.com mxODBC - ODBC Database Interface for Python Version 3.0.2 mxODBC is our commercially supported Python extension providing ODBC database connectivity to

Re: Writing Unicode to database using ODBC

2008-09-03 Thread John Machin
u'\u201c' in > position 3 > 79: ordinal not in range(128) > > I've verified that query is of type unicode by checking the type a > statement or two earlier (output: ). > So then I thought maybe the odbc execute just can't handle unicode > data. It appears to

Writing Unicode to database using ODBC

2008-09-03 Thread Mudcat
In short what I'm trying to do is read a document using an xml parser and then upload that data back into a database. I've got the code more or less completed using xml.etree.ElementTree for the parser and dbi/ odbc for my db connection. To fix problems with unicode I built a work

find all ODBC databases ?

2008-07-08 Thread Stef Mientki
hello, I'm working on a general database manager, which will be open source and should preferable work under all OS. Now in windows I can find the ODBC databases by reading some reg key. I also know that ODBC is supported under Linux (I don't know anything of Linux), but how can

Re: Getting column names from a cursor using ODBC module?

2008-06-27 Thread M.-A. Lemburg
John Machin wrote: > On Jun 21, 11:58 pm, [EMAIL PROTECTED] wrote: >> Is there any way to retrieve column names from a cursor using the ODBC >> module? Or must I, in advance, create a dictionary of column position >> and column names for a particular table before I can acces

Re: Getting column names from a cursor using ODBC module?

2008-06-22 Thread dananrg
Thanks Chris and John. Chris, this worked perfectly with the ODBC module that ships with Python Win32: > column_names = [d[0] for d in cursor.description] John, I've never heard of pyodbc but I'll have to look into it. Thanks again. Dana -- http://mail.python.org/mailman/listinfo/python-list

Re: Getting column names from a cursor using ODBC module?

2008-06-22 Thread Michael Mabin
etrieve column names from a cursor using the ODBC > > module? Or must I, in advance, create a dictionary of column position > > and column names for a particular table before I can access column > > values by column names? I'd prefer sticking with the ODBC module for

Re: Getting column names from a cursor using ODBC module?

2008-06-21 Thread Chris
On Jun 21, 3:58 pm, [EMAIL PROTECTED] wrote: > Is there any way to retrieve column names from a cursor using the ODBC > module? Or must I, in advance, create a dictionary of column position > and column names for a particular table before I can access column > values by column names

Re: Getting column names from a cursor using ODBC module?

2008-06-21 Thread John Machin
On Jun 22, 12:19 am, John Machin <[EMAIL PROTECTED]> wrote: > On Jun 21, 11:58 pm, [EMAIL PROTECTED] wrote: > > > Is there any way to retrieve column names from a cursor using the ODBC > > module? Or must I, in advance, create a dictionary of column position > > and

Re: Getting column names from a cursor using ODBC module?

2008-06-21 Thread John Machin
On Jun 21, 11:58 pm, [EMAIL PROTECTED] wrote: > Is there any way to retrieve column names from a cursor using the ODBC > module? Or must I, in advance, create a dictionary of column position > and column names for a particular table before I can access column > values by column names

Re: Getting column names from a cursor using ODBC module?

2008-06-21 Thread John Machin
On Jun 21, 11:58 pm, [EMAIL PROTECTED] wrote: > Is there any way to retrieve column names from a cursor using the ODBC > module? Or must I, in advance, create a dictionary of column position > and column names for a particular table before I can access column > values by column names

Getting column names from a cursor using ODBC module?

2008-06-21 Thread dananrg
Is there any way to retrieve column names from a cursor using the ODBC module? Or must I, in advance, create a dictionary of column position and column names for a particular table before I can access column values by column names? I'd prefer sticking with the ODBC module for now because it

Re: ODBC links?

2007-11-12 Thread Johannes Findeisen
On Mon, 2007-11-12 at 10:13 +, Mr. Connolly wrote: > Lo' there. I'm a new user of Python, what I'm looking for is an easy way to > create ODBC links to Access databases (obviously, Access isn't the best > database out there I can use, but its easiest to just pie

ODBC links?

2007-11-12 Thread Mr. Connolly
Lo' there. I'm a new user of Python, what I'm looking for is an easy way to create ODBC links to Access databases (obviously, Access isn't the best database out there I can use, but its easiest to just piece together for this quick project). What modules would I want to be l

Re: odbc module for python

2007-07-19 Thread Tim Golden
Steve Holden wrote: > Sean Davis wrote: >> What are the alternatives for accessing an ODBC source from python >> (linux 64-bit, python 2.5)? It looks like mxODBC is the only one >> available? >> > There is, I understand, a pyodbc module as well. Having never used it

Re: odbc module for python

2007-07-19 Thread Steve Holden
Sean Davis wrote: > What are the alternatives for accessing an ODBC source from python > (linux 64-bit, python 2.5)? It looks like mxODBC is the only one > available? > There is, I understand, a pyodbc module as well. Having never used it I can't say how good it is. regards

odbc module for python

2007-07-18 Thread Sean Davis
What are the alternatives for accessing an ODBC source from python (linux 64-bit, python 2.5)? It looks like mxODBC is the only one available? Thanks, Sean -- http://mail.python.org/mailman/listinfo/python-list

Accessing OpenLink ODBC driver

2007-07-11 Thread Mariano Mara
Hi everyone. I have a Windows 2000 server with an OpenLink ODBC client installed which we use to connect to an Informix database. I'm not allowed to access to informix directly so I would like to write an script to retrieve some info using the mentioned driver. As far as I can tell, there

Re: Python 2.3 ODBC Datetime limitations

2007-06-02 Thread John Machin
On Jun 3, 4:47 am, Tim Golden <[EMAIL PROTECTED]> wrote: > Steve Holden wrote: > > YuePing Lu wrote: > >> Hello, > > >> Has any of you ever used Python odbc to retrieve data from a relational DB? > > >> I encountered a problem where it can't h

Re: Python 2.3 ODBC Datetime limitations

2007-06-02 Thread Tim Golden
Steve Holden wrote: > YuePing Lu wrote: >> Hello, >> >> Has any of you ever used Python odbc to retrieve data from a relational DB? >> >> I encountered a problem where it can't handle datetime _earlier than >> _*1969*, and _later than _*2040*. It just r

Re: Python 2.3 ODBC Datetime limitations

2007-06-02 Thread Steve Holden
YuePing Lu wrote: > Hello, > > Has any of you ever used Python odbc to retrieve data from a relational DB? > > I encountered a problem where it can't handle datetime _earlier than > _*1969*, and _later than _*2040*. It just returned some garbage strings > when

Python 2.3 ODBC Datetime limitations

2007-06-01 Thread YuePing Lu
Hello, Has any of you ever used Python odbc to retrieve data from a relational DB? I encountered a problem where it can't handle datetime *earlier than **1969*, and *later than **2040*. It just returned some garbage strings when I call str(my_date_object). When I call strptime to conver

Re: Python ODBC

2007-04-30 Thread Harry George
[EMAIL PROTECTED] writes: > On Apr 29, 11:34 am, Harlin Seritt <[EMAIL PROTECTED]> wrote: > > Is there a Python odbc module that will work on Linux? I have a jdbc > > connection to a DB2 server. I am looking hopefully for an open source > > solution and not a com

Re: Python ODBC

2007-04-30 Thread kyosohma
On Apr 29, 11:34 am, Harlin Seritt <[EMAIL PROTECTED]> wrote: > Is there a Python odbc module that will work on Linux? I have a jdbc > connection to a DB2 server. I am looking hopefully for an open source > solution and not a commercial one. > > Thanks, > > Harlin I

Re: Python ODBC

2007-04-29 Thread Jorge Mazzonelli
For ODBC connections you can try pyODBC. I didn't test it on Linux but it is said it works on both Windows and POSIX systems. pyODBC--> pyodbc.sourceforge.net The license is MIT License. You can also have a look here: http://sparcs.kaist.ac.kr/~tinuviel/python/database.html since it has

Python ODBC

2007-04-29 Thread Harlin Seritt
Is there a Python odbc module that will work on Linux? I have a jdbc connection to a DB2 server. I am looking hopefully for an open source solution and not a commercial one. Thanks, Harlin -- http://mail.python.org/mailman/listinfo/python-list

Re: Using/finding ODBC and DBI

2007-04-09 Thread Gabriel Genellina
En Mon, 09 Apr 2007 10:12:20 -0300, Boudreau, Emile <[EMAIL PROTECTED]> escribió: > Hello all, I'm trying to use ODBC and DBI but I don't seem to have the > right files on my system. I have looked around and I can't find what I'm > looking for. From the i

Using/finding ODBC and DBI

2007-04-09 Thread Boudreau, Emile
Hello all, I'm trying to use ODBC and DBI but I don't seem to have the right files on my system. I have looked around and I can't find what I'm looking for. From the information I have been able to find these are not part of the standard python library. True?? Where can I find

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Godzilla
field... > >> You didn't have a set of 's around the ?, did you? Parameter > >> substitution will add needed quotes on its own rather than you having to > >> put in quotes. > > >> Also, though I find no documentation on it, odbc module

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Steve Holden
arameter >> substitution will add needed quotes on its own rather than you having to >> put in quotes. >> >> Also, though I find no documentation on it, odbc module cursors have >> setinputsizes() and setoutputsizes() methods -- perhaps that could >> change things...

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Godzilla
its own rather than you having to > put in quotes. > > Also, though I find no documentation on it, odbc module cursors have > setinputsizes() and setoutputsizes() methods -- perhaps that could > change things... OTOH: the db-api 1.0 PEP (which is, it seems, what odbc >

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Godzilla
its own rather than you having to > put in quotes. > > Also, though I find no documentation on it, odbc module cursors have > setinputsizes() and setoutputsizes() methods -- perhaps that could > change things... OTOH: the db-api 1.0 PEP (which is, it seems, what odbc >

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Godzilla
On Mar 22, 10:56 pm, Steve Holden <[EMAIL PROTECTED]> wrote: > Godzilla wrote: > > Dear all, > > > I cannot find a solution for my problem with inserting a blob object > > (>4000 in length) into an ORACLE database via ODBC. > > > I have tried the two way

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Paul Boddie
On 22 Mar, 10:21, "Godzilla" <[EMAIL PROTECTED]> wrote: > > I cannot find a solution for my problem with inserting a blob object > (>4000 in length) into an ORACLE database via ODBC. This brings back "happy" memories with Oracle 9i and JDBC. > I have

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Steve Holden
Godzilla wrote: > Dear all, > > I cannot find a solution for my problem with inserting a blob object > (>4000 in length) into an ORACLE database via ODBC. > > > I have tried the two ways of inserting the blob object (a zip file): > > > 1) > fp = op

Re: Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Steve Holden
Godzilla wrote: > Dear all, > > I cannot find a solution for my problem with inserting a blob object > (>4000 in length) into an ORACLE database via ODBC. > > > I have tried the two ways of inserting the blob object (a zip file): > > > 1) > fp = op

Python Oracle 10g odbc blob insertion problem

2007-03-22 Thread Godzilla
Dear all, I cannot find a solution for my problem with inserting a blob object (>4000 in length) into an ORACLE database via ODBC. I have tried the two ways of inserting the blob object (a zip file): 1) fp = open("c:/test/test.zip", "r+b") data = fp.read() s = odbc.

Re: odbc DbiDate date conversion

2006-09-27 Thread flupke
Frank Millman schreef: > Not that I know of. The results of my investigations so far seem to > indicate that we have a problem :-( > > Here is a link to an article dated 1998 - > https://svn.python.org/www/trunk/pydotorg/windows/OdbcHints.html > > Among other interesting stuff, it states -

Re: odbc DbiDate date conversion

2006-09-27 Thread Frank Millman
flupke wrote: > Frank Millman schreef: > > > > Well waddyaknow - I get exactly the same, for dates earlier than > > 1970-01-02. Thanks for finding a bug that would have bitten me sooner > > or later. > > > > I will do some investigation. If I find an answer I will post it here, > > unless some ki

Re: odbc DbiDate date conversion

2006-09-26 Thread flupke
flupke schreef: When i do the same sql from a client, i get this: 1961-02-15 Seems ok. If i check the catalog, the native field type is listed as 10 positions and of type date. Yet when i print it after i got the values i get this which looks very weird (print "value ",str(i)," type ",type(i)):

Re: odbc DbiDate date conversion

2006-09-26 Thread flupke
Frank Millman schreef: > Well waddyaknow - I get exactly the same, for dates earlier than > 1970-01-02. Thanks for finding a bug that would have bitten me sooner > or later. > > I will do some investigation. If I find an answer I will post it here, > unless some kind soul saves me the trouble an

Re: odbc DbiDate date conversion

2006-09-26 Thread Frank Millman
flupke wrote: > Frank Millman schreef: > > flupke wrote: > >> I'm using a solid DB and i'm accessing it via the odbc module > >> (activepython). > >> I get a DbiDate object returned but i don't find a way to decently print > >> it or

Re: odbc DbiDate date conversion

2006-09-26 Thread flupke
Frank Millman schreef: > flupke wrote: >> I'm using a solid DB and i'm accessing it via the odbc module >> (activepython). >> I get a DbiDate object returned but i don't find a way to decently print >> it or get a format like %d/%m%/%y. >> >

Re: odbc DbiDate date conversion

2006-09-26 Thread Frank Millman
flupke wrote: > I'm using a solid DB and i'm accessing it via the odbc module > (activepython). > I get a DbiDate object returned but i don't find a way to decently print > it or get a format like %d/%m%/%y. > I convert it to a datetime() ins

odbc DbiDate date conversion

2006-09-26 Thread flupke
I'm using a solid DB and i'm accessing it via the odbc module (activepython). I get a DbiDate object returned but i don't find a way to decently print it or get a format like %d/%m%/%y. I found a few posts but the code doesn't work. >>> birthd = results[0][4] #inf

Re: Publishing ODBC database content as PDF

2006-07-07 Thread vasudevram
other samples) on one of my sites, and then put a link to it here. - Vasudev. vasudevram wrote: > Publishing ODBC database content as PDF: > > A blog post by me on how to do this, using my PDF conversion toolkit, > xtopdf. > This is sample code from my next upcoming release of xtopdf,

Publishing ODBC database content as PDF

2006-07-07 Thread vasudevram
Publishing ODBC database content as PDF: A blog post by me on how to do this, using my PDF conversion toolkit, xtopdf. This is sample code from my next upcoming release of xtopdf, which will support more input formats, such as CSV, XLS, TDV and ODBC data. http://jugad.livejournal.com/2006/07/07

  1   2   3   >