if somebody is experiencing same errors in first steps with pyramid and ms sql server: I found the reason for "Pyramid is having a problem using your SQL database" SqlAlchemy tried to execute:
SELECT TOP 1 models.id AS models_id, models.name AS models_name, models.value AS models_value FROM models WHERE models.name = 'one' and got error : "The data types text and varchar are incompatible in the equal to operator" When I changed column "models.name" type from "text" to "nvarchar" it works my second question for legacy tables is still open for help :-) Dana srijeda, 1. listopada 2014. 22:08:37 UTC+2, korisnik Alen Cerovic napisao je: > 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 <cerovi...@gmail.com> 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 <cerovi...@gmail.com> >>>> 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 pylons-discus...@googlegroups.com. >>>> > To post to this group, send email to pylons-...@googlegroups.com. >>>> > 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 pylons-discus...@googlegroups.com. >>> To post to this group, send email to pylons-...@googlegroups.com. >>> 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 pylons-discuss+unsubscr...@googlegroups.com. To post to this group, send email to pylons-discuss@googlegroups.com. Visit this group at http://groups.google.com/group/pylons-discuss. For more options, visit https://groups.google.com/d/optout.