thnx, installed pyodbc, connection now works :-) but after initialize_MyApp_db which successfully created "models" table I still get error in browser "Pyramid is having a problem using your SQL database"
tried to install pymssql but got error : "unable to find vcvarsall.bat", will continue with pyodbc for now is there tutorial for working with legacy database, I want to make crud for existing tables, how do I define/scaffold a model without issuing "create table" statements noob, please help :-) Dana srijeda, 1. listopada 2014. 17:56:07 UTC+2, korisnik Michael Merickel napisao je: > You will need to install the driver package and any other dependencies > required by the particular dialect you are using. > > For example, for the pyodbc driver you will see the docs claim you > need to install pyodbc. > > > http://docs.sqlalchemy.org/en/rel_0_9/dialects/mssql.html#module-sqlalchemy.dialects.mssql.pyodbc > > > On Wed, Oct 1, 2014 at 9:09 AM, Alen Cerovic <[email protected] > <javascript:>> wrote: > > Hi, > > > > new to pyramid, actually installed it yesterday :) What would be correct > > "sqlalchemy.url" in "development.ini" to connect to ms sql server > > > > I tried : > > sqlalchemy.url = > mssql://username:password@ServerIP\ServerInstancce/DbName > > > > but getting error: > > return __import__('pyodbc') > > ImportError: No module named pyodbc > > > > tried also: > > > > sqlalchemy.url = mssql+pyodbc://DSN=py_test > > > > py_test is DSN name on my Win7 machine but same error > > > > Please help > > > > -- > > You received this message because you are subscribed to the Google > Groups > > "pylons-discuss" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to [email protected] <javascript:>. > > To post to this group, send email to [email protected] > <javascript:>. > > Visit this group at http://groups.google.com/group/pylons-discuss. > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "pylons-discuss" 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/pylons-discuss. For more options, visit https://groups.google.com/d/optout.
