thnx pb, made it partially working, after initialize_MyApp_db which successfully created "models" table I still get error in browser "Pyramid is having a problem using your SQL database"
another question: how to define models for existing database tables and tell pyramid not to alter my existing tables Dana srijeda, 1. listopada 2014. 20:04:42 UTC+2, korisnik pb napisao je: > Hi, > > I have 32bit python 2.7, 32 bit windows, pyodbc 3.0.6, and sqlalchemy 0.8, > and my connection string > is something like: > > mssql://username:password@hostname/dbname?driver=SQL Server Native Client > 10.0;unicode_results=True > > where driver=... is the same text I found in the ODBC data source > administrator on the tab Drivers. > > I didn't need any pymssql, as pyodbc uses odbc drivers. You need to find a > binary package > of pyodbc. I think I use the one from: > https://code.google.com/p/pyodbc/downloads/list > > -- > Petr > > > On Wed, Oct 1, 2014 at 6:45 PM, Alen Cerovic <[email protected] > <javascript:>> wrote: > >> 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]> >>> 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]. >>> > 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. >>> >> -- >> 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. >> > > > > -- > ____________________ > http://pysk.blog.root.cz/ > -- 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.
