On Wed, Apr 8, 2009 at 11:36 PM, mdoar <md...@pobox.com> 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?
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 <szybal...@gmail.com> 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 data
http://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 sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
