On Apr 9, 8:20 am, Lukasz Szybalski <[email protected]> wrote:
> On Wed, Apr 8, 2009 at 11:36 PM, mdoar <[email protected]> wrote:
>
> > This is what's working for me with 0.5.3
>
> > raw_cs = "SERVER=%s;DATABASE=%s;UID=%s;PWD=%s" % (server, database,
> > userid, password)
> > connection_string = "%s:///?odbc_connect=%s" % (databasetype,
> > urllib.quote_plus(raw_cs))
> > if databasetype in ['mssql']:
> > connection_string += urllib.quote_plus(";DRIVER={SQL
> > Server};TDS_Version=8.0")
>
> > echoOn = True # For debugging the SQL statements
> > engine = create_engine(connection_string, echo=echoOn)
>
> What version of pyodbc are you using?
>
Latest and greatest stable
~Matt
> Thanks,
> Lucas
>
>
>
>
>
> > If TDSVER is not seen and the default version is used, you may get
> > SystemError: 'finally' pops bad exception
>
> > Now that said I have also had to force the version with
>
> > ./configure --with-tdsver=8.0
> > make
> > sudo make install
>
> > or
>
> > export TDSVER=8.0
>
> > or if you can't redeploy freetds copy freetds.conf to ~/.freetds.conf
> > and change the version in that file to 8.0
>
> > FreeTS, ODBC, pyODBC and then SQLAlchemy: what a house of cards!
>
> > ~Matt
>
> > On Apr 7, 12:58 pm, Lukasz Szybalski <[email protected]> wrote:
> >> Hello,
>
> >> Is this still proper connection string for mssql where I specify the
> >> tds version and a connection driver name?
>
> >> e =
> >> sqlalchemy.create_engine("mssql://user:p...@server:1433/db_name?driver=TDS&odbc_options='TDS_Version=8.0'")
>
> >> What is the syntax for driver, and how can I pass "TDS_Version=8.0" to
> >> the end of connection string?
>
> >> Thanks,
> >> Lucas
>
> >> File
> >> "/home/lucas/tmp/saENV/lib/python2.5/site-packages/SQLAlchemy-0.5.3-py2.5.egg/sqlalchemy/pool.py",
> >> line 198, in __init__
> >> self.connection = self.__connect()
> >> File
> >> "/home/lucas/tmp/saENV/lib/python2.5/site-packages/SQLAlchemy-0.5.3-py2.5.egg/sqlalchemy/pool.py",
> >> line 261, in __connect
> >> connection = self.__pool._creator()
> >> File
> >> "/home/lucas/tmp/saENV/lib/python2.5/site-packages/SQLAlchemy-0.5.3-py2.5.egg/sqlalchemy/engine/strategies.py",
> >> line 80, in connect
> >> raise exc.DBAPIError.instance(None, None, e)
> >> sqlalchemy.exc.DBAPIError: (Error) ('08001', '[08001]
> >> [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (0)
> >> (SQLDriverConnectW)') None None
>
> >> --
> >> How to create python package?http://lucasmanual.com/mywiki/PythonPaste
> >> DataHub - create a package that gets, parses, loads, visualizes
> >> datahttp://lucasmanual.com/mywiki/DataHub
>
> --
> How to create python package?http://lucasmanual.com/mywiki/PythonPaste
> DataHub - create a package that gets, parses, loads, visualizes
> datahttp://lucasmanual.com/mywiki/DataHub
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
