haven’t seen pyodbc work on Python 3 myself, it might not be ready for primetime. I’d look into pymssql instead it’s well maintained and should have direct py3k support.
> On Nov 13, 2014, at 8:48 PM, Matthew Albert <[email protected]> wrote: > > Thx Mike, > > I've been here before. I'm using windows 64bit and python 3.4. I only find > pyodbc for <=v3.3 here. Errors because of lacking python 3.3 registry entry. > > Somebody on stackoverflow suggested this site for 3.4. > http://www.lfd.uci.edu/~gohlke/pythonlibs/#pyodbc > > I downloaded and ran the binary install from this site, seemed to go ok, > although python still can't seem to find the module. The installation wizard > correctly identifies the Python34 path and suggests to install at > \Python34\Lib\site-packages which all seems reasonable. The actually install > process completes almost instantaneously which seems a little suspicious. > The closest thing to pyodbc I see in ..\site-packages is a folder named: > \pyodbc-3.0.7-py3.4.egg-info > > Any thoughts on what is going on? > > thx > Matt > > > On Thursday, November 13, 2014 5:10:06 PM UTC-5, Matthew Albert wrote: > Hi, > > I'm trying to make a connection to a 2012 MS SQL database using python 3.4 > and SQLAlchemy/pyodbc. > > I don't have pyodbc, but noticed that the install of SQLAlchemy included it. > I've copied my code below to select the first value from the table > 'Mezzanines'. Please note the connection string: > 'mssql+pyodbc://TheServer//TheDB' > > Attempting to connection using windows authentication. > > Traceback error shown below. No module named 'pyodbc'. Is this because > create_engine is trying to find module pyodbc in the sys.path? Do I need to > put pyodbc in the sys.path? > > thx > Matt > > > ________________________________________________ > from sqlalchemy import create_engine > from sqlalchemy.orm import sessionmaker > > from sqlalchemy_declarative import Address, Base, Person > from sqlalchemy.connectors import pyodbc > > engine = create_engine('mssql+pyodbc://TheServer//TheDB') > > Base.metadata.bind = engine > > DBSession = sessionmaker(bind=engine) > session = DBSession() > > # Write the query > mezz = session.query('Mezzanines').first() > print(mezz.name <http://mezz.name/>) > __________________________________________________ > > Traceback (most recent call last): > File "C:/Python34/Programs/SQLAlchemy Tutorial/sqlalchemy_insert.py", line > 7, in <module> > engine = create_engine('mssql+pyodbc://gtasfdm') > File "C:\Python34\lib\site-packages\sqlalchemy\engine\__init__.py", line > 362, in create_engine > return strategy.create(*args, **kwargs) > File "C:\Python34\lib\site-packages\sqlalchemy\engine\strategies.py", line > 74, in create > dbapi = dialect_cls.dbapi(**dbapi_args) > File "C:\Python34\lib\site-packages\sqlalchemy\connectors\pyodbc.py", line > 51, in dbapi > return __import__('pyodbc') > ImportError: No module named 'pyodbc' > > -- > 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 [email protected] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at http://groups.google.com/group/sqlalchemy > <http://groups.google.com/group/sqlalchemy>. > For more options, visit https://groups.google.com/d/optout > <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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
