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 <cerovic.a...@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-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. > -- ____________________ 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.