Re: [python-win32] odbc exceptions

2010-12-01 Thread Robin Becker
On 01/12/2010 16:22, Preston Landers wrote: No, it appears you're getting a different (and expected) error now. "[ODBC Driver Manager] Data source name not found and no default driver specified in LOGIN" That means you didn't give a valid ODBC connection string when you tried to create a connec

Re: [python-win32] odbc exceptions

2010-12-01 Thread Preston Landers
No, it appears you're getting a different (and expected) error now. "[ODBC Driver Manager] Data source name not found and no default driver specified in LOGIN" That means you didn't give a valid ODBC connection string when you tried to create a connection. Earlier you were getting "TypeError: e

Re: [python-win32] odbc exceptions

2010-12-01 Thread Robin Becker
On 01/12/2010 00:28, Vernon Cole wrote: even more important, also install a new copy of pywin32. http://sourceforge.net/projects/pywin32/ ... OK I have installed both python 2.6.6 and the latest pywin32 ie build 214 for 2.6 (before I had 212). I'm still getting that error. C:\code\rlex

Re: [python-win32] odbc exceptions

2010-11-30 Thread Vernon Cole
On Tue, Nov 30, 2010 at 10:25 AM, Preston Landers wrote: > That's strange. I don't get that under Python 2.6.5 and PyWin32 v214. I > get the kind of error one would expect. > > >>> try: > ... odbc.odbc("asdf") > ... except: > ... raise > ... > Traceback (most recent call last): > File "", lin

Re: [python-win32] odbc exceptions

2010-11-30 Thread Preston Landers
That's strange. I don't get that under Python 2.6.5 and PyWin32 v214. I get the kind of error one would expect. >>> try: ... odbc.odbc("asdf") ... except: ... raise ... Traceback (most recent call last): File "", line 2, in dbi.opError: [Microsoft][ODBC Driver Manager] Data source name not f

Re: [python-win32] odbc exceptions

2010-11-30 Thread Vernon Cole
Robin: Odbc is still maintained. It is not deprecated, exactly, but is obsolescent since it uses db api version 1 calls. It is maintained that way so that it doesn't break old code. The bug report is appreciated, I'll make sure it gets into the sourceforge bug list if you don't beat me to it. The

[python-win32] odbc exceptions

2010-11-30 Thread Robin Becker
I don't know if the odbc module is deprecated, but I'm seeing this strangeness C:\code\rlextra\examples\graphics>cat toad.py try: import odbc print odbc.__file__ conn = odbc.odbc('not_a_db_path') except: raise C:\code\rlextra\examples\graphics>toad.py C:\Python26\lib\site-package