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.