What does the traceback say? That exact line would trigger an error much like the one you are seeing, if the object in “connection.connection” is a pyodbc.Connection and doesn’t have a “dbms_ver” attribute.
Note that there are at least 3 packages that could be involved here: pyodbc (https://pypi.python.org/pypi/pyodbc) ibm_db (https://pypi.python.org/pypi/ibm_db/) ibm_db_sa (https://pypi.python.org/pypi/ibm_db_sa) What versions do you have of each of them? Note that https://github.com/ibmdb/python-ibmdbsa/tree/master/ibm_db_sa says that pyodbc support is experimental. Simon > On 15 Feb 2016, at 21:07, Alex Hall <ah...@autodist.com> wrote: > > I just downloaded a fresh copy of 0.3.2, just in case I had somehow > gotten an old version from Pip. I looked in base.py, and found: > > def initialize(self, connection): > super(DB2Dialect, self).initialize(connection) > self.dbms_ver = connection.connection.dbms_ver > > While I'm not sure what I can do about it, it looks like this dbms_ver > property is definitely in the latest ibm_db_sa version. Am I getting > this from the wrong place, or confusing this with a different package > somehow? I *must* be missing something obvious. > > On 2/15/16, Alex Hall <ah...@autodist.com> wrote: >> An interesting development. I noticed that in site-packages\ibm_db_sa >> was pyodbc.py. Thinking that might be an older version, I renamed it, >> trying to force the import to use my installed version instead. It now >> says "cannot import name pyodbc". I thought Python searched the >> current directory, then the site-packages one, for modules? If so, and >> if I can import pyodbc with no errors in the shell, why would >> ibm_db_sa fail to import? This may be the problem--it was using an >> older version of pyodbc and can't find the newer one for some reason. >> Any ideas, or am I completely off track with this? >> >> On 2/15/16, Alex Hall <ah...@autodist.com> wrote: >>> Thanks guys. I've checked the version I'm using, and it reports that >>> ibm_db_sa.__version__ is '0.3.2'. I have both ibm_db_sa and ibm_db >>> installed. Should I remove ibm_db and rely only on ibm_db_sa instead? >>> Is the former package causing a conflict somehow? >>> >>> On 2/15/16, Jaimy Azle <jaimy.a...@gmail.com> wrote: >>>> Try to use ibm_db_sa 0.3.2 instead, apparently you are using the >>>> previous >>>> version. dbms_ver is a feature specific of native ibm_db version of >>>> which >>>> not available in pyodbc. >>>> >>>> https://pypi.python.org/pypi/ibm_db_sa/0.3.2 >>>> >>>> >>>> Salam, >>>> >>>> -Jaimy. >>>> >>>> >>>> On Feb 12, 2016 22:05, "Alex Hall" <ah...@autodist.com> wrote: >>>> >>>>> Hello list, >>>>> I've configured a DSN to a test version of my work's AS400 and I seem >>>>> to be able to connect just fine (Yes!) I'm now running into a problem >>>>> when I try to ask for a list of all tables. The line is: >>>>> >>>>> dbInspector = inspect(dbEngine) >>>>> >>>>> The traceback is very long, and I can paste it if you want, but it >>>>> ends with this: >>>>> >>>>> AttributeError: 'pyodbc.Connection' object has no attribute 'dbms_ver' >>>>> >>>>> I'm unable to find anything about this online, so thought I'd check >>>>> with this list. Here's my connection: >>>>> >>>>> dbEngine = create_engine("ibm_db_sa+pyodbc://user:pwd@myDSN") >>>>> >>>>> If anyone knows what is causing this, I'd appreciate your thoughts. >>>>> I've installed pyodbc, ibm_db, and ibm_db_sa through pip, so I should >>>>> have all the latest versions of everything. I'm on Windows 7x64, >>>>> Python 2.7 (latest). >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups >>>>> "sqlalchemy" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an >>>>> email to sqlalchemy+unsubscr...@googlegroups.com. >>>>> To post to this group, send email to sqlalchemy@googlegroups.com. >>>>> Visit this group at https://groups.google.com/group/sqlalchemy. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups >>>> "sqlalchemy" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an >>>> email to sqlalchemy+unsubscr...@googlegroups.com. >>>> To post to this group, send email to sqlalchemy@googlegroups.com. >>>> Visit this group at https://groups.google.com/group/sqlalchemy. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >> > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.